APPS.BEN_PEN_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 39: ben_elig_per_elctbl_chc epe,

35: epe.MUST_ENRL_ANTHR_PL_ID,
36: 'N' dpnt_cvd_by_othr_apls_flag,
37: -9999999999999999999999999999999999999 opt_id
38: from ben_prtt_enrt_rslt_f pen,
39: ben_elig_per_elctbl_chc epe,
40: /*Bug#: 3255596: Fetching plip_id from CPP record
41: when plip_id is null in EPE record*/
42: ben_plip_f cpp
43: /* End Bug#: 3255596: change */

Line 141: ben_elig_per_elctbl_chc epe,

137: /*
138: cop.opt_id
139: */
140: from ben_prtt_enrt_rslt_f pen,
141: ben_elig_per_elctbl_chc epe,
142: ben_pil_elctbl_chc_popl pel,
143: /*
144: ben_oipl_f cop,
145: */

Line 212: ben_elig_per_elctbl_chc epe,

208: epe.MUST_ENRL_ANTHR_PL_ID,
209: pln.dpnt_cvd_by_othr_apls_flag,
210: cop.opt_id
211: from ben_prtt_enrt_rslt_f pen,
212: ben_elig_per_elctbl_chc epe,
213: ben_oipl_f cop,
214: ben_pl_f pln
215: where pen.person_id = p_person_id
216: and pen.prtt_enrt_rslt_stat_cd is null

Line 276: ben_elig_per_elctbl_chc epe,

272: epe.MUST_ENRL_ANTHR_PL_ID,
273: 'N' dpnt_cvd_by_othr_apls_flag,
274: cop.opt_id
275: from ben_prtt_enrt_rslt_f pen,
276: ben_elig_per_elctbl_chc epe,
277: ben_oipl_f cop,
278: ben_per_in_ler pil
279: where pil.person_id = p_person_id
280: and pil.per_in_ler_stat_cd = 'STRTD'