APPS.GHR_EXEMP_PURGE dependencies on FND_DATE

Line 22: AND TRUNC(EFFECTIVE_END_DATE) = FND_DATE.CANONICAL_TO_DATE('4712/12/31');

18: AND BUSINESS_GROUP_ID = l_business_group
19: AND PERSON_TYPE_ID IN (SELECT PERSON_TYPE_ID FROM PER_PERSON_TYPES
20: WHERE BUSINESS_GROUP_ID = l_business_group AND
21: SYSTEM_PERSON_TYPE in ('EX_EMP', 'EX_CWK'))
22: AND TRUNC(EFFECTIVE_END_DATE) = FND_DATE.CANONICAL_TO_DATE('4712/12/31');
23:
24: CURSOR get_months_years(p_eff_date in date)
25: IS
26: SELECT trunc(months_between(sysdate,p_eff_date)/12) years,