APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_PRTT_ENRT_RSLT_F

Line 963: FROM ben_prtt_enrt_rslt_f pen

959: p_person_id number,
960: p_pgm_id number,
961: p_pl_id number) IS
962: SELECT 'Y'
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

Line 984: FROM ben_prtt_enrt_rslt_f pen

980: p_person_id number,
981: p_pgm_id number,
982: p_oipl_id number ) IS
983: SELECT 'Y'
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