DBA Data[Home] [Help]

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