APPS.HR_AUTH_BRIDGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 574: FROM per_all_assignments_f paf

570: RETURN number IS
571: --
572: CURSOR c_assignment IS
573: SELECT paf.assignment_id
574: FROM per_all_assignments_f paf
575: WHERE paf.person_id = p_person_id
576: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
577: AND hr_auth_bridge.get_per_system_status(paf.assignment_status_type_id) = 'ACTIVE_ASSIGN'
578: AND paf.primary_flag = 'Y'

Line 582: l_assignment_id per_all_assignments_f.assignment_id%type;

578: AND paf.primary_flag = 'Y'
579: AND paf.assignment_type IN ('E','B')
580: ORDER BY paf.assignment_type DESC;
581:
582: l_assignment_id per_all_assignments_f.assignment_id%type;
583: --
584: BEGIN
585: --
586: OPEN c_assignment;