The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM cst_rcv_acq_cost_details cracd
WHERE cracd.header_id in (SELECT header_id FROM cst_rcv_acq_costs
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id);
DELETE FROM cst_rcv_acq_costs
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM cst_pac_low_level_codes
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE /*+ index(cst_pac_explosion_temp CST_PAC_EXPLOSION_TEMP_N1) */
FROM cst_pac_explosion_temp
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM wip_pac_period_balances
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM mtl_pac_txn_cost_details
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id
AND new_periodic_cost IS NULL
AND value_change IS NULL
AND percentage_change IS NULL;
DELETE FROM mtl_pac_actual_cost_details
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM wip_pac_actual_cost_details
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM mtl_pac_cost_subelements
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM cst_pac_req_oper_cost_details
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE from cst_pac_quantity_layers
WHERE cost_layer_id in (SELECT cost_layer_id
FROM cst_pac_item_costs
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id);
DELETE FROM cst_pac_item_cost_details
WHERE cost_layer_id in (SELECT cost_layer_id from cst_pac_item_costs
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id);
DELETE FROM cst_pac_item_costs
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM cst_pac_period_balances
WHERE pac_period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
UPDATE cst_pac_eam_asset_per_balances
SET actual_mat_cost = 0,
actual_lab_cost = 0,
actual_eqp_cost = 0
WHERE legal_entity_id = i_legal_entity
AND cost_group_id = i_cost_group_id
AND cost_type_id = (SELECT cost_type_id
FROM cst_pac_periods
WHERE pac_period_id = i_pac_period_id);
DELETE FROM cst_pac_eam_asset_per_balances
WHERE NVL(actual_mat_cost,0) = 0
AND NVL(actual_lab_cost,0) = 0
AND NVL(actual_eqp_cost,0) = 0
AND NVL(system_estimated_mat_cost,0) = 0
AND NVL(system_estimated_lab_cost,0) = 0
AND NVL(system_estimated_eqp_cost,0) = 0
AND legal_entity_id = i_legal_entity
AND cost_group_id = i_cost_group_id
AND cost_type_id = (SELECT cost_type_id
FROM cst_pac_periods
WHERE pac_period_id = i_pac_period_id);
UPDATE cst_pac_eam_period_balances
SET actual_mat_cost = 0,
actual_lab_cost = 0,
actual_eqp_cost = 0
WHERE cost_group_id = i_cost_group_id
AND pac_period_id = i_pac_period_id;
DELETE FROM cst_pac_eam_period_balances
WHERE NVL(actual_mat_cost,0) = 0
AND NVL(actual_lab_cost,0) = 0
AND NVL(actual_eqp_cost,0) = 0
AND NVL(system_estimated_mat_cost,0) = 0
AND NVL(system_estimated_lab_cost,0) = 0
AND NVL(system_estimated_eqp_cost,0) = 0
AND cost_group_id = i_cost_group_id
AND pac_period_id = i_pac_period_id;
UPDATE cst_pac_process_phases cppp
SET (cppp.process_status,cppp.last_update_date, cppp.process_upto_date) =
(SELECT decode(cppp.process_phase,6,
decode(NVL(clct.CREATE_ACCT_ENTRIES,'N'),'N',0,1),
7,
decode(NVL(clct.transfer_cost_flag,'N'),'N',0,1),
8,
decode(NVL(clct.transfer_cost_flag,'N'),'N',0,1),
1),
SYSDATE,
NULL
FROM cst_le_cost_types clct, cst_pac_periods cpp
WHERE cpp.pac_period_id = i_pac_period_id
AND clct.legal_entity = i_legal_entity
AND clct.cost_type_id = cpp.cost_type_id)
WHERE cppp.pac_period_id = i_pac_period_id
AND cppp.cost_group_id = i_cost_group_id
AND cppp.process_phase <> decode(i_acquisition_flag, 0, 1, 0);
DELETE from cst_ae_lines
where ae_header_id in
(SELECT ae_header_id
FROM cst_ae_headers
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id);
DELETE FROM cst_encumbrance_lines
WHERE ae_header_id in
(SELECT ae_header_id
FROM cst_ae_headers
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id);
DELETE FROM cst_ae_headers
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM CST_PAC_ACCRUAL_RECONCILE_TEMP
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;
DELETE FROM CST_PAC_ACCRUAL_WRITE_OFFS
WHERE period_id = i_pac_period_id
AND cost_group_id = i_cost_group_id;