APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on ZX_RATES_B

Line 715: FROM zx_rates_b rates,

711: AND applied_from_trx_id IS NULL
712: AND adjusted_doc_trx_id IS NULL
713: AND NOT EXISTS
714: (SELECT 1
715: FROM zx_rates_b rates,
716: zx_detail_tax_lines_gt gt2
717: WHERE gt2.application_id = gt1.application_id
718: AND gt2.entity_code = gt1.entity_code
719: AND gt2.event_class_code = gt1.event_class_code

Line 730: FROM zx_rates_b rates,

726: )
727: AND NOT EXISTS
728: (SELECT /*+ INDEX(zl ZX_LINES_U1) */
729: 1
730: FROM zx_rates_b rates,
731: zx_lines zl
732: WHERE zl.application_id = gt1.application_id
733: AND zl.entity_code = gt1.entity_code
734: AND zl.event_class_code = gt1.event_class_code

Line 1397: l_tax_class zx_rates_b.tax_class%TYPE;

1393: l_unrounded_tax_amt_tab num_tab_type;
1394: l_unrounded_taxable_amt_tab num_tab_type;
1395: l_manually_entered_flag_tab var_1_tab_type;
1396:
1397: l_tax_class zx_rates_b.tax_class%TYPE;
1398:
1399: CURSOR get_tax_info_csr IS
1400: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
1401: tax_line_id,

Line 2281: l_tax_class ZX_RATES_B.tax_class%TYPE;

2277: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2278: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2279: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2280:
2281: l_tax_class ZX_RATES_B.tax_class%TYPE;
2282:
2283: TYPE date_tab_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
2284: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2285: TYPE var_30_tab_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;