GET_PAYROLL_PERIOD Get function not returning value

Summary:

Default for PER_ASG_REL_ACTUAL_TERMINATION_DATE is '0001/01/01 00:00:00' (date)

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

ld_term_date = PER_ASG_REL_ACTUAL_TERMINATION_DATE

ld_payroll_id = GET_CONTEXT(PAYROLL_ID, 0)

l_debug= ESS_LOG_WRITE('ldpayroll_id is: '|| to_char(ld_payroll_id))

CHANGE_CONTEXTS(PAYROLL_ID = ld_payroll_id)

(

E = GET_PAYROLL_PERIOD(ld_effective_date)

l_pay_period_sd = GET_DATE('PAYROLL_PERIOD_START_DATE')

l_pay_period_ed = GET_DATE('PAYROLL_PERIOD_END_DATE')

)

enrollmentEndDate = ld_effective_date

l_debug= ESS_LOG_WRITE('ld_term_date is: '|| to_char(ld_term_date))