The following lines contain the word 'select', 'insert', 'update' or 'delete':
UPDATE
mtl_movement_statistics
SET
movement_status = 'O'
, edi_sent_flag = 'N'
, last_updated_by = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
, last_update_date = SYSDATE
, report_reference = NULL
WHERE entity_org_id = p_legal_entity_id
AND zone_code = p_zone_code
AND stat_type = p_stat_type
AND usage_type = p_usage_type
AND period_name = p_period_name
AND document_source_type = NVL(p_document_source_type,
document_source_type)
AND movement_status NOT IN ('I', 'P');
UPDATE
mtl_movement_statistics
SET
movement_status = 'O'
, edi_sent_flag = 'N'
, last_updated_by = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
, last_update_date = SYSDATE
, report_reference = NULL
WHERE entity_org_id = p_legal_entity_id
AND zone_code = p_zone_code
AND stat_type = p_stat_type
AND usage_type = p_usage_type
AND period_name = p_period_name
AND document_source_type = NVL(p_document_source_type,
document_source_type)
AND movement_status = 'I';
UPDATE
mtl_movement_statistics
SET
movement_status = 'O'
, edi_sent_flag = 'N'
, last_updated_by = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
, last_update_date = SYSDATE
, report_reference = NULL
WHERE entity_org_id = p_legal_entity_id
AND zone_code = p_zone_code
AND stat_type = p_stat_type
AND usage_type = p_usage_type
AND period_name = p_period_name
AND document_source_type = NVL(p_document_source_type,
document_source_type)
AND movement_status <> 'P';