APPS.AP_WEB_EXPENSE_WF dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 7742: l_approver_status per_assignment_status_types.per_system_status%type;

7738: TYPE l_ManagerIDList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7739: l_manager_id l_ManagerIDList;
7740: l_counter NUMBER := 1;
7741: -- 3257576
7742: l_approver_status per_assignment_status_types.per_system_status%type;
7743: l_approver_name per_people_x.full_name%type;
7744: l_approver_name_out per_people_x.full_name%type;
7745: l_employee_name per_people_x.full_name%type;
7746:

Line 14591: from per_assignment_status_types

14587: AND pa.primary_flag = 'Y'
14588: AND pa.assignment_type in ('E' , 'C') --Support Contingent Workres
14589: AND pa.assignment_status_type_id not in
14590: (select assignment_status_type_id
14591: from per_assignment_status_types
14592: where per_system_status = 'TERM_ASSIGN')
14593: AND trunc(sysdate) between pa.effective_start_date and pa.effective_end_date;
14594:
14595: EXCEPTION