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_EXTRACT_PKG dependencies on ZX_RATES_B

Line 1487: FROM ZX_RATES_B

1483: IF ( (P_TAX_RATE_CODE_LOW IS NOT NULL OR P_TAX_RATE_CODE_HIGH IS NOT NULL) AND P_TAX_JURISDICTION_CODE IS NOT NULL ) THEN
1484:
1485: SELECT Nvl(MIN(TAX_RATE_CODE),P_TAX_RATE_CODE_LOW), Nvl(MAX(TAX_RATE_CODE),P_TAX_RATE_CODE_HIGH)
1486: INTO P_TRL_GLOBAL_VARIABLES_REC.TAX_RATE_CODE_LOW, P_TRL_GLOBAL_VARIABLES_REC.TAX_RATE_CODE_HIGH
1487: FROM ZX_RATES_B
1488: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE
1489: AND TAX = P_TAX
1490: AND TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE
1491: AND TAX_STATUS_CODE = P_TAX_STATUS_CODE

Line 1495: FROM ZX_RATES_B

1491: AND TAX_STATUS_CODE = P_TAX_STATUS_CODE
1492: AND tax_rate_code BETWEEN P_TAX_RATE_CODE_LOW AND P_TAX_RATE_CODE_HIGH
1493: AND (P_TAX_RATE_CODE_LOW IN
1494: (SELECT tax_rate_code
1495: FROM ZX_RATES_B
1496: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE
1497: AND TAX = P_TAX
1498: AND TAX_STATUS_CODE = P_TAX_STATUS_CODE
1499: AND TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE)

Line 1502: FROM ZX_RATES_B

1498: AND TAX_STATUS_CODE = P_TAX_STATUS_CODE
1499: AND TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE)
1500: OR P_TAX_RATE_CODE_HIGH IN
1501: (SELECT tax_rate_code
1502: FROM ZX_RATES_B
1503: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE
1504: AND TAX = P_TAX
1505: AND TAX_STATUS_CODE = P_TAX_STATUS_CODE
1506: AND TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE)