APPS.BEN_BPL_DEL dependencies on BEN_PER_IN_LER

Line 305: FROM ben_per_in_ler pil_old, ben_per_in_ler pil_new

301: -- Bug 5500864
302: CURSOR c_curr_pil
303: IS
304: SELECT pil_new.per_in_ler_id
305: FROM ben_per_in_ler pil_old, ben_per_in_ler pil_new
306: WHERE pil_old.person_id = pil_new.person_id
307: AND pil_old.per_in_ler_id = ben_bpl_shd.g_old_rec.per_in_ler_id
308: AND pil_new.per_in_ler_stat_cd in ('STRTD','PROCD') -- Bug 7380983
309: ORDER BY pil_new.lf_evt_ocrd_dt desc; -- Bug 7380983