APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 4457: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */

4453: 'update the adjustments to the largest lines ....');
4454: END IF;
4455:
4456: FORALL i IN 1 .. l_count
4457: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4458: ZX_DETAIL_TAX_LINES_GT
4459: SET tax_amt = l_tax_amt_tbl(i),
4460: tax_amt_tax_curr = l_tax_amt_tax_curr_tbl(i),
4461: tax_amt_funcl_curr = l_tax_amt_funcl_curr_tbl(i),

Line 4458: ZX_DETAIL_TAX_LINES_GT

4454: END IF;
4455:
4456: FORALL i IN 1 .. l_count
4457: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4458: ZX_DETAIL_TAX_LINES_GT
4459: SET tax_amt = l_tax_amt_tbl(i),
4460: tax_amt_tax_curr = l_tax_amt_tax_curr_tbl(i),
4461: tax_amt_funcl_curr = l_tax_amt_funcl_curr_tbl(i),
4462: taxable_amt_tax_curr = l_taxable_amt_tax_curr_tbl(i),

Line 5496: NOT EXISTS (SELECT /*+ INDEX(G ZX_DETAIL_TAX_LINES_GT_U2) */ 1

5492: NVL(L.currency_conversion_type, 'X') = NVL(c_currency_conversion_type, 'X') AND
5493: NVL(L.currency_conversion_rate, -999) = NVL(c_currency_conversion_rate, -999) AND
5494: L.record_type_code = c_record_type_code AND
5495: L.offset_link_to_tax_line_id IS NULL AND
5496: NOT EXISTS (SELECT /*+ INDEX(G ZX_DETAIL_TAX_LINES_GT_U2) */ 1
5497: FROM ZX_DETAIL_TAX_LINES_GT G
5498: WHERE G.tax_line_id = L.tax_line_id);
5499:
5500: BEGIN

Line 5497: FROM ZX_DETAIL_TAX_LINES_GT G

5493: NVL(L.currency_conversion_rate, -999) = NVL(c_currency_conversion_rate, -999) AND
5494: L.record_type_code = c_record_type_code AND
5495: L.offset_link_to_tax_line_id IS NULL AND
5496: NOT EXISTS (SELECT /*+ INDEX(G ZX_DETAIL_TAX_LINES_GT_U2) */ 1
5497: FROM ZX_DETAIL_TAX_LINES_GT G
5498: WHERE G.tax_line_id = L.tax_line_id);
5499:
5500: BEGIN
5501:

Line 5797: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */

5793: -- Currently, TSRM validate provider's precision is equal or less
5794: -- than eTax, so there won't be any rounding difference to sync back.
5795: -- Once TSRM relax the validation, the sync flag may need to be set.
5796:
5797: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5798: ZX_DETAIL_TAX_LINES_GT
5799: SET Recalc_Required_Flag = 'N',
5800: minimum_accountable_unit = p_min_acct_unit_tbl(i),
5801: precision = p_precision_tbl(i),

Line 5798: ZX_DETAIL_TAX_LINES_GT

5794: -- than eTax, so there won't be any rounding difference to sync back.
5795: -- Once TSRM relax the validation, the sync flag may need to be set.
5796:
5797: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5798: ZX_DETAIL_TAX_LINES_GT
5799: SET Recalc_Required_Flag = 'N',
5800: minimum_accountable_unit = p_min_acct_unit_tbl(i),
5801: precision = p_precision_tbl(i),
5802: tax_currency_code = p_tax_currency_code_tbl(i),

Line 6091: FROM ZX_DETAIL_TAX_LINES_GT

6087: application_id,
6088: entity_code,
6089: event_class_code,
6090: trx_id
6091: FROM ZX_DETAIL_TAX_LINES_GT
6092: WHERE offset_link_to_tax_line_id IS NULL;
6093:
6094: CURSOR get_round_info_csr
6095: ( c_trx_id ZX_LINES.TRX_ID%TYPE,

Line 6188: FROM ZX_DETAIL_TAX_LINES_GT

6184: orig_tax_amt,
6185: orig_taxable_amt,
6186: orig_tax_amt_tax_curr,
6187: orig_taxable_amt_tax_curr
6188: FROM ZX_DETAIL_TAX_LINES_GT
6189: WHERE (offset_link_to_tax_line_id IS NULL
6190: OR
6191: (offset_link_to_tax_line_id IS NOT NULL AND
6192: other_doc_source IN ('APPLIED_FROM', 'ADJUSTED'))) --bug8517610