How to remove accruals as of a particular date

Summary:

Content (required):

Hi All,

We have a requirement where accrual balance should be set to zero if the Calculate Accruals and Balances process is run after 31st of Jan every year. Hence I have used the below piece of code.

ld_effective_date= GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00'(date)) 

l_effective_cutoff_date = trunc(to_date('31/01/'||to_char(ld_effective_date,'YYYY'),'DD/MM/YYYY'))

if(ld_effective_date > l_effective_cutoff_date)

THEN

(

accrual = 0

)

return accrual

This code is generating the expected value (accrual = 0) in the log file. But in the front end, it's showing the actual balance as of that date.