APPS.AP_WEB_EXPENSE_WF dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 8188: l_approver_status per_assignment_status_types.per_system_status%type;

8184: TYPE l_ManagerIDList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8185: l_manager_id l_ManagerIDList;
8186: l_counter NUMBER := 1;
8187: -- 3257576
8188: l_approver_status per_assignment_status_types.per_system_status%type;
8189: l_approver_name per_people_x.full_name%type;
8190: l_approver_name_out per_people_x.full_name%type;
8191: l_employee_name per_people_x.full_name%type;
8192:

Line 15531: from per_assignment_status_types

15527: AND pa.primary_flag = 'Y'
15528: AND pa.assignment_type in ('E' , 'C') --Support Contingent Workres
15529: AND pa.assignment_status_type_id not in
15530: (select assignment_status_type_id
15531: from per_assignment_status_types
15532: where per_system_status = 'TERM_ASSIGN')
15533: AND trunc(sysdate) between pa.effective_start_date and pa.effective_end_date;
15534:
15535: EXCEPTION