APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_LER_F

Line 1276: from ben_ler_f ler

1272: and (p_life_event_id is null or pil.ler_id = p_life_event_id)
1273: and pil.lf_evt_ocrd_dt between l_from_ocrd_date and p_to_ocrd_date
1274: and (p_life_evt_typ_cd is null or
1275: exists (select null
1276: from ben_ler_f ler
1277: where ler.ler_id = pil.ler_id
1278: and ler.typ_cd = p_life_evt_typ_cd
1279: and pil.lf_evt_ocrd_dt between ler.effective_start_date and
1280: ler.effective_end_date));

Line 1292: from ben_ler_f ler

1288: and (p_life_event_id is null or pil.ler_id = p_life_event_id)
1289: and pil.lf_evt_ocrd_dt between l_from_ocrd_date and p_to_ocrd_date
1290: and (p_life_evt_typ_cd is null or
1291: exists (select null
1292: from ben_ler_f ler
1293: where ler.ler_id = pil.ler_id
1294: and ler.typ_cd = p_life_evt_typ_cd
1295: and pil.lf_evt_ocrd_dt between ler.effective_start_date and
1296: ler.effective_end_date));