APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_OPERATIONS_B

Line 715: FROM ahl_operations_b

711:
712: CURSOR get_op_id(p_enigma_op_id VARCHAR2)
713: IS
714: SELECT operation_id
715: FROM ahl_operations_b
716: WHERE enigma_op_id = p_enigma_op_id
717: AND TRUNC(NVL(end_date_active, sysdate + 1)) > TRUNC(sysdate)
718: AND (revision_status_code = 'COMPLETE' OR revision_status_code='DRAFT') ;
719:

Line 1707: FROM AHL_OPERATIONS_B

1703:
1704: CURSOR get_latest_oper_rev (c_ENIGMA_OP_ID IN VARCHAR2)
1705: IS
1706: SELECT operation_id,object_version_number,revision_status_code revision_status
1707: FROM AHL_OPERATIONS_B
1708: WHERE UPPER(TRIM(ENIGMA_OP_ID)) = UPPER(TRIM(c_ENIGMA_OP_ID))
1709: AND REVISION_NUMBER =
1710: ( SELECT MAX( revision_number )
1711: FROM AHL_OPERATIONS_B

Line 1711: FROM AHL_OPERATIONS_B

1707: FROM AHL_OPERATIONS_B
1708: WHERE UPPER(TRIM(ENIGMA_OP_ID)) = UPPER(TRIM(c_ENIGMA_OP_ID))
1709: AND REVISION_NUMBER =
1710: ( SELECT MAX( revision_number )
1711: FROM AHL_OPERATIONS_B
1712: WHERE UPPER(TRIM(ENIGMA_OP_ID)) = UPPER(TRIM(c_ENIGMA_OP_ID))
1713: );
1714:
1715: CURSOR c_get_op_rec (c_oper_id IN NUMBER)

Line 1718: FROM ahl_operations_b aop

1714:
1715: CURSOR c_get_op_rec (c_oper_id IN NUMBER)
1716: IS
1717: SELECT aop.object_version_number
1718: FROM ahl_operations_b aop
1719: WHERE aop.operation_id = c_oper_id;
1720:
1721: -- Declare local variables
1722: l_api_name CONSTANT VARCHAR2(30) := 'Process_OP_Details';