DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on ZX_TRX_HEADERS_GT

Line 83: DELETE FROM ZX_TRX_HEADERS_GT;

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

Line 3772: DELETE from ZX_TRX_HEADERS_GT zx

3768: debug('arp_etax_util.validate_for_tax()+');
3769: END IF;
3770:
3771:
3772: DELETE from ZX_TRX_HEADERS_GT zx
3773: WHERE application_id = 222
3774: AND entity_code = 'TRANSACTIONS'
3775: AND (trx_id, event_class_code) IN
3776: (SELECT trx.customer_trx_id, decode(t.type, 'INV', 'INVOICE',