APPS.BENUTILS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 4909: from ben_prtt_enrt_rslt_f pen,

4905: --l_package varchar2(80) := g_package||'.get_post_enrt_cvg_and_rt_val';
4906: --
4907: cursor c_pen_bnft_amt is
4908: select pen.bnft_amt
4909: from ben_prtt_enrt_rslt_f pen,
4910: ben_elig_per_elctbl_chc epe,
4911: ben_enrt_bnft enb
4912: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
4913: and enb.enrt_bnft_id = p_enrt_bnft_id

Line 6013: ben_prtt_enrt_rslt_f pnr,

6009: select 'Y'
6010: from dual where exists( select null
6011: from ben_elig_cvrd_dpnt_f pdp,
6012: ben_per_in_ler pil,
6013: ben_prtt_enrt_rslt_f pnr,
6014: ben_prtt_enrt_rslt_f pen
6015: where pdp.dpnt_person_id = p_dpnt_person_id
6016: --and pdp.cvg_thru_dt = hr_api.g_eot
6017: and pdp.effective_end_date = hr_api.g_eot

Line 6014: ben_prtt_enrt_rslt_f pen

6010: from dual where exists( select null
6011: from ben_elig_cvrd_dpnt_f pdp,
6012: ben_per_in_ler pil,
6013: ben_prtt_enrt_rslt_f pnr,
6014: ben_prtt_enrt_rslt_f pen
6015: where pdp.dpnt_person_id = p_dpnt_person_id
6016: --and pdp.cvg_thru_dt = hr_api.g_eot
6017: and pdp.effective_end_date = hr_api.g_eot
6018: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id