APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_SCO_RATES_B_V

Line 1590: -- FROM ZX_SCO_RATES_B_V

1586: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1587: -- c_tax_rate_code VARCHAR2,
1588: -- c_tax_date DATE) IS
1589: -- SELECT recovery_rule_code
1590: -- FROM ZX_SCO_RATES_B_V
1591: -- WHERE tax_regime_code = c_tax_regime_code
1592: -- AND tax = c_tax
1593: -- AND tax_status_code = c_tax_status_code
1594: -- AND tax_rate_code = c_tax_rate_code

Line 1611: -- FROM ZX_SCO_RATES_B_V rate

1607: -- c_tax_date DATE,
1608: -- c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1609: -- c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1610: -- SELECT default_rec_rate_code
1611: -- FROM ZX_SCO_RATES_B_V rate
1612: -- WHERE rate.effective_from <= c_tax_date
1613: -- AND (rate.effective_to >= c_tax_date OR rate.effective_to IS NULL)
1614: -- AND rate.tax_rate_code = c_tax_rate_code
1615: -- AND rate.tax_status_code = c_tax_status_code

Line 1645: FROM ZX_SCO_RATES_B_V

1641: c_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE) IS
1642: SELECT tax_rate_id,
1643: percentage_rate,
1644: allow_adhoc_tax_rate_flag
1645: FROM ZX_SCO_RATES_B_V
1646: WHERE tax_regime_code = c_tax_regime_code
1647: AND tax = c_tax
1648: AND tax_rate_code = c_tax_rate_code
1649: AND rate_type_code = 'RECOVERY'

Line 1667: FROM ZX_SCO_RATES_B_V rate

1663: SELECT rate.tax_rate_id,
1664: rate.tax_rate_code,
1665: rate.percentage_rate,
1666: rate.allow_adhoc_tax_rate_flag
1667: FROM ZX_SCO_RATES_B_V rate
1668: WHERE tax = c_tax
1669: AND tax_regime_code = c_tax_regime_code
1670: AND active_flag = 'Y'
1671: AND default_flg_effective_from <= c_tax_date