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_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_STATUS_B

Line 743: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

739:
740: l_tax ZX_TAXES_B.tax%TYPE;
741: l_tax_id NUMBER;
742: l_index NUMBER;
743: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
744: l_rec_nrec_tax_dist_number NUMBER;
745:
746: CURSOR get_tax_recovery_info_cur(
747: c_tax_id zx_taxes_b.tax_id%TYPE) IS

Line 1471: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;

1467: l_tax_determine_date DATE;
1468:
1469: l_tax ZX_TAXES_B.tax%TYPE;
1470: l_tax_date DATE;
1471: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1473: l_rec_rate NUMBER;
1474: l_total_rec_rate NUMBER;
1475: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;

Line 1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

1468:
1469: l_tax ZX_TAXES_B.tax%TYPE;
1470: l_tax_date DATE;
1471: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1473: l_rec_rate NUMBER;
1474: l_total_rec_rate NUMBER;
1475: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
1476: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;

Line 1487: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;
1484:
1485: /*** Bug#5395227
1486: CURSOR get_rec_rule_code_csr(
1487: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1488: c_tax ZX_STATUS_B.tax%TYPE,
1489: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1490: c_tax_rate_code VARCHAR2,
1491: c_tax_date DATE) IS

Line 1488: c_tax ZX_STATUS_B.tax%TYPE,

1484:
1485: /*** Bug#5395227
1486: CURSOR get_rec_rule_code_csr(
1487: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1488: c_tax ZX_STATUS_B.tax%TYPE,
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

Line 1489: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,

1485: /*** Bug#5395227
1486: CURSOR get_rec_rule_code_csr(
1487: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1488: c_tax ZX_STATUS_B.tax%TYPE,
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

Line 1519: c_tax ZX_STATUS_B.tax%TYPE,

1515: WHERE tax_rate_id = c_tax_rate_id;
1516:
1517:
1518: CURSOR get_rec_rate_csr(
1519: c_tax ZX_STATUS_B.tax%TYPE,
1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,

Line 1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1516:
1517:
1518: CURSOR get_rec_rate_csr(
1519: c_tax ZX_STATUS_B.tax%TYPE,
1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,
1524: c_tax_class zx_rates_b.tax_class%TYPE,

Line 1544: c_tax ZX_STATUS_B.tax%TYPE,

1540: ORDER BY tax_class NULLS LAST, subscription_level_code;
1541: -- AND rate.tax_jurisdiction_code(+) = c_tax_jurisdiction_code
1542:
1543: CURSOR get_def_rec_rate_from_type_csr(
1544: c_tax ZX_STATUS_B.tax%TYPE,
1545: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1546: c_tax_date DATE,
1547: c_tax_class zx_rates_b.tax_class%TYPE,
1548: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE) IS

Line 1545: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1541: -- AND rate.tax_jurisdiction_code(+) = c_tax_jurisdiction_code
1542:
1543: CURSOR get_def_rec_rate_from_type_csr(
1544: c_tax ZX_STATUS_B.tax%TYPE,
1545: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1546: c_tax_date DATE,
1547: c_tax_class zx_rates_b.tax_class%TYPE,
1548: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE) IS
1549: SELECT rate.tax_rate_id,

Line 1572: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,

1568:
1569: /*** Bug#5395227- use get_rec_info_csr
1570:
1571: CURSOR get_def_rec_rate_from_rate_csr(
1572: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1573: c_tax ZX_STATUS_B.tax%TYPE,
1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,

Line 1573: c_tax ZX_STATUS_B.tax%TYPE,

1569: /*** Bug#5395227- use get_rec_info_csr
1570:
1571: CURSOR get_def_rec_rate_from_rate_csr(
1572: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1573: c_tax ZX_STATUS_B.tax%TYPE,
1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
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,

Line 1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1570:
1571: CURSOR get_def_rec_rate_from_rate_csr(
1572: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1573: c_tax ZX_STATUS_B.tax%TYPE,
1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
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