APPS.BEN_BACK_OUT_CONC dependencies on BEN_PER_IN_LER

Line 143: from ben_per_in_ler pil,

139: pil.per_in_ler_stat_cd,
140: pil.lf_evt_ocrd_dt,
141: ler.typ_cd,
142: ler.ler_id
143: from ben_per_in_ler pil,
144: ben_ler_f ler
145: where pil.person_id = l_person_id
146: and pil.lf_evt_ocrd_dt
147: between l_from_ocrd_date

Line 191: from ben_per_in_ler pil,

187: pil.per_in_ler_stat_cd,
188: pil.lf_evt_ocrd_dt,
189: ler.typ_cd,
190: ler.ler_id
191: from ben_per_in_ler pil,
192: ben_ler_f ler
193: where pil.person_id = l_person_id
194: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
195: and pil.lf_evt_ocrd_dt

Line 224: from ben_per_in_ler pil,

220: --
221: cursor c_latest_ler is
222: select pil.per_in_ler_id,
223: ler.name
224: from ben_per_in_ler pil,
225: ben_ler_f ler
226: where pil.person_id = l_person_id
227: and pil.business_group_id+0 = p_business_group_id
228: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 239: from ben_per_in_ler pil,

235: --
236: cursor c_latest_ler_abs is
237: select pil.per_in_ler_id,
238: ler.name
239: from ben_per_in_ler pil,
240: ben_ler_f ler
241: where pil.person_id = l_person_id
242: and pil.business_group_id+0 = p_business_group_id
243: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 255: from ben_per_in_ler pil,

251: --
252: cursor c_latest_ler_cwb is
253: select pil.per_in_ler_id,
254: ler.name
255: from ben_per_in_ler pil,
256: ben_ler_f ler
257: where pil.person_id = l_person_id
258: and pil.business_group_id+0 = p_business_group_id
259: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 271: from ben_per_in_ler pil,

267: -- 3136058
268: cursor c_latest_ler_gsp is
269: select pil.per_in_ler_id,
270: ler.name
271: from ben_per_in_ler pil,
272: ben_ler_f ler
273: where pil.person_id = l_person_id
274: and pil.business_group_id+0 = p_business_group_id
275: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 818: from ben_per_in_ler pil

814: l_effective_date
815: between ppf.effective_start_date
816: and ppf.effective_end_date
817: and exists (select null
818: from ben_per_in_ler pil
819: , ben_ler_f ler
820: where pil.lf_evt_ocrd_dt between l_from_ocrd_date
821: and l_to_ocrd_date
822: and pil.ler_id = ler.ler_id

Line 902: from ben_per_in_ler pil,

898: select ppf.person_id
899: from per_all_people_f ppf
900: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
901: and exists (select null
902: from ben_per_in_ler pil,
903: ben_ler_f ler
904: where ler.ler_id = pil.ler_id
905: and ler.typ_cd = 'COMP'
906: and l_effective_date