APPS.BEN_PEN_BUS dependencies on BEN_PER_IN_LER

Line 77: from ben_per_in_ler pil

73: and pen.per_in_ler_id = epe.per_in_ler_id (+)
74: and pen.comp_lvl_cd not in ('PLANFC','PLANIMP')
75: and (epe.per_in_ler_id is null or
76: exists (select null
77: from ben_per_in_ler pil
78: where pil.per_in_ler_id = epe.per_in_ler_id
79: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'))
80: )
81: /*Bug#: 3255596: Fetching plip_id from CPP record

Line 146: ben_per_in_ler pil

142: ben_pil_elctbl_chc_popl pel,
143: /*
144: ben_oipl_f cop,
145: */
146: ben_per_in_ler pil
147: where pil.person_id = c_person_id
148: and pil.per_in_ler_stat_cd = 'STRTD'
149: and epe.per_in_ler_id = pil.per_in_ler_id
150: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 240: from ben_per_in_ler pil

236: cop.effective_start_date (+) and cop.effective_end_date (+)
237: and pen.comp_lvl_cd not in ('PLANFC','PLANIMP')
238: and (epe.per_in_ler_id is null or
239: exists (select null
240: from ben_per_in_ler pil
241: where pil.per_in_ler_id = epe.per_in_ler_id
242: and pil.business_group_id = epe.business_group_id
243: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')))
244: and pen.pl_id = pln.pl_id

Line 278: ben_per_in_ler pil

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'
281: and epe.per_in_ler_id = pil.per_in_ler_id
282: and nvl(epe.pgm_id,-999999) = nvl(p_pgm_id, -999999)