DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_LER_F

Line 272: ben_ler_f ler

268: --
269: CURSOR c_per_in_ler IS
270: SELECT pil.per_in_ler_id
271: FROM ben_per_in_ler pil,
272: ben_ler_f ler
273: WHERE pil.person_id = p_person_id
274: and pil.ler_id = ler.ler_id
275: and ler.typ_cd not in ('COMP','GSP', 'IREC', 'ABS')
276: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 280: ben_ler_f ler1

276: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
277: AND lf_evt_ocrd_dt =
278: (SELECT MAX(b.lf_evt_ocrd_dt)
279: FROM ben_per_in_ler b,
280: ben_ler_f ler1
281: WHERE b.person_id = p_person_id
282: and b.ler_id = ler1.ler_id
283: and b.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
284: and ler1.typ_cd not in ('COMP','GSP', 'IREC', 'ABS')