DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_WORK_ASSIGNMENTS

Line 548: FROM AHL_WORK_ASSIGNMENTS AWAS

544: -- Check if assignment exists.
545: CURSOR c_assignment_details (p_operation_resource_id IN NUMBER,
546: p_employee_id IN NUMBER) IS
547: SELECT AWAS.Assignment_id, AWAS.object_version_number
548: FROM AHL_WORK_ASSIGNMENTS AWAS
549: WHERE AWAS.operation_resource_id = p_operation_resource_id
550: AND AWAS.employee_id = p_employee_id;
551:
552: -- parameters to call Assignment API.

Line 908: FROM AHL_WORK_ASSIGNMENTS AWAS

904: -- Check if assignment exists.
905: CURSOR c_assignment_details (p_operation_resource_id IN NUMBER,
906: p_employee_id IN NUMBER) IS
907: SELECT AWAS.Assignment_id, AWAS.object_version_number
908: FROM AHL_WORK_ASSIGNMENTS AWAS
909: WHERE AWAS.operation_resource_id = p_operation_resource_id
910: AND AWAS.employee_id = p_employee_id;
911:
912:

Line 1229: FROM AHL_WORK_ASSIGNMENTS AWAS

1225: -- Check if assignment exists.
1226: CURSOR c_assignment_details (p_operation_resource_id IN NUMBER,
1227: p_employee_id IN NUMBER) IS
1228: SELECT AWAS.Assignment_id, AWAS.object_version_number
1229: FROM AHL_WORK_ASSIGNMENTS AWAS
1230: WHERE AWAS.operation_resource_id = p_operation_resource_id
1231: AND AWAS.employee_id = p_employee_id;
1232:
1233: