APPS.BENUTILS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 5997: from ben_elig_cvrd_dpnt_f pdp,

5993: and epe.pil_elctbl_chc_popl_id = epo.pil_elctbl_chc_popl_id ;
5994: --
5995: cursor c_exists_prev is
5996: select 'Y'
5997: from ben_elig_cvrd_dpnt_f pdp,
5998: ben_per_in_ler pil
5999: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6000: and pdp.cvg_thru_dt = hr_api.g_eot
6001: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why

Line 6011: from ben_elig_cvrd_dpnt_f pdp,

6007: --
6008: cursor c_exists_prev_other_option is
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