APPS.PER_ABS_SHADOW_BOOKING_PKG dependencies on PER_ALL_ASSIGNMENTS_F
Line 89: FROM per_all_assignments_f
85: ,cp_start_date IN DATE
86: ,cp_end_date IN DATE
87: ) IS
88: SELECT assignment_id 89: FROM per_all_assignments_f 90: WHERE person_id = cp_person_id
91: AND primary_flag = 'Y'
92: AND effective_start_date <= NVL(cp_end_date, SYSDATE)
93: AND effective_end_date >= NVL(cp_start_date, SYSDATE);