APPS.AHL_RM_ASSO_DOCASO_PVT dependencies on AHL_OPERATIONS_B

Line 90: from ahl_operations_b

86:
87: cursor get_oper_status (p_operation_id in number)
88: is
89: select revision_status_code
90: from ahl_operations_b
91: where operation_id = p_operation_id;
92:
93: l_api_name VARCHAR2(30) := 'process_association';
94: l_api_version NUMBER := 1.0;

Line 303: UPDATE ahl_operations_b

299: OPEN get_oper_status (p_x_association_tbl(1).OBJECT_ID);
300: FETCH get_oper_status INTO l_obj_status;
301: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
302: THEN
303: UPDATE ahl_operations_b
304: SET revision_status_code = 'DRAFT'
305: WHERE operation_id = p_x_association_tbl(1).OBJECT_ID;
306: END IF;
307: CLOSE get_oper_status;