APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 178: from ben_prtt_enrt_rslt_f pen

174: -- Added the cursor to fix bug 1644520
175: --Bug 4414127
176: cursor c_pgm_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.pgm_id = p_pgm_id
181: and pen.prtt_enrt_rslt_stat_cd is null
182: and pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 187: from ben_prtt_enrt_rslt_f pen

183: and pen.comp_lvl_cd <> 'PLANIMP'; -- Bug 13367099
184: --Bug 4414127
185: cursor c_pl_elcns_made_dt is
186: select max(pen.EFFECTIVE_START_DATE) elcns_made_dt
187: from ben_prtt_enrt_rslt_f pen
188: where pen.per_in_ler_id = p_per_in_ler_id
189: and pen.pl_id = p_pl_id
190: and pen.prtt_enrt_rslt_stat_cd is null
191: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

Line 370: from ben_prtt_enrt_rslt_f pen,

366: is
367: select pen.*,
368: enb.elig_per_elctbl_chc_id,
369: enb.enrt_bnft_id
370: from ben_prtt_enrt_rslt_f pen,
371: ben_enrt_bnft enb,
372: ben_elig_per_elctbl_chc epe
373: where pen.person_id = c_person_id
374: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd

Line 439: FROM ben_prtt_enrt_rslt_f pen

435: IS
436: SELECT 'Y' interim_flag,
437: prtt_enrt_rslt_id suspended_pen_id,
438: object_version_number suspended_ovn
439: FROM ben_prtt_enrt_rslt_f pen
440: WHERE pen.rplcs_sspndd_rslt_id = c_interim_pen
441: AND pen.person_id = c_person_id
442: AND pen.prtt_enrt_rslt_stat_cd IS NULL
443: AND pen.per_in_ler_id = c_per_in_ler_id