APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_SCO_RATES_B_V

Line 1493: FROM ZX_SCO_RATES_B_V

1489: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1490: c_tax_rate_code VARCHAR2,
1491: c_tax_date DATE) IS
1492: SELECT recovery_rule_code
1493: FROM ZX_SCO_RATES_B_V
1494: WHERE tax_regime_code = c_tax_regime_code
1495: AND tax = c_tax
1496: AND tax_status_code = c_tax_status_code
1497: AND tax_rate_code = c_tax_rate_code

Line 1529: FROM ZX_SCO_RATES_B_V

1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1526: SELECT tax_rate_id,
1527: percentage_rate,
1528: allow_adhoc_tax_rate_flag
1529: FROM ZX_SCO_RATES_B_V
1530: WHERE tax_regime_code = c_tax_regime_code
1531: AND tax = c_tax
1532: AND tax_rate_code = c_tax_rate_code
1533: AND rate_type_code = 'RECOVERY'

Line 1553: FROM ZX_SCO_RATES_B_V rate

1549: SELECT rate.tax_rate_id,
1550: rate.tax_rate_code,
1551: rate.percentage_rate,
1552: rate.allow_adhoc_tax_rate_flag
1553: FROM ZX_SCO_RATES_B_V rate
1554: WHERE tax = c_tax
1555: AND tax_regime_code = c_tax_regime_code
1556: AND active_flag = 'Y'
1557: -- AND tax_jurisdiction_code(+) = c_tax_jurisdiction_code

Line 1580: FROM ZX_SCO_RATES_B_V rate

1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1577: c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1578: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1579: SELECT default_rec_rate_code
1580: FROM ZX_SCO_RATES_B_V rate
1581: WHERE rate.effective_from <= c_tax_date
1582: AND (rate.effective_to >= c_tax_date OR rate.effective_to IS NULL)
1583: AND rate.tax_rate_code = c_tax_rate_code
1584: AND rate.tax_status_code = c_tax_status_code