APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on BEN_PLIP_F

Line 272: from ben_plip_f plip

268: pep.elig_per_id = p_elig_per_id
269: ) or
270: (p_pl_id is not null and pep.plip_id is not null and exists
271: (select null
272: from ben_plip_f plip
273: where plip.plip_id = pep.plip_id
274: and plip.pl_id = p_pl_id
275: and plip.pgm_id = p_pgm_id
276: and p_effective_date between plip.effective_start_date and

Line 283: ben_plip_f plip,

279: ) or
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

Line 327: ben_plip_f plip,

323: ) or
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

Line 347: from ben_plip_f plip

343: and pln.business_group_id = p_business_group_id)
344: ) or
345: (p_plip_id is not null and pep.pl_id is not null and exists
346: (select null
347: from ben_plip_f plip
348: where plip.plip_id = p_plip_id
349: and plip.pgm_id = p_pgm_id
350: and plip.pl_id = pep.pl_id
351: and p_effective_date between plip.effective_start_date and

Line 499: from ben_plip_f plip

495: l_dummy varchar2(1);
496:
497: cursor c_plip is
498: select plip.plip_id,plip.ordr_num
499: from ben_plip_f plip
500: where plip.pl_id = l_elig_per.pl_id
501: and plip.pgm_id = l_elig_per.pgm_id
502: and l_eff_dt between plip.effective_start_date
503: and plip.effective_end_date;

Line 508: ben_plip_f plip,

504:
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