DBA Data[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on ZX_LINES

Line 2077: l_tax_type_code zx_lines.tax_type_code%TYPE;

2073: l_dbg_msg VARCHAR2(100);
2074: l_error_msg VARCHAR2(4000);
2075:
2076: --Added for fixing the bug 5381833
2077: l_tax_type_code zx_lines.tax_type_code%TYPE;
2078: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2079: l_no_value VARCHAR2(1):='-';
2080: --------------------------------------
2081:

Line 2189: zx_lines zl

2185: WHERE rctl.customer_trx_id=l_ar_header_id
2186: AND EXISTS (SELECT
2187: zl.trx_line_id
2188: FROM
2189: zx_lines zl
2190: WHERE zl.application_id = 222
2191: AND zl.trx_id=l_ar_header_id
2192: AND zl.trx_level_type='LINE'
2193: AND zl.entity_code='TRANSACTIONS'