APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on ZX_RATES_B

Line 731: FROM zx_rates_b rates,

727: AND applied_from_trx_id IS NULL
728: AND adjusted_doc_trx_id IS NULL
729: AND NOT EXISTS
730: (SELECT 1
731: FROM zx_rates_b rates,
732: zx_detail_tax_lines_gt gt2
733: WHERE gt2.application_id = gt1.application_id
734: AND gt2.entity_code = gt1.entity_code
735: AND gt2.event_class_code = gt1.event_class_code

Line 746: FROM zx_rates_b rates,

742: )
743: AND NOT EXISTS
744: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
745: 1
746: FROM zx_rates_b rates,
747: zx_lines zl
748: WHERE zl.application_id = gt1.application_id
749: AND zl.entity_code = gt1.entity_code
750: AND zl.event_class_code = gt1.event_class_code

Line 1425: l_tax_class zx_rates_b.tax_class%TYPE;

1421: l_unrounded_tax_amt_tab num_tab_type;
1422: l_unrounded_taxable_amt_tab num_tab_type;
1423: l_manually_entered_flag_tab var_1_tab_type;
1424:
1425: l_tax_class zx_rates_b.tax_class%TYPE;
1426:
1427: CURSOR get_tax_info_csr IS
1428: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1429: tax_line_id,

Line 2894: l_tax_class ZX_RATES_B.tax_class%TYPE;

2890: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2891: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2892: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2893:
2894: l_tax_class ZX_RATES_B.tax_class%TYPE;
2895:
2896: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
2897: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2898: TYPE var_30_tab_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;