APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_PRTT_ENRT_RSLT_F

Line 965: FROM ben_prtt_enrt_rslt_f pen

961: p_person_id number,
962: p_pgm_id number,
963: p_pl_id number) IS
964: SELECT 'Y'
965: FROM ben_prtt_enrt_rslt_f pen
966: WHERE pen.person_id = p_person_id
967: AND pen.sspndd_flag = 'N'
968: AND pen.prtt_enrt_rslt_stat_cd IS NULL
969: AND pen.effective_end_date = hr_api.g_eot

Line 986: FROM ben_prtt_enrt_rslt_f pen

982: p_person_id number,
983: p_pgm_id number,
984: p_oipl_id number ) IS
985: SELECT 'Y'
986: FROM ben_prtt_enrt_rslt_f pen
987: WHERE pen.person_id = p_person_id
988: AND pen.sspndd_flag = 'N'
989: AND pen.prtt_enrt_rslt_stat_cd IS NULL
990: AND pen.effective_end_date = hr_api.g_eot