DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on ZX_DETAIL_TAX_LINES_GT

Line 86: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

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;
87:
88: IF PG_DEBUG in ('Y', 'C') THEN
89: arp_standard.debug('arp_etax_util.clear_ebt_gt()-');
90: END IF;

Line 2180: FROM zx_detail_tax_lines_gt

2176: CURSOR est_tax_lines(p_entity VARCHAR2, p_event_class VARCHAR2,
2177: p_trx_id NUMBER, p_trx_line_id NUMBER,
2178: p_mode VARCHAR2) IS
2179: SELECT adjusted_doc_line_id, SUM(tax_amt) tax_amt, MAX(line_amt) line_amt
2180: FROM zx_detail_tax_lines_gt
2181: WHERE application_id = 222
2182: AND entity_code = p_entity
2183: AND event_class_code = p_event_class
2184: AND trx_id = p_trx_id