DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on ZX_TRX_HEADERS_GT

Line 82: DELETE FROM ZX_TRX_HEADERS_GT;

78: NOTE: The truncate command for GT tables only truncates
79: data for this session, not other unrelated sessions (per
80: SQL documentation) */
81:
82: DELETE FROM ZX_TRX_HEADERS_GT;
83: DELETE FROM ZX_TRANSACTION_LINES_GT;
84: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
85: DELETE FROM ZX_TRX_TAX_LINK_GT;
86: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

Line 3710: DELETE from ZX_TRX_HEADERS_GT zx

3706: arp_debug.debug('arp_etax_util.validate_for_tax()+');
3707: END IF;
3708:
3709:
3710: DELETE from ZX_TRX_HEADERS_GT zx
3711: WHERE application_id = 222
3712: AND entity_code = 'TRANSACTIONS'
3713: AND (trx_id, event_class_code) IN
3714: (SELECT trx.customer_trx_id, decode(t.type, 'INV', 'INVOICE',