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 143: from ben_prtt_enrt_rslt_f pen,

139: -9999999999999999999999999999999999999 opt_id
140: /*
141: cop.opt_id
142: */
143: from ben_prtt_enrt_rslt_f pen,
144: ben_elig_per_elctbl_chc epe,
145: ben_pil_elctbl_chc_popl pel,
146: /*
147: ben_oipl_f cop,

Line 223: from ben_prtt_enrt_rslt_f pen,

219: epe.elig_per_elctbl_chc_id,
220: epe.MUST_ENRL_ANTHR_PL_ID,
221: pln.dpnt_cvd_by_othr_apls_flag,
222: cop.opt_id
223: from ben_prtt_enrt_rslt_f pen,
224: ben_elig_per_elctbl_chc epe,
225: ben_oipl_f cop,
226: ben_pl_f pln
227: where pen.person_id = p_person_id

Line 287: from ben_prtt_enrt_rslt_f pen,

283: epe.elig_per_elctbl_chc_id,
284: epe.MUST_ENRL_ANTHR_PL_ID,
285: 'N' dpnt_cvd_by_othr_apls_flag,
286: cop.opt_id
287: from ben_prtt_enrt_rslt_f pen,
288: ben_elig_per_elctbl_chc epe,
289: ben_oipl_f cop,
290: ben_per_in_ler pil
291: where pil.person_id = p_person_id