BEN_PIL_LF_EVT_OCRD_DT DBI is not returning Life Event Occurred date its always 1951/01/01
Summary:
I want to get the Life event occurred date, So, I used BEN_PIL_LF_EVT_OCRD_DT DBI in the fast formula. but it always shows 1951/01/01
Content (please ensure you mask any confidential information):
DEFAULT FOR BEN_PIL_LF_EVT_OCRD_DT is '1951/01/01 00:00:00'(date)
DEFAULT FOR PER_ASG_ASSIGNMENT_ID is 0
DEFAULT for CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT is 0
DEFAULT FOR PER_ASG_ATTRIBUTE1 IS '00'
ELIGIBLE = 'Y'
l_eff_date = BEN_PIL_LF_EVT_OCRD_DT
l_eff_new_hire = BEN_PIL_LF_EVT_OCRD_DT
l_eff_year_char = TO_CHAR(l_eff_date,'YYYY')
0