APPS.BEN_IRC_UTIL dependencies on BEN_PER_IN_LER

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 532: FROM ben_per_in_ler pil

528:
529: CURSOR c_pil (c_per_in_ler_id IN NUMBER)
530: IS
531: SELECT pil.*
532: FROM ben_per_in_ler pil
533: WHERE pil.per_in_ler_id = c_per_in_ler_id
534: AND pil.assignment_id = p_assignment_id
535: AND pil.person_id = p_person_id;
536:

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

Line 572: FROM ben_per_in_ler pil

568:
569: CURSOR c_pil_strt
570: IS
571: SELECT NULL
572: FROM ben_per_in_ler pil
573: WHERE pil.per_in_ler_id <> p_restore_per_in_ler_id
574: AND pil.per_in_ler_stat_cd IN ('STRTD', 'PROCD')
575: AND pil.assignment_id = p_assignment_id
576: AND pil.person_id = p_person_id;

Line 581: FROM ben_per_in_ler

577:
578: CURSOR c_get_pil
579: IS
580: SELECT *
581: FROM ben_per_in_ler
582: WHERE assignment_id = p_assignment_id
583: AND per_in_ler_stat_cd NOT IN ('VOIDD', 'PROCD')
584: AND per_in_ler_id >
585: (SELECT NVL (MAX (per_in_ler_id), -1)