The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT WIP_CONSTANTS.YES
INTO P_RESOURCES_CHARGED
FROM DUAL
WHERE EXISTS (SELECT 'X'
FROM WIP_OPERATION_RESOURCES
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND APPLIED_RESOURCE_UNITS <> 0);
SELECT WIP_CONSTANTS.YES
INTO P_MATERIAL_ISSUED
FROM DUAL
WHERE EXISTS (SELECT 'X'
FROM WIP_REQUIREMENT_OPERATIONS
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND QUANTITY_ISSUED <> 0);
SELECT WIP_CONSTANTS.YES
INTO P_MTL_TXNS_TEMP
FROM DUAL
WHERE EXISTS (SELECT 1
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
AND TRANSACTION_SOURCE_TYPE_ID = 5);
SELECT WIP_CONSTANTS.YES
INTO P_UNCOSTED_MTL_TXNS
FROM DUAL
WHERE EXISTS (SELECT 1
FROM MTL_MATERIAL_TRANSACTIONS
WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
AND COSTED_FLAG IN ('N','E')
AND TRANSACTION_SOURCE_TYPE_ID = 5);
SELECT WIP_CONSTANTS.YES
INTO P_PO_REQ_LINES
FROM DUAL
WHERE EXISTS (SELECT 1
FROM PO_REQUISITION_LINES_ALL
WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);
SELECT WIP_CONSTANTS.YES
INTO P_PO_REQ_INTERFACE
FROM DUAL
WHERE EXISTS (SELECT 1
FROM PO_REQUISITIONS_INTERFACE_ALL
WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);
SELECT WIP_CONSTANTS.YES
INTO P_MOVE_TXN_INTERFACE
FROM DUAL
WHERE EXISTS (SELECT 1
FROM WIP_MOVE_TXN_INTERFACE
WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND ORGANIZATION_ID = P_ORGANIZATION_ID);
SELECT WIP_CONSTANTS.YES
INTO P_COST_TXN_INTERFACE
FROM DUAL
WHERE EXISTS (SELECT 1
FROM WIP_COST_TXN_INTERFACE
WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
AND ORGANIZATION_ID = P_ORGANIZATION_ID);