APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 86: from ben_elig_per_elctbl_chc epe,

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

Line 111: from ben_elig_per_elctbl_chc epe

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

Line 770: from ben_elig_per_elctbl_chc epe,

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