APPS.BENUTILS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 6122: from ben_elig_cvrd_dpnt_f pdp,

6118: and epe.pil_elctbl_chc_popl_id = epo.pil_elctbl_chc_popl_id ;
6119: --
6120: cursor c_exists_prev is
6121: select 'Y'
6122: from ben_elig_cvrd_dpnt_f pdp,
6123: ben_per_in_ler pil
6124: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6125: and pdp.cvg_thru_dt = hr_api.g_eot
6126: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why

Line 6136: from ben_elig_cvrd_dpnt_f pdp,

6132: --
6133: cursor c_exists_prev_other_option is
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