The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tax_status_code
FROM zx_sco_status
WHERE tax_regime_code = p_tax_regime_code
AND tax = p_tax
AND default_status_flag = 'Y'
AND p_date >= default_flg_effective_from
AND (p_date <= default_flg_effective_to OR default_flg_effective_to IS NULL);
SELECT tax_rate_code
FROM zx_sco_rates
WHERE tax_regime_code = p_tax_regime_code
AND tax = p_tax
AND tax_status_code = c_status_code
AND active_flag = 'Y'
AND default_rate_flag = 'Y'
AND p_date >= default_flg_effective_from
AND (p_date <= default_flg_effective_to OR default_flg_effective_to IS NULL);
SELECT intended_use_default, product_categ_default, primary_inventory_category_set
FROM zx_fc_country_defaults
WHERE country_code = p_country_code;
SELECT intended_use_default
FROM zx_fc_country_defaults
WHERE country_code = p_country_code;
SELECT product_categ_default
FROM zx_fc_country_defaults
WHERE country_code = p_country_code;
SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
FROM zx_evnt_cls_mappings
WHERE application_id = p_application_id
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code;
SELECT DEF_INTRCMP_TRX_BIZ_CATEGORY
FROM ZX_EVNT_CLS_OPTIONS
WHERE event_class_code = p_event_class_code
AND FIRST_PTY_ORG_ID = p_org_id;
SELECT owner_table_code,owner_id_num
FROM zx_fc_types_b
WHERE classification_type_code ='INTENDED_USE';
SELECT category_id
FROM mtl_item_categories
WHERE category_set_id = l_owner_id_num
AND organization_id = p_org_id
AND inventory_item_id = p_item_id;
SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
FROM MTL_CATEGORIES_B_KFV mtl,
FND_ID_FLEX_STRUCTURES flex,
MTL_CATEGORY_SETS_B mcs
WHERE mtl.structure_id = mcs.structure_id
AND mcs.category_set_id = l_owner_id_num
AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
AND flex.APPLICATION_ID = 401
AND flex.ID_FLEX_CODE = 'MCAT'
AND mtl.category_id = l_category_id;
SELECT F.LOOKUP_CODE
FROM FND_LOOKUPS F,
MTL_SYSTEM_ITEMS_B I
WHERE F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
AND I.INVENTORY_ITEM_ID = p_item_id
AND I.ORGANIZATION_ID = p_org_id
AND F.LOOKUP_CODE = DECODE (I.CONTRACT_ITEM_TYPE_CODE,
'SERVICE','SERVICES',
'WARRANTY','SERVICES',
'USAGE','SERVICES',
'SUBSCRIPTION','GOODS',
'GOODS');
SELECT classification_code
FROM zx_fc_codes_denorm_b
WHERE classification_type_code = c_classification_type
AND country_code = p_country_code
AND LANGUAGE = userenv('LANG');
SELECT delimiter
FROM zx_fc_types_b
WHERE classification_type_code ='TRX_BUSINESS_CATEGORY';
SELECT intended_use_default, product_categ_default, primary_inventory_category_set
FROM zx_fc_country_defaults
WHERE country_code = p_country_code;
SELECT category_id
FROM mtl_item_categories
WHERE category_set_id = l_category_set
AND organization_id = p_org_id
AND inventory_item_id = p_item_id;
SELECT default_category_id
FROM mtl_category_sets_b
WHERE category_set_id = l_category_set;
SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
FROM MTL_CATEGORIES_B_KFV mtl,
FND_ID_FLEX_STRUCTURES flex,
MTL_CATEGORY_SETS_B mcs
WHERE mtl.structure_id = mcs.structure_id
AND mcs.category_set_id = l_category_set
AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
AND flex.APPLICATION_ID = 401
AND flex.ID_FLEX_CODE = 'MCAT'
AND mtl.category_id = l_category_id;
Select product_categ_default
From ZX_FC_COUNTRY_DEFAULTS
Where country_code = p_country_code;
SELECT STATUS, DB_STATUS
INTO l_status, l_db_status
FROM fnd_product_installations
WHERE APPLICATION_ID = '401';
Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
From zx_registrations reg
,zx_party_tax_profile ptp
Where ptp.party_id = p_party_id
AND ptp.party_type_code = p_party_type
AND ptp.party_tax_profile_id = reg.party_tax_profile_id
AND reg.default_registration_flag = 'Y'
AND l_effective_date >= effective_from
AND (l_effective_date <= effective_to OR effective_to IS NULL);
Select REP_REGISTRATION_NUMBER
From zx_party_tax_profile ptp
Where ptp.party_id = p_party_id
AND ptp.party_type_code = p_party_type;
SELECT distinct xle.legal_entity_id
INTO l_legal_entity_id
from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
where tr.registration_number = p_registration_num
and tr.party_tax_profile_id = ptp.party_tax_profile_id
and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
and ptp.party_id = xle.party_id;
select TERRITORY_CODE into l_territory_code
FROM FND_TERRITORIES
WHERE TERRITORY_CODE = p_country_code;