APPS.BEN_BENEFIT_PRVDD_LEDGER_API dependencies on BEN_LER_F

Line 1390: FROM ben_per_in_ler pil, ben_ler_f ler

1386: -- Unable to use a parameter as this procedure is called from lot of places. hence queried again.
1387: --
1388: cursor c_cur_pil IS
1389: SELECT pil.per_in_ler_id
1390: FROM ben_per_in_ler pil, ben_ler_f ler
1391: WHERE pil.person_id = l_person_id
1392: and pil.ler_id = ler.ler_id
1393: AND pil.per_in_ler_stat_cd = 'STRTD'
1394: and p_effective_date between ler.effective_start_date