DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on ZX_DETAIL_TAX_LINES_GT

Line 87: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

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

Line 2250: FROM zx_detail_tax_lines_gt

2246: CURSOR est_tax_lines(p_entity VARCHAR2, p_event_class VARCHAR2,
2247: p_trx_id NUMBER, p_trx_line_id NUMBER,
2248: p_mode VARCHAR2) IS
2249: SELECT adjusted_doc_line_id, SUM(tax_amt) tax_amt, MAX(line_amt) line_amt
2250: FROM zx_detail_tax_lines_gt
2251: WHERE application_id = 222
2252: AND entity_code = p_entity
2253: AND event_class_code = p_event_class
2254: AND trx_id = p_trx_id