APPS.BEN_PEN_BUS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 38: from ben_prtt_enrt_rslt_f pen,

34: epe.elig_per_elctbl_chc_id,
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

Line 140: from ben_prtt_enrt_rslt_f pen,

136: -9999999999999999999999999999999999999 opt_id
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,

Line 211: from ben_prtt_enrt_rslt_f pen,

207: epe.elig_per_elctbl_chc_id,
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

Line 275: from ben_prtt_enrt_rslt_f pen,

271: epe.elig_per_elctbl_chc_id,
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