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);