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_CACHE2 dependencies on BEN_ELIG_PER_OPT_F

Line 75: from ben_elig_per_opt_f epo

71: ,c_eff_date date
72: )
73: is
74: select epo.per_in_ler_id
75: from ben_elig_per_opt_f epo
76: where epo.per_in_ler_id = c_pil_id
77: and c_eff_date
78: between epo.effective_start_date and epo.effective_end_date
79: and rownum=1;

Line 719: from ben_elig_per_opt_f tab1,

715: ,tab2.per_in_ler_id
716: ,tab2.prtn_strt_dt pep_psd
717: ,tab2.prtn_end_dt pep_ped
718: ,tab3.per_in_ler_stat_cd
719: from ben_elig_per_opt_f tab1,
720: ben_elig_per_f tab2,
721: ben_per_in_ler tab3
722: where tab1.opt_id is not null
723: and tab1.elig_per_id = tab2.elig_per_id

Line 787: from ben_elig_per_opt_f tab1,

783: ,tab2.elig_per_id
784: ,tab2.per_in_ler_id
785: ,tab2.prtn_strt_dt pep_psd
786: ,tab2.prtn_end_dt pep_ped
787: from ben_elig_per_opt_f tab1,
788: ben_elig_per_f tab2
789: where tab2.per_in_ler_id is null
790: and tab2.person_id = c_person_id
791: and tab1.opt_id is not null