The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT WDJ.DATE_RELEASED,
WDJ.DATE_COMPLETED,
WDJ.DATE_CLOSED
FROM ORG_ACCT_PERIODS OAP,
WIP_DISCRETE_JOBS WDJ
WHERE WDJ.WIP_ENTITY_ID = P_Wip_Entity_Id
AND WDJ.ORGANIZATION_ID = P_Organization_Id
AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,
wdj.organization_id)
BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE
AND OAP.OPEN_FLAG = 'Y';
WIP_CHANGE_STATUS.INSERT_PERIOD_BALANCES
(P_wip_entity_id, P_organization_id, '', '',
P_class_code, X_Date_closed);
UPDATE WIP_ENTITIES
SET ENTITY_TYPE = decode(ENTITY_TYPE, 7, 6, 8, 5, 1)
WHERE WIP_ENTITY_ID = P_wip_entity_id;
SELECT WDCT.STATUS_TYPE,
WDCT.rowid
FROM WIP_DISCRETE_JOBS WDJ,
WIP_DJ_CLOSE_TEMP WDCT
WHERE WDCT.WIP_ENTITY_ID = P_wip_entity_id
AND WDCT.ORGANIZATION_ID = P_organization_id
AND WDJ.WIP_ENTITY_ID = WDCT.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE = WIP_CONSTANTS.PEND_CLOSE;
DELETE FROM WIP_DJ_CLOSE_TEMP
WHERE ROWID = rid;