eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on BEN_PTIP_F

Line 282: from ben_ptip_f ptip,

278: and plip.business_group_id = p_business_group_id)
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

Line 317: from ben_ptip_f ptip

313: and ( (p_pgm_id is not null and p_ptip_id is null and
314: p_plip_id is null and p_pl_id is null and
315: pep.ptip_id is not null and exists
316: (select null
317: from ben_ptip_f ptip
318: where ptip.ptip_id = pep.ptip_id
319: and ptip.pgm_id = p_pgm_id
320: and p_effective_date between ptip.effective_start_date and
321: ptip.effective_end_date

Line 326: from ben_ptip_f ptip,

322: and ptip.business_group_id = p_business_group_id)
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

Line 507: from ben_ptip_f ptip,

503: and plip.effective_end_date;
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