eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_TAX_RATE_PKG dependencies on ZX_SCO_RATES_B_V

Line 168: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

164: rate.taxable_basis_formula_code,
165: rate.adj_for_adhoc_amt_code,
166: rate.inclusive_tax_flag,
167: rate.tax_class
168: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
169: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
170: AND jur.tax = p_tax
171: AND jur.tax_regime_code = p_tax_regime_code
172: AND rate.effective_from <= p_tax_date

Line 208: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

204: taxable_basis_formula_code,
205: adj_for_adhoc_amt_code,
206: inclusive_tax_flag,
207: tax_class
208: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
209: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
210: AND jur.tax = p_tax
211: AND jur.tax_regime_code = p_tax_regime_code
212: AND rate.effective_from <= p_tax_date

Line 433: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

429: taxable_basis_formula_code,
430: adj_for_adhoc_amt_code,
431: inclusive_tax_flag,
432: tax_class
433: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
434: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
435: AND jur.tax = p_tax
436: AND jur.tax_regime_code = p_tax_regime_code
437: AND rate.tax_status_code = p_tax_status_code

Line 474: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur

470: taxable_basis_formula_code,
471: adj_for_adhoc_amt_code,
472: inclusive_tax_flag,
473: tax_class
474: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
475: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
476: AND jur.tax = p_tax
477: AND jur.tax_regime_code = p_tax_regime_code
478: AND rate.tax_status_code = p_tax_status_code

Line 692: FROM ZX_SCO_RATES_B_V -- Bug#5395227

688: taxable_basis_formula_code,
689: adj_for_adhoc_amt_code,
690: inclusive_tax_flag,
691: tax_class
692: FROM ZX_SCO_RATES_B_V -- Bug#5395227
693: WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
694: AND effective_from <= p_tax_date
695: AND (effective_to >= p_tax_date OR effective_to IS NULL )
696: AND tax_rate_code = p_tax_rate_code

Line 729: FROM ZX_SCO_RATES_B_V -- Bug#5395227

725: taxable_basis_formula_code,
726: adj_for_adhoc_amt_code,
727: inclusive_tax_flag,
728: tax_class
729: FROM ZX_SCO_RATES_B_V -- Bug#5395227
730: WHERE tax_jurisdiction_code = p_tax_jurisdiction_code
731: AND effective_from <= p_tax_date
732: AND (effective_to >= p_tax_date OR effective_to IS NULL )
733: AND tax_rate_code = p_tax_rate_code

Line 943: FROM ZX_SCO_RATES_B_V -- Bug#5395227

939: taxable_basis_formula_code,
940: adj_for_adhoc_amt_code,
941: inclusive_tax_flag,
942: tax_class
943: FROM ZX_SCO_RATES_B_V -- Bug#5395227
944: WHERE tax_jurisdiction_code IS NULL
945: AND effective_from <= p_tax_date
946: AND ( effective_to >= p_tax_date OR effective_to IS NULL)
947: AND tax_rate_code = p_tax_rate_code

Line 980: FROM ZX_SCO_RATES_B_V -- Bug#5395227

976: taxable_basis_formula_code,
977: adj_for_adhoc_amt_code,
978: inclusive_tax_flag,
979: tax_class
980: FROM ZX_SCO_RATES_B_V -- Bug#5395227
981: WHERE tax_jurisdiction_code IS NULL
982: AND effective_from <= p_tax_date
983: AND ( effective_to >= p_tax_date OR effective_to IS NULL)
984: AND tax_rate_code = p_tax_rate_code

Line 1185: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1181: taxable_basis_formula_code,
1182: adj_for_adhoc_amt_code,
1183: inclusive_tax_flag,
1184: tax_class
1185: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1186: WHERE tax_status_code = p_tax_status_code
1187: AND tax = p_tax
1188: AND tax_regime_code = p_tax_regime_code
1189: AND tax_jurisdiction_code = p_tax_jurisdiction_code

Line 1223: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1219: taxable_basis_formula_code,
1220: adj_for_adhoc_amt_code,
1221: inclusive_tax_flag,
1222: tax_class
1223: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1224: WHERE tax_status_code = p_tax_status_code
1225: AND tax = p_tax
1226: AND tax_regime_code = p_tax_regime_code
1227: AND tax_jurisdiction_code = p_tax_jurisdiction_code

Line 1430: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1426: taxable_basis_formula_code,
1427: adj_for_adhoc_amt_code,
1428: inclusive_tax_flag,
1429: tax_class
1430: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1431: WHERE tax_status_code = p_tax_status_code
1432: AND tax = p_tax
1433: AND tax_regime_code = p_tax_regime_code
1434: AND tax_jurisdiction_code IS NULL

Line 1468: FROM ZX_SCO_RATES_B_V -- Bug#5395227

1464: taxable_basis_formula_code,
1465: adj_for_adhoc_amt_code,
1466: inclusive_tax_flag,
1467: tax_class
1468: FROM ZX_SCO_RATES_B_V -- Bug#5395227
1469: WHERE tax_status_code = p_tax_status_code
1470: AND tax = p_tax
1471: AND tax_regime_code = p_tax_regime_code
1472: AND tax_jurisdiction_code IS NULL