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: 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: 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 1315: FROM zx_account_rates

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

Line 1496: FROM zx_account_rates

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

Line 1648: FROM zx_account_rates

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

Line 1658: FROM zx_account_rates

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

Line 1891: FROM zx_account_rates

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