DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on HR_API

Line 967: AND pen.effective_end_date = hr_api.g_eot

963: FROM ben_prtt_enrt_rslt_f pen
964: WHERE pen.person_id = p_person_id
965: AND pen.sspndd_flag = 'N'
966: AND pen.prtt_enrt_rslt_stat_cd IS NULL
967: AND pen.effective_end_date = hr_api.g_eot
968: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
969: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
970: -- AND pen.oipl_id IS NULL
971: AND p_pl_id = pen.pl_id

Line 988: AND pen.effective_end_date = hr_api.g_eot

984: FROM ben_prtt_enrt_rslt_f pen
985: WHERE pen.person_id = p_person_id
986: AND pen.sspndd_flag = 'N'
987: AND pen.prtt_enrt_rslt_stat_cd IS NULL
988: AND pen.effective_end_date = hr_api.g_eot
989: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
990: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
991: AND p_oipl_id = pen.oipl_id
992: AND (