The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
mstat.zone_code
, UPPER(mstat.usage_type)
, UPPER(mstat.stat_type )
, mstat.start_period_name
, mstat.end_period_name
, mstat.period_set_name
, mstat.period_type
, mstat.weight_uom_code
, mstat.conversion_type
, mstat.attribute_rule_set_code
, mstat.alt_uom_rule_set_code
, glp.start_date
, DECODE(mstat.end_period_name,NULL,NULL,glp1.end_date)
, mstat.category_set_id
, gllv.period_set_name
, gllv.currency_code
, gllv.currency_code
, mstat.conversion_option
, mstat.triangulation_mode
, mstat.reference_period_rule
, mstat.pending_invoice_days
, mstat.prior_invoice_days
, mstat.returns_processing
, mstat.kit_method
, nvl(mstat.include_establishments,'N')
FROM
GL_PERIODS glp
, GL_PERIODS glp1
, gl_ledger_le_v gllv
, MTL_STAT_TYPE_USAGES mstat
WHERE glp.period_set_name = mstat.period_set_name
AND glp1.period_set_name = mstat.period_set_name
AND glp.period_name = mstat.start_period_name
AND glp1.period_name = NVL(mstat.end_period_name,
mstat.start_period_name)
AND gllv.legal_entity_id = mstat.legal_entity_id
AND ledger_category_code = 'PRIMARY'
AND mstat.legal_entity_id = p_legal_entity_id
AND mstat.zone_code = p_movement_transaction.zone_code
AND mstat.usage_type = p_movement_transaction.usage_type
AND mstat.stat_type = p_movement_transaction.stat_type
AND trunc(l_transaction_date) BETWEEN trunc(glp.start_date) AND
TRUNC(DECODE(mstat.end_period_name,NULL,
(l_transaction_date+1),glp1.end_date));
SELECT
mstat.zone_code
, UPPER(mstat.usage_type)
, UPPER(mstat.stat_type )
, mstat.reference_period_rule
, mstat.pending_invoice_days
, mstat.prior_invoice_days
, mstat.triangulation_mode
FROM
MTL_STAT_TYPE_USAGES mstat
WHERE mstat.legal_entity_id = p_legal_entity_id;
SELECT
mstat.start_period_name
, mstat.end_period_name
, mstat.period_set_name
, mstat.period_type
, mstat.weight_uom_code
, mstat.conversion_type
, mstat.attribute_rule_set_code
, mstat.alt_uom_rule_set_code
, glp.start_date
, DECODE(mstat.end_period_name,NULL,NULL,glp1.end_date)
, mstat.category_set_id
, gllv.currency_code
, gllv.currency_code
, mstat.conversion_option
, mstat.triangulation_mode
, mstat.reference_period_rule
, mstat.pending_invoice_days
, mstat.prior_invoice_days
, mstat.returns_processing
FROM
GL_PERIODS glp
, GL_PERIODS glp1
, gl_ledger_le_v gllv
, MTL_STAT_TYPE_USAGES mstat
WHERE glp.period_set_name = glp1.period_set_name
AND glp.period_set_name = mstat.period_set_name
AND glp1.period_set_name = mstat.period_set_name
AND glp.period_type = mstat.period_type
AND glp1.period_type = mstat.period_type
AND glp.period_name = mstat.start_period_name
AND glp1.period_name = NVL(mstat.end_period_name,
mstat.start_period_name)
--AND glb.period_set_name = glp.period_set_name fix bug2203762,3723698
AND gllv.legal_entity_id = mstat.legal_entity_id
AND gllv.ledger_category_code = 'PRIMARY'
AND mstat.legal_entity_id = p_legal_entity_id
AND mstat.zone_code = p_movement_transaction.zone_code
AND mstat.usage_type = p_movement_transaction.usage_type
AND mstat.stat_type = p_movement_transaction.stat_type;
l_insert_flag VARCHAR2(1);
l_insert_flag := 'N';
l_insert_flag := 'Y';
l_insert_flag := 'N';
l_insert_flag := 'N';
l_insert_flag := 'Y';
l_insert_flag := 'N';
l_insert_flag := 'N';
RETURN l_insert_flag;
SELECT conversion_option
, conversion_type
, category_set_id
, start_period_name
, end_period_name
, weight_uom_code
, period_set_name
, attribute_rule_set_code
, alt_uom_rule_set_code
, returns_processing
INTO x_movement_stat_usages_rec.conversion_option
, x_movement_stat_usages_rec.conversion_type
, x_movement_stat_usages_rec.category_set_id
, x_movement_stat_usages_rec.start_period_name
, x_movement_stat_usages_rec.end_period_name
, x_movement_stat_usages_rec.weight_uom_code
, x_movement_stat_usages_rec.period_set_name
, x_movement_stat_usages_rec.attribute_rule_set_code
, x_movement_stat_usages_rec.alt_uom_rule_set_code
, x_movement_stat_usages_rec.returns_processing
FROM mtl_stat_type_usages
WHERE legal_entity_id = p_legal_entity_id
AND zone_code = p_economic_zone_code
AND usage_type = p_usage_type
AND stat_type = p_stat_type;
SELECT ledger_id
, currency_code
INTO x_movement_stat_usages_rec.gl_set_of_books_id
, x_movement_stat_usages_rec.gl_currency_code
FROM gl_ledger_le_v
WHERE legal_entity_id = p_legal_entity_id
AND ledger_category_code = 'PRIMARY';