APPS.AR_GTA_REPORTS_PKG dependencies on ZX_LINES

Line 2180: l_tax_type_code zx_lines.tax_type_code%TYPE;

2176: l_dbg_msg VARCHAR2(100);
2177: l_error_msg VARCHAR2(4000);
2178:
2179: --Added for fixing the bug 5381833
2180: l_tax_type_code zx_lines.tax_type_code%TYPE;
2181: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2182: l_no_value VARCHAR2(1):='-';
2183: --------------------------------------
2184: l_order_number ra_customer_trx_lines_all.interface_line_attribute1%TYPE;

Line 2310: zx_lines zl

2306: AND opa.list_line_type_code='DIS')
2307: AND EXISTS (SELECT
2308: zl.trx_line_id
2309: FROM
2310: zx_lines zl
2311: WHERE zl.application_id = 222
2312: AND zl.trx_id=l_ar_header_id
2313: AND zl.trx_level_type='LINE'
2314: AND zl.entity_code='TRANSACTIONS'

Line 2541: FROM zx_lines tax

2537: -- fnd_file.PUT_LINE(fnd_file.LOG,'l_discount_amount IN CURSOR:'||l_discount_amount);
2538: --Calculate the discount tax amount
2539: SELECT tax.tax_amt_tax_curr + nvl(l_discount_tax_amount, 0)
2540: INTO l_discount_tax_amount
2541: FROM zx_lines tax
2542: WHERE tax.trx_line_id = l_discount_cust_trx_line_id
2543: AND tax.entity_code = 'TRANSACTIONS'
2544: AND application_id = 222
2545: AND tax.trx_level_type = 'LINE'