APPS.BEN_BENEFIT_PRVDD_LEDGER_API dependencies on BEN_LER_F

Line 1396: FROM ben_per_in_ler pil, ben_ler_f ler

1392: -- Unable to use a parameter as this procedure is called from lot of places. hence queried again.
1393: --
1394: cursor c_cur_pil IS
1395: SELECT pil.per_in_ler_id
1396: FROM ben_per_in_ler pil, ben_ler_f ler
1397: WHERE pil.person_id = l_person_id
1398: and pil.ler_id = ler.ler_id
1399: AND pil.per_in_ler_stat_cd = 'STRTD'
1400: and p_effective_date between ler.effective_start_date