APPS.POR_LOAD_EMPLOYEE_ASSIGNMENT dependencies on PER_ALL_ASSIGNMENTS_F
Line 212: SELECT assignment_id, object_version_number INTO l_assignment_id, l_object_version_number FROM per_all_assignments_f
208: IS
209:
210: BEGIN
211: 212: SELECT assignment_id, object_version_number INTO l_assignment_id, l_object_version_number FROM per_all_assignments_f 213: WHERE person_id = p_person_id and trunc(effective_start_date) <= trunc(p_effective_start_date);
214:
215: EXCEPTION
216: WHEN NO_DATA_FOUND THEN