APPS.BEN_PEN_BUS dependencies on BEN_PER_IN_LER

Line 80: from ben_per_in_ler pil

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

Line 149: ben_per_in_ler pil

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

Line 252: from ben_per_in_ler pil

248: cop.effective_start_date (+) and cop.effective_end_date (+)
249: and pen.comp_lvl_cd not in ('PLANFC','PLANIMP')
250: and (epe.per_in_ler_id is null or
251: exists (select null
252: from ben_per_in_ler pil
253: where pil.per_in_ler_id = epe.per_in_ler_id
254: and pil.business_group_id = epe.business_group_id
255: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')))
256: and pen.pl_id = pln.pl_id

Line 290: ben_per_in_ler pil

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
292: and pil.per_in_ler_stat_cd = 'STRTD'
293: and epe.per_in_ler_id = pil.per_in_ler_id
294: and nvl(epe.pgm_id,-999999) = nvl(p_pgm_id, -999999)