APPS.PA_OTC_API dependencies on PER_ASSIGNMENTS_F

Line 8763: Select '1' from per_assignments_f where

8759: (current_employee_flag = 'Y' or current_npw_flag = 'Y');
8760:
8761: /* Added the cursor for bug 8528840 */
8762: Cursor is_assignment_end_date(p_person_id number, p_stop_date DATE) is
8763: Select '1' from per_assignments_f where
8764: person_id = p_person_id and
8765: trunc(p_stop_date) + 1 between effective_start_date and effective_end_date
8766: and assignment_status_type_id in (select assignment_status_type_id
8767: from PER_ASSIGNMENT_STATUS_TYPES where per_system_status = 'SUSP_ASSIGN');