APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 89: from ben_elig_per_elctbl_chc epe,

85: epe.dpnt_cvg_strt_dt_rl,
86: epe.pgm_id,
87: epe.pl_id,
88: epe.ptip_id
89: from ben_elig_per_elctbl_chc epe,
90: ben_oipl_f oipl
91: where epe.per_in_ler_id = p_per_in_ler_id
92: and epe.pl_id = p_pl_id
93: and epe.oipl_id = oipl.oipl_id

Line 114: from ben_elig_per_elctbl_chc epe

110: epe.dpnt_cvg_strt_dt_rl,
111: epe.pgm_id,
112: epe.pl_id,
113: epe.ptip_id
114: from ben_elig_per_elctbl_chc epe
115: where epe.per_in_ler_id = p_per_in_ler_id
116: and epe.oipl_id IS NULL --- SAVINGS PLAN FIX
117: and epe.pl_id = p_pl_id
118: and epe.elctbl_flag = 'Y'

Line 773: from ben_elig_per_elctbl_chc epe,

769: l_dummy varchar2(30);
770: --
771: cursor c_pl_opt_name(p_epe_id number) is
772: select pln.name || ' '|| opt.name
773: from ben_elig_per_elctbl_chc epe,
774: ben_pl_f pln,
775: ben_oipl_f oipl,
776: ben_opt_f opt
777: where epe.elig_per_elctbl_chc_id = p_epe_id