APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_LER_F

Line 673: ben_ler_f ler

669: pil.business_group_id,
670: ler.typ_cd,
671: ler.ler_id
672: from ben_per_in_ler pil,
673: ben_ler_f ler
674: where pil.person_id = l_person_id
675: and pil.lf_evt_ocrd_dt = l_ocrd_date
676: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
677: and pil.group_pl_id = p_group_pl_id -- CWBGLOBAL

Line 699: ben_ler_f ler

695: cursor c_latest_ler_cwb is
696: select pil.per_in_ler_id,
697: ler.name
698: from ben_per_in_ler pil,
699: ben_ler_f ler
700: where pil.person_id = l_person_id
701: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
702: and pil.ler_id = ler.ler_id
703: and ler.typ_cd = 'COMP'

Line 1098: l_ler_id ben_ler_f.ler_id%type;

1094: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1095: l_object_version_number ben_benefit_actions.object_version_number%type;
1096: l_person_id per_people_f.person_id%type;
1097: l_person_action_id ben_person_actions.person_action_id%type;
1098: l_ler_id ben_ler_f.ler_id%type;
1099: l_range_id ben_batch_ranges.range_id%type;
1100: l_chunk_size number := 20;
1101: l_threads number := 1;
1102: l_start_person_action_id number := 0;

Line 1130: , ben_ler_f ler

1126: from per_all_people_f ppf
1127: where -- l_effective_date between ppf.effective_start_date and ppf.effective_end_date and
1128: exists (select null
1129: from ben_per_in_ler pil
1130: , ben_ler_f ler
1131: where pil.lf_evt_ocrd_dt = l_ocrd_date
1132: and pil.ler_id = ler.ler_id
1133: and l_effective_date between ler.effective_start_date
1134: and ler.effective_end_date

Line 2015: ben_ler_f ler

2011: pil.business_group_id,
2012: ler.typ_cd,
2013: ler.ler_id
2014: from ben_per_in_ler pil,
2015: ben_ler_f ler
2016: where pil.person_id = cv_person_id
2017: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2018: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
2019: and pil.group_pl_id = cv_group_pl_id