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_PEP_CACHE dependencies on BEN_ELIG_PER_F

Line 330: FROM ben_elig_per_f pep,

326: pep.elig_flag,
327: pep.must_enrl_anthr_pl_id,
328: pep.prtn_strt_dt,
329: pep.inelg_rsn_cd
330: FROM ben_elig_per_f pep,
331: ben_per_in_ler pil
332: WHERE pep.per_in_ler_id = c_per_in_ler_id
333: AND pep.pl_id = c_pl_id
334: AND pep.pgm_id = c_pgm_id

Line 358: FROM ben_elig_per_f pep,

354: pep.elig_flag,
355: pep.must_enrl_anthr_pl_id,
356: pep.prtn_strt_dt,
357: pep.inelg_rsn_cd
358: FROM ben_elig_per_f pep,
359: ben_per_in_ler pil
360: WHERE pep.per_in_ler_id = c_per_in_ler_id
361: AND pep.pl_id = c_pl_id
362: AND pep.pgm_id IS NULL

Line 390: FROM ben_elig_per_f ep,

386: epo.elig_flag,
387: ep.must_enrl_anthr_pl_id,
388: epo.prtn_strt_dt,
389: epo.inelg_rsn_cd
390: FROM ben_elig_per_f ep,
391: ben_elig_per_opt_f epo,
392: ben_per_in_ler pil
393: WHERE ep.per_in_ler_id = c_per_in_ler_id
394: AND ep.pl_id = c_pl_id

Line 424: FROM ben_elig_per_f ep,

420: epo.elig_flag,
421: ep.must_enrl_anthr_pl_id,
422: epo.prtn_strt_dt,
423: epo.inelg_rsn_cd
424: FROM ben_elig_per_f ep,
425: ben_elig_per_opt_f epo,
426: ben_per_in_ler pil
427: WHERE ep.per_in_ler_id = c_per_in_ler_id
428: AND ep.pl_id = c_pl_id

Line 564: from ben_elig_per_f pep,

560: )
561: is
562: select /*+ benpepch.get_curroiplippep_dets.c_oiplip_dets */
563: pep.elig_per_id
564: from ben_elig_per_f pep,
565: ben_per_in_ler pil
566: where pep.person_id = c_person_id
567: and pep.pgm_id = c_pgm_id
568: and pep.plip_id = c_plip_id

Line 585: from ben_elig_per_f pep,

581: )
582: is
583: select /*+ benpepch.get_curroiplippep_dets.c_oiplipnip_dets */
584: pep.elig_per_id
585: from ben_elig_per_f pep,
586: ben_per_in_ler pil
587: where pep.person_id = c_person_id
588: and pep.pgm_id is null
589: and pep.plip_id = c_plip_id

Line 655: from ben_elig_per_f pep,

651: select /*+ benpepch.get_currplnpep_dets.c_pln_dets */
652: pep.elig_per_id,
653: pep.prtn_strt_dt,
654: pep.prtn_end_dt
655: from ben_elig_per_f pep,
656: ben_per_in_ler pil
657: where pep.person_id = c_person_id
658: and pep.pgm_id = c_pgm_id
659: and pep.pl_id = c_pl_id

Line 678: from ben_elig_per_f pep,

674: select /*+ benpepch.get_currplnpep_dets.c_plnip_dets */
675: pep.elig_per_id,
676: pep.prtn_strt_dt,
677: pep.prtn_end_dt
678: from ben_elig_per_f pep,
679: ben_per_in_ler pil
680: where pep.person_id = c_person_id
681: and pep.pgm_id is null
682: and pep.pl_id = c_pl_id