APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on HR_API

Line 2500: and nvl(pdp.cvg_thru_dt,hr_api.g_eot)

2496: and pen.prtt_enrt_rslt_stat_cd is null
2497: and pen.pl_id = p_pl_id
2498: and l_cvg_det_dt
2499: between pdp.cvg_strt_dt
2500: and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
2501: and pdp.cvg_strt_dt is not null
2502: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
2503: between pdp.effective_start_date
2504: and pdp.effective_end_date