The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'ORG-' || ORGANIZATION_ID ||'-'|| LOCATION_ID LOCATION_XID
FROM WSH_SHIP_FROM_ORGS_V
WHERE ORGANIZATION_ID = l_organization_id;
SELECT 'DOCK-' || inventory_location_id LOCATION_RES_XID,
NVL(description, 'DOCK-' || inventory_location_id||' Name') LOCATION_RES_NAME
FROM mtl_item_locations
WHERE organization_id = l_organization_id
AND inventory_location_type = 1;
SELECT ticket, operation, argument, end_date
FROM FND_HTTP_TICKETS
WHERE operation = c_operation
AND argument = c_argument;
SELECT SYSDATE FROM DUAL;
print_debug('Tickets Exists but expired. Delete existing', 4);