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_LER_F

Line 108: ben_ler_f ler

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
112: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')

Line 472: l_ler_id ben_ler_f.ler_id%type;

468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
469: l_object_version_number ben_benefit_actions.object_version_number%type;
470: l_person_id per_people_f.person_id%type;
471: l_person_action_id ben_person_actions.person_action_id%type;
472: l_ler_id ben_ler_f.ler_id%type;
473: l_range_id ben_batch_ranges.range_id%type;
474: l_chunk_size number := 20;
475: l_threads number := 1;
476: l_start_person_action_id number := 0;

Line 505: , ben_ler_f ler

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
509: and ler.effective_end_date

Line 551: from ben_ler_f a

547: and fff1.formula_id = cv_formula_id;
548:
549: cursor c_chk_ler(cv_effective_date date) is
550: select a.ler_id
551: from ben_ler_f a
552: where a.business_group_id = p_business_group_id
553: and a.typ_cd = 'IREC'
554: and a.ler_id = p_life_event_id
555: and cv_effective_date between a.effective_start_date and