APPS.BENUTILS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 5034: from ben_prtt_enrt_rslt_f pen,

5030: --l_package varchar2(80) := g_package||'.get_post_enrt_cvg_and_rt_val';
5031: --
5032: cursor c_pen_bnft_amt is
5033: select pen.bnft_amt
5034: from ben_prtt_enrt_rslt_f pen,
5035: ben_elig_per_elctbl_chc epe,
5036: ben_enrt_bnft enb
5037: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5038: and enb.enrt_bnft_id = p_enrt_bnft_id

Line 6138: ben_prtt_enrt_rslt_f pnr,

6134: select 'Y'
6135: from dual where exists( select null
6136: from ben_elig_cvrd_dpnt_f pdp,
6137: ben_per_in_ler pil,
6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen
6140: where pdp.dpnt_person_id = p_dpnt_person_id
6141: --and pdp.cvg_thru_dt = hr_api.g_eot
6142: and pdp.effective_end_date = hr_api.g_eot

Line 6139: ben_prtt_enrt_rslt_f pen

6135: from dual where exists( select null
6136: from ben_elig_cvrd_dpnt_f pdp,
6137: ben_per_in_ler pil,
6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen
6140: where pdp.dpnt_person_id = p_dpnt_person_id
6141: --and pdp.cvg_thru_dt = hr_api.g_eot
6142: and pdp.effective_end_date = hr_api.g_eot
6143: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id