APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on AHL_WORK_ASSIGNMENTS_S

Line 463: UPDATE AHL_WORK_ASSIGNMENTS SET

459: )
460: IS
461:
462: BEGIN
463: UPDATE AHL_WORK_ASSIGNMENTS SET
464: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
465: ASSIGNMENT_ID = X_ASSIGNMENT_ID,
466: OPERATION_RESOURCE_ID = X_OPERATION_RESOURCE_ID,
467: EMPLOYEE_ID = X_EMPLOYEE_ID,

Line 1826: SELECT AHL_WORK_ASSIGNMENTS_S.NEXTVAL

1822: END IF;
1823:
1824: --
1825: -- Get Sequence Number for Resource Assignment ID
1826: SELECT AHL_WORK_ASSIGNMENTS_S.NEXTVAL
1827: INTO l_assignment_id FROM DUAL;
1828:
1829: --Check for Record Exists
1830: OPEN Sch_id_exists(l_assignment_id);