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_IREC_BACK_OUT_CONC dependencies on BEN_PER_IN_LER

Line 107: from ben_per_in_ler pil,

103: pil.lf_evt_ocrd_dt,
104: pil.business_group_id,
105: ler.typ_cd,
106: ler.ler_id
107: from ben_per_in_ler pil,
108: ben_ler_f ler
109: where pil.person_id = l_person_id
110: and pil.lf_evt_ocrd_dt = l_ocrd_date --between l_from_ocrd_date and l_to_ocrd_date
111: -- and pil.ler_id = p_life_event_id

Line 504: from ben_per_in_ler pil

500: select distinct ppf.person_id, ppf.business_group_id
501: from per_all_people_f ppf
502: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
503: and exists (select null
504: from ben_per_in_ler pil
505: , ben_ler_f ler
506: where pil.lf_evt_ocrd_dt = l_ocrd_date
507: and pil.ler_id = ler.ler_id
508: and l_effective_date between ler.effective_start_date

Line 1018: from ben_per_in_ler pil

1014: p_effective_date in date) is
1015:
1016: cursor c_get_le_det is
1017: select ler_id, to_char(lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS'), person_id, assignment_id
1018: from ben_per_in_ler pil
1019: where pil.per_in_ler_id = p_per_in_ler_id
1020: and pil.business_group_id = p_business_group_id
1021: and pil.lf_evt_ocrd_dt <= p_effective_date;
1022: --