APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_ACCOUNT_RATES

Line 104: FROM zx_account_rates acr,

100: acr.tax_status_code,
101: acr.tax_rate_code,
102: nvl(rates.source_id, rates.tax_rate_id),
103: acr.tax_class
104: FROM zx_account_rates acr,
105: zx_sco_rates rates
106: WHERE rates.tax_regime_code = acr.tax_regime_code
107: AND rates.tax = acr.tax
108: AND rates.tax_status_code = acr.tax_status_code

Line 133: FROM zx_account_rates acr,

129: acr.tax_status_code,
130: acr.tax_rate_code,
131: nvl(rates.source_id, rates.tax_rate_id),
132: acr.tax_class
133: FROM zx_account_rates acr,
134: zx_sco_rates rates
135: WHERE rates.tax_regime_code = acr.tax_regime_code
136: AND rates.tax = acr.tax
137: AND rates.tax_status_code = acr.tax_status_code

Line 1317: FROM zx_account_rates

1313:
1314: CURSOR rounding_rule_cur (p_ledger_id NUMBER,
1315: p_tax_class VARCHAR) IS
1316: SELECT rounding_rule_code
1317: FROM zx_account_rates
1318: WHERE ledger_id = p_ledger_id
1319: AND account_segment_value IS NULL
1320: AND (tax_class = p_tax_class
1321: OR

Line 1497: FROM zx_account_rates

1493: CURSOR precision_mau_cur (p_ledger_id NUMBER)
1494: IS
1495: SELECT tax_precision,
1496: tax_mau
1497: FROM zx_account_rates
1498: WHERE ledger_id = p_ledger_id
1499: AND account_segment_value IS NULL
1500: AND rownum = 1;
1501:

Line 1649: FROM zx_account_rates

1645: CURSOR rate_level_cur (p_ledger_id NUMBER,
1646: p_account_segment_value VARCHAR2,
1647: p_tax_class VARCHAR2) IS
1648: SELECT amt_incl_tax_flag
1649: FROM zx_account_rates
1650: WHERE account_segment_value = p_account_segment_value
1651: AND ledger_id = p_ledger_id
1652: AND (tax_class = p_tax_class
1653: OR tax_class IS NULL);

Line 1659: FROM zx_account_rates

1655:
1656: CURSOR ledger_level_cur (p_ledger_id NUMBER,
1657: p_tax_class VARCHAR2) IS
1658: SELECT amt_incl_tax_flag
1659: FROM zx_account_rates
1660: WHERE ledger_id = p_ledger_id
1661: AND (tax_class = p_tax_class
1662: OR tax_class IS NULL)
1663: AND account_segment_value IS NULL;

Line 1892: FROM zx_account_rates

1888: SELECT calculation_level_code,
1889: decode(tax_mau, NULL, power(10,-1*tax_precision), tax_mau)
1890: INTO x_calculation_level_code,
1891: x_tax_mau
1892: FROM zx_account_rates
1893: WHERE ledger_id = p_ledger_id
1894: AND account_segment_value IS NULL
1895: AND rownum = 1;
1896: