APPS.BEN_BACK_OUT_CONC dependencies on BEN_PER_IN_LER

Line 138: from ben_per_in_ler pil,

134: pil.per_in_ler_stat_cd,
135: pil.lf_evt_ocrd_dt,
136: ler.typ_cd,
137: ler.ler_id
138: from ben_per_in_ler pil,
139: ben_ler_f ler
140: where pil.person_id = l_person_id
141: and pil.lf_evt_ocrd_dt
142: between l_from_ocrd_date

Line 186: from ben_per_in_ler pil,

182: pil.per_in_ler_stat_cd,
183: pil.lf_evt_ocrd_dt,
184: ler.typ_cd,
185: ler.ler_id
186: from ben_per_in_ler pil,
187: ben_ler_f ler
188: where pil.person_id = l_person_id
189: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
190: and pil.lf_evt_ocrd_dt

Line 219: from ben_per_in_ler pil,

215: --
216: cursor c_latest_ler is
217: select pil.per_in_ler_id,
218: ler.name
219: from ben_per_in_ler pil,
220: ben_ler_f ler
221: where pil.person_id = l_person_id
222: and pil.business_group_id+0 = p_business_group_id
223: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 234: from ben_per_in_ler pil,

230: --
231: cursor c_latest_ler_abs is
232: select pil.per_in_ler_id,
233: ler.name
234: from ben_per_in_ler pil,
235: ben_ler_f ler
236: where pil.person_id = l_person_id
237: and pil.business_group_id+0 = p_business_group_id
238: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 250: from ben_per_in_ler pil,

246: --
247: cursor c_latest_ler_cwb is
248: select pil.per_in_ler_id,
249: ler.name
250: from ben_per_in_ler pil,
251: ben_ler_f ler
252: where pil.person_id = l_person_id
253: and pil.business_group_id+0 = p_business_group_id
254: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 266: from ben_per_in_ler pil,

262: -- 3136058
263: cursor c_latest_ler_gsp is
264: select pil.per_in_ler_id,
265: ler.name
266: from ben_per_in_ler pil,
267: ben_ler_f ler
268: where pil.person_id = l_person_id
269: and pil.business_group_id+0 = p_business_group_id
270: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 792: from ben_per_in_ler pil

788: l_effective_date
789: between ppf.effective_start_date
790: and ppf.effective_end_date
791: and exists (select null
792: from ben_per_in_ler pil
793: , ben_ler_f ler
794: where pil.lf_evt_ocrd_dt between l_from_ocrd_date
795: and l_to_ocrd_date
796: and pil.ler_id = ler.ler_id

Line 876: from ben_per_in_ler pil,

872: select ppf.person_id
873: from per_all_people_f ppf
874: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
875: and exists (select null
876: from ben_per_in_ler pil,
877: ben_ler_f ler
878: where ler.ler_id = pil.ler_id
879: and ler.typ_cd = 'COMP'
880: and l_effective_date