The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rate.tax_regime_code,
rate.tax,
rate.tax_status_code,
rate.tax_rate_code,
rate.tax_rate_id,
rate.effective_from,
rate.effective_to,
rate.rate_type_code,
rate.percentage_rate,
rate.quantity_rate,
rate.allow_adhoc_tax_rate_flag,
rate.uom_code,
rate.tax_jurisdiction_code,
rate.offset_tax,
rate.offset_status_code,
rate.offset_tax_rate_code,
rate.allow_exemptions_flag,
rate.allow_exceptions_flag,
jur.tax_jurisdiction_id,
rate.def_rec_settlement_option_code,
rate.taxable_basis_formula_code,
rate.adj_for_adhoc_amt_code,
rate.inclusive_tax_flag,
rate.tax_class
FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
AND rate.tax = jur.tax
AND rate.tax_regime_code = jur.tax_regime_code
AND rate.effective_from <= p_tax_date
AND (rate.effective_to >= p_tax_date OR rate.effective_to IS NULL )
AND rate.tax_rate_code = p_tax_rate_code
AND rate.tax_status_code = p_tax_status_code
AND rate.tax = p_tax
AND rate.tax_regime_code = p_tax_regime_code
AND rate.active_flag = 'Y'
AND rate.tax_class IS NULL
ORDER BY jur.precedence_level, rate.subscription_level_code;
SELECT rate.tax_regime_code,
rate.tax,
rate.tax_status_code,
rate.tax_rate_code,
rate.tax_rate_id,
rate.effective_from,
rate.effective_to,
rate.rate_type_code,
rate.percentage_rate,
rate.quantity_rate,
rate.allow_adhoc_tax_rate_flag,
rate.uom_code,
rate.tax_jurisdiction_code,
rate.offset_tax,
rate.offset_status_code,
rate.offset_tax_rate_code,
rate.allow_exemptions_flag,
rate.allow_exceptions_flag,
jur.tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
AND rate.tax = jur.tax
AND rate.tax_regime_code = jur.tax_regime_code
AND rate.effective_from <= p_tax_date
AND (rate.effective_to >= p_tax_date OR rate.effective_to IS NULL )
AND rate.tax_rate_code = p_tax_rate_code
AND rate.tax_status_code = p_tax_status_code
AND rate.tax = p_tax
AND rate.tax_regime_code = p_tax_regime_code
AND rate.active_flag = 'Y'
AND rate.tax_class = p_tax_class
ORDER BY jur.precedence_level, rate.subscription_level_code;
SELECT rate.tax_regime_code,
rate.tax,
rate.tax_status_code,
rate.tax_rate_code,
rate.tax_rate_id,
rate.effective_from,
rate.effective_to,
rate.rate_type_code,
rate.percentage_rate,
rate.quantity_rate,
rate.allow_adhoc_tax_rate_flag,
rate.uom_code,
rate.tax_jurisdiction_code,
rate.offset_tax,
rate.offset_status_code,
rate.offset_tax_rate_code,
rate.allow_exemptions_flag,
rate.allow_exceptions_flag,
jur.tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
AND rate.tax = jur.tax
AND rate.tax_regime_code = jur.tax_regime_code
AND rate.tax_status_code = p_tax_status_code
AND rate.tax = p_tax
AND rate.tax_regime_code = p_tax_regime_code
AND rate.default_flg_effective_from <= p_tax_date
AND (rate.default_flg_effective_to >= p_tax_date
OR rate.default_flg_effective_to IS NULL)
AND rate.default_rate_flag = 'Y'
AND rate.active_flag = 'Y'
AND rate.tax_class IS NULL
ORDER BY jur.precedence_level, rate.subscription_level_code;
SELECT rate.tax_regime_code,
rate.tax,
rate.tax_status_code,
rate.tax_rate_code,
rate.tax_rate_id,
rate.effective_from,
rate.effective_to,
rate.rate_type_code,
rate.percentage_rate,
rate.quantity_rate,
rate.allow_adhoc_tax_rate_flag,
rate.uom_code,
rate.tax_jurisdiction_code,
rate.offset_tax,
rate.offset_status_code,
rate.offset_tax_rate_code,
rate.allow_exemptions_flag,
rate.allow_exceptions_flag,
jur.tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
AND rate.tax = jur.tax
AND rate.tax_regime_code = jur.tax_regime_code
AND rate.tax_status_code = p_tax_status_code
AND rate.tax = p_tax
AND rate.tax_regime_code = p_tax_regime_code
AND rate.default_flg_effective_from <= p_tax_date
AND (rate.default_flg_effective_to >= p_tax_date
OR rate.default_flg_effective_to IS NULL)
AND rate.default_rate_flag = 'Y'
AND rate.active_flag = 'Y'
AND rate.tax_class = p_tax_class
ORDER BY jur.precedence_level, rate.subscription_level_code;
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
AND effective_from <= p_tax_date
AND (effective_to >= p_tax_date OR effective_to IS NULL )
AND tax_rate_code = p_tax_rate_code
AND tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND Active_Flag = 'Y'
AND tax_class IS NULL
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
AND effective_from <= p_tax_date
AND (effective_to >= p_tax_date OR effective_to IS NULL )
AND tax_rate_code = p_tax_rate_code
AND tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND Active_Flag = 'Y'
AND tax_class = p_tax_class
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_jurisdiction_code IS NULL
AND effective_from <= p_tax_date
AND ( effective_to >= p_tax_date OR effective_to IS NULL)
AND tax_rate_code = p_tax_rate_code
AND tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND Active_Flag = 'Y'
AND tax_class IS NULL
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_jurisdiction_code IS NULL
AND effective_from <= p_tax_date
AND ( effective_to >= p_tax_date OR effective_to IS NULL)
AND tax_rate_code = p_tax_rate_code
AND tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND Active_Flag = 'Y'
AND tax_class = p_tax_class
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND tax_jurisdiction_code = p_tax_jurisdiction_code
AND default_flg_effective_from <= p_tax_date
AND (default_flg_effective_to >= p_tax_date
OR default_flg_effective_to IS NULL)
AND Default_Rate_Flag = 'Y'
AND Active_Flag = 'Y'
AND tax_class IS NULL
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND tax_jurisdiction_code = p_tax_jurisdiction_code
AND default_flg_effective_from <= p_tax_date
AND (default_flg_effective_to >= p_tax_date
OR default_flg_effective_to IS NULL)
AND Default_Rate_Flag = 'Y'
AND Active_Flag = 'Y'
AND tax_class = p_tax_class
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND tax_jurisdiction_code IS NULL
AND default_flg_effective_from <= p_tax_date
AND (default_flg_effective_to >= p_tax_date
OR default_flg_effective_to IS NULL)
AND Default_Rate_Flag = 'Y'
AND Active_Flag = 'Y'
AND tax_class IS NULL
ORDER BY subscription_level_code; -- Bug#5395227
SELECT tax_regime_code,
tax,
tax_status_code,
tax_rate_code,
tax_rate_id,
effective_from,
effective_to,
rate_type_code,
percentage_rate,
quantity_rate,
Allow_Adhoc_Tax_Rate_Flag,
uom_code,
tax_jurisdiction_code,
offset_tax,
offset_status_code,
offset_tax_rate_code,
allow_exemptions_flag,
allow_exceptions_flag,
NULL tax_jurisdiction_id,
def_rec_settlement_option_code,
taxable_basis_formula_code,
adj_for_adhoc_amt_code,
inclusive_tax_flag,
tax_class
FROM ZX_SCO_RATES_B_V -- Bug#5395227
WHERE tax_status_code = p_tax_status_code
AND tax = p_tax
AND tax_regime_code = p_tax_regime_code
AND tax_jurisdiction_code IS NULL
AND default_flg_effective_from <= p_tax_date
AND (default_flg_effective_to >= p_tax_date
OR default_flg_effective_to IS NULL)
AND Default_Rate_Flag = 'Y'
AND Active_Flag = 'Y'
AND tax_class = p_tax_class
ORDER BY subscription_level_code; -- Bug#5395227
SELECT COUNT(*) into l_count_jur
FROM ZX_JURISDICTIONS_GT;