APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_LER_F

Line 748: ben_ler_f ler

744: pil.business_group_id,
745: ler.typ_cd,
746: ler.ler_id
747: from ben_per_in_ler pil,
748: ben_ler_f ler
749: where pil.person_id = l_person_id
750: and pil.lf_evt_ocrd_dt = l_ocrd_date
751: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
752: and pil.group_pl_id = p_group_pl_id -- CWBGLOBAL

Line 774: ben_ler_f ler

770: cursor c_latest_ler_cwb is
771: select pil.per_in_ler_id,
772: ler.name
773: from ben_per_in_ler pil,
774: ben_ler_f ler
775: where pil.person_id = l_person_id
776: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
777: and pil.ler_id = ler.ler_id
778: and ler.typ_cd = 'COMP'

Line 1174: l_ler_id ben_ler_f.ler_id%type;

1170: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1171: l_object_version_number ben_benefit_actions.object_version_number%type;
1172: l_person_id per_people_f.person_id%type;
1173: l_person_action_id ben_person_actions.person_action_id%type;
1174: l_ler_id ben_ler_f.ler_id%type;
1175: l_range_id ben_batch_ranges.range_id%type;
1176: l_chunk_size number := 20;
1177: l_threads number := 1;
1178: l_start_person_action_id number := 0;

Line 1208: , ben_ler_f ler

1204: from per_all_people_f ppf
1205: where -- l_effective_date between ppf.effective_start_date and ppf.effective_end_date and
1206: exists (select null
1207: from ben_per_in_ler pil
1208: , ben_ler_f ler
1209: where pil.lf_evt_ocrd_dt = l_ocrd_date
1210: and (p_person_id IS NULL OR pil.person_id = p_person_id)
1211: and pil.ler_id = ler.ler_id
1212: and l_effective_date between ler.effective_start_date

Line 2109: ben_ler_f ler

2105: pil.business_group_id,
2106: ler.typ_cd,
2107: ler.ler_id
2108: from ben_per_in_ler pil,
2109: ben_ler_f ler
2110: where pil.person_id = cv_person_id
2111: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2112: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
2113: and pil.group_pl_id = cv_group_pl_id