DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_WORK_ASSIGNMENTS

Line 545: FROM AHL_WORK_ASSIGNMENTS AWAS

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

Line 905: FROM AHL_WORK_ASSIGNMENTS AWAS

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

Line 1226: FROM AHL_WORK_ASSIGNMENTS AWAS

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