DBA Data[Home] [Help]

APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on BEN_PL_F

Line 284: ben_pl_f pln

280: (p_plip_id is not null and pep.ptip_id is not null and exists
281: (select null
282: from ben_ptip_f ptip,
283: ben_plip_f plip,
284: ben_pl_f pln
285: where ptip.ptip_id = pep.ptip_id
286: and ptip.pgm_id = p_pgm_id
287: and plip.plip_id = p_plip_id
288: and pln.pl_id = plip.pl_id

Line 328: ben_pl_f pln

324: (p_ptip_id is not null and pep.plip_id is not null and exists
325: (select null
326: from ben_ptip_f ptip,
327: ben_plip_f plip,
328: ben_pl_f pln
329: where ptip.ptip_id = p_ptip_id
330: and ptip.pgm_id = p_pgm_id
331: and ptip.pl_typ_id = pln.pl_typ_id
332: and plip.pl_id = pln.pl_id

Line 509: ben_pl_f pl

505: cursor c_ptip is
506: select ptip.ptip_id,ptip.ordr_num
507: from ben_ptip_f ptip,
508: ben_plip_f plip,
509: ben_pl_f pl
510: where ptip.pgm_id = l_elig_per.pgm_id
511: and ptip.pl_typ_id = pl.pl_typ_id
512: and pl.pl_id = plip.pl_id
513: and plip.plip_id = l_elig_per.plip_id