APPS.ARP_ETAX_AUTOINV_UTIL dependencies on ZX_IMPORT_TAX_LINES_GT

Line 542: INSERT INTO ZX_IMPORT_TAX_LINES_GT

538: However, it does join to ZX_TRX_HEADERS_GT which
539: would implicitly restrict the appearance of
540: INV rows in CM phase. */
541:
542: INSERT INTO ZX_IMPORT_TAX_LINES_GT
543: (
544: internal_organization_id,
545: application_id,
546: entity_code,

Line 609: FROM ZX_IMPORT_TAX_LINES_GT tax

605: UPDATE zx_transaction_lines_gt line
606: SET line_level_action = 'CREATE_WITH_TAX'
607: WHERE EXISTS
608: (SELECT 'manual tax line'
609: FROM ZX_IMPORT_TAX_LINES_GT tax
610: WHERE tax.trx_line_id = line.trx_line_id);
611: END IF;
612:
613: IF PG_DEBUG in ('Y', 'C') THEN

Line 792: /* If manual tax lines exist, populate ZX_IMPORT_TAX_LINES_GT

788: in global variables. This will not do anything on subsequent
789: calls.*/
790: detect_manual_tax(p_request_id);
791:
792: /* If manual tax lines exist, populate ZX_IMPORT_TAX_LINES_GT
793: and ZX_TRX_TAX_LINK_GT. Also set line-level action
794: on parent lines to CREATE_WITH_TAX accordingly */
795: IF (p_phase = 'INV' and g_inv_manual_tax) OR
796: (p_phase = 'CM' and g_cm_manual_tax)