APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

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

4384: 'update the adjustments to the largest lines ....');
4385: END IF;
4386:
4387: FORALL i IN 1 .. l_count
4388: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4389: ZX_DETAIL_TAX_LINES_GT
4390: SET tax_amt = l_tax_amt_tbl(i),
4391: tax_amt_tax_curr = l_tax_amt_tax_curr_tbl(i),
4392: tax_amt_funcl_curr = l_tax_amt_funcl_curr_tbl(i),

Line 4389: ZX_DETAIL_TAX_LINES_GT

4385: END IF;
4386:
4387: FORALL i IN 1 .. l_count
4388: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
4389: ZX_DETAIL_TAX_LINES_GT
4390: SET tax_amt = l_tax_amt_tbl(i),
4391: tax_amt_tax_curr = l_tax_amt_tax_curr_tbl(i),
4392: tax_amt_funcl_curr = l_tax_amt_funcl_curr_tbl(i),
4393: taxable_amt_tax_curr = l_taxable_amt_tax_curr_tbl(i),

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

5326: NVL(L.currency_conversion_type, 'X') = NVL(c_currency_conversion_type, 'X') AND
5327: NVL(L.currency_conversion_rate, -999) = NVL(c_currency_conversion_rate, -999) AND
5328: L.record_type_code = c_record_type_code AND
5329: L.offset_link_to_tax_line_id IS NULL AND
5330: NOT EXISTS (SELECT /*+ INDEX(G ZX_DETAIL_TAX_LINES_GT_U2) */ 1
5331: FROM ZX_DETAIL_TAX_LINES_GT G
5332: WHERE G.tax_line_id = L.tax_line_id);
5333:
5334: BEGIN

Line 5331: FROM ZX_DETAIL_TAX_LINES_GT G

5327: NVL(L.currency_conversion_rate, -999) = NVL(c_currency_conversion_rate, -999) AND
5328: L.record_type_code = c_record_type_code AND
5329: L.offset_link_to_tax_line_id IS NULL AND
5330: NOT EXISTS (SELECT /*+ INDEX(G ZX_DETAIL_TAX_LINES_GT_U2) */ 1
5331: FROM ZX_DETAIL_TAX_LINES_GT G
5332: WHERE G.tax_line_id = L.tax_line_id);
5333:
5334: BEGIN
5335:

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

5605: -- Currently, TSRM validate provider's precision is equal or less
5606: -- than eTax, so there won't be any rounding difference to sync back.
5607: -- Once TSRM relax the validation, the sync flag may need to be set.
5608:
5609: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5610: ZX_DETAIL_TAX_LINES_GT
5611: SET Recalc_Required_Flag = 'N',
5612: minimum_accountable_unit = p_min_acct_unit_tbl(i),
5613: precision = p_precision_tbl(i),

Line 5610: ZX_DETAIL_TAX_LINES_GT

5606: -- than eTax, so there won't be any rounding difference to sync back.
5607: -- Once TSRM relax the validation, the sync flag may need to be set.
5608:
5609: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U2) */
5610: ZX_DETAIL_TAX_LINES_GT
5611: SET Recalc_Required_Flag = 'N',
5612: minimum_accountable_unit = p_min_acct_unit_tbl(i),
5613: precision = p_precision_tbl(i),
5614: tax_currency_code = p_tax_currency_code_tbl(i),

Line 5847: FROM ZX_DETAIL_TAX_LINES_GT

5843: application_id,
5844: entity_code,
5845: event_class_code,
5846: trx_id
5847: FROM ZX_DETAIL_TAX_LINES_GT
5848: WHERE offset_link_to_tax_line_id IS NULL;
5849:
5850: CURSOR get_round_info_csr
5851: ( c_trx_id ZX_LINES.TRX_ID%TYPE,

Line 5943: FROM ZX_DETAIL_TAX_LINES_GT

5939: orig_tax_amt,
5940: orig_taxable_amt,
5941: orig_tax_amt_tax_curr,
5942: orig_taxable_amt_tax_curr
5943: FROM ZX_DETAIL_TAX_LINES_GT
5944: WHERE offset_link_to_tax_line_id IS NULL
5945: AND trx_id = c_trx_id
5946: AND application_id = c_application_id
5947: AND event_class_code = c_event_class_code