APPS.BEN_IRC_UTIL dependencies on BEN_LER_F

Line 263: from ben_per_in_ler pil , ben_ler_f ler

259:
260:
261: cursor c_pil_last_upd_date is
262: select pil.last_update_date last_update_date
263: from ben_per_in_ler pil , ben_ler_f ler
264: where pil.person_id = p_person_id
265: and pil.business_group_id = p_business_group_id
266: and pil.assignment_id = p_assignment_id
267: and pil.per_in_ler_stat_cd = 'STRTD'

Line 347: FROM ben_per_in_ler pil, ben_ler_f ler

343: -- get the latest pil which has been voided.
344: CURSOR c_last_pil
345: IS
346: SELECT per_in_ler_id
347: FROM ben_per_in_ler pil, ben_ler_f ler
348: WHERE pil.person_id = p_person_id
349: AND pil.business_group_id = p_business_group_id
350: AND pil.assignment_id = p_assignment_id
351: AND pil.per_in_ler_stat_cd = 'BCKDT' -- 5068367

Line 364: FROM ben_per_in_ler pil, ben_ler_f ler

360: -- get present pil which is in started state
361: CURSOR c_present_pil
362: IS
363: SELECT per_in_ler_id
364: FROM ben_per_in_ler pil, ben_ler_f ler
365: WHERE pil.person_id = p_person_id
366: AND pil.business_group_id = p_business_group_id
367: AND pil.assignment_id = p_assignment_id
368: AND pil.per_in_ler_stat_cd = 'STRTD'

Line 546: FROM ben_per_in_ler pil, ben_ler_f ler

542:
543: CURSOR c_latest_ler
544: IS
545: SELECT pil.per_in_ler_id
546: FROM ben_per_in_ler pil, ben_ler_f ler
547: WHERE pil.person_id = p_person_id
548: AND pil.assignment_id = p_assignment_id
549: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
550: AND pil.ler_id = ler.ler_id

Line 559: FROM ben_per_in_ler pil, ben_ler_f ler

555:
556: CURSOR c_latest_bckdt_ler
557: IS
558: SELECT pil.per_in_ler_id
559: FROM ben_per_in_ler pil, ben_ler_f ler
560: WHERE pil.person_id = p_person_id
561: AND pil.assignment_id = p_assignment_id
562: AND pil.per_in_ler_stat_cd = 'BCKDT'
563: AND pil.ler_id = ler.ler_id