APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on HR_API

Line 204: and rslt.enrt_cvg_thru_dt = hr_api.g_eot; -- Bug 4388226 - End-dated suspended enrl shudn't be picked up.

200: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
201: and rslt.prtt_enrt_rslt_stat_cd is null
202: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU' )
203: and rslt.business_group_id = c_bgp_id
204: and rslt.enrt_cvg_thru_dt = hr_api.g_eot; -- Bug 4388226 - End-dated suspended enrl shudn't be picked up.
205: --
206: l_pen_mxesd date;
207: --
208: BEGIN

Line 327: pen.enrt_cvg_thru_dt = hr_api.g_eot

323: AND pen.prtt_enrt_rslt_stat_cd IS NULL
324: --AND pen.sspndd_flag = 'N'
325: AND (pen.sspndd_flag = 'N' --CFW
326: OR (pen.sspndd_flag = 'Y' and
327: pen.enrt_cvg_thru_dt = hr_api.g_eot
328: )
329: )
330: AND pen.effective_end_date = hr_api.g_eot
331: AND c_cvgthrudt <= pen.enrt_cvg_thru_dt

Line 330: AND pen.effective_end_date = hr_api.g_eot

326: OR (pen.sspndd_flag = 'Y' and
327: pen.enrt_cvg_thru_dt = hr_api.g_eot
328: )
329: )
330: AND pen.effective_end_date = hr_api.g_eot
331: AND c_cvgthrudt <= pen.enrt_cvg_thru_dt
332: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
333: AND c_ptip_id = pen.ptip_id
334: AND plip.pgm_id = pen.pgm_id