APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 170: from ben_prtt_enrt_rslt_f pen

166: -- Added the cursor to fix bug 1644520
167: --Bug 4414127
168: cursor c_pgm_elcns_made_dt is
169: select max(pen.EFFECTIVE_START_DATE) elcns_made_dt
170: from ben_prtt_enrt_rslt_f pen
171: where pen.per_in_ler_id = p_per_in_ler_id
172: and pen.pgm_id = p_pgm_id
173: and pen.prtt_enrt_rslt_stat_cd is null
174: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

Line 178: from ben_prtt_enrt_rslt_f pen

174: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
175: --Bug 4414127
176: cursor c_pl_elcns_made_dt is
177: select max(pen.EFFECTIVE_START_DATE) elcns_made_dt
178: from ben_prtt_enrt_rslt_f pen
179: where pen.per_in_ler_id = p_per_in_ler_id
180: and pen.pl_id = p_pl_id
181: and pen.prtt_enrt_rslt_stat_cd is null
182: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

Line 361: from ben_prtt_enrt_rslt_f pen,

357: is
358: select pen.*,
359: enb.elig_per_elctbl_chc_id,
360: enb.enrt_bnft_id
361: from ben_prtt_enrt_rslt_f pen,
362: ben_enrt_bnft enb,
363: ben_elig_per_elctbl_chc epe
364: where pen.person_id = c_person_id
365: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd

Line 424: FROM ben_prtt_enrt_rslt_f pen

420: IS
421: SELECT 'Y' interim_flag,
422: prtt_enrt_rslt_id suspended_pen_id,
423: object_version_number suspended_ovn
424: FROM ben_prtt_enrt_rslt_f pen
425: WHERE pen.rplcs_sspndd_rslt_id = c_interim_pen
426: AND pen.person_id = c_person_id
427: AND pen.prtt_enrt_rslt_stat_cd IS NULL
428: AND pen.per_in_ler_id = c_per_in_ler_id