APPS.BEN_IRC_UTIL dependencies on BEN_PIL_ASSIGNMENT

Line 586: FROM ben_pil_assignment

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)
586: FROM ben_pil_assignment
587: WHERE offer_assignment_id IS NOT NULL
588: AND applicant_assignment_id = p_assignment_id);
589:
590: --