APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_LINES

Line 4909: 'ZXZZTVSR: computing Non Taxable Amt from ZX_LINES ' );

4905:
4906: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
4907: IF (g_level_procedure >= g_current_runtime_level ) THEN
4908: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_non_taxable_amount',
4909: 'ZXZZTVSR: computing Non Taxable Amt from ZX_LINES ' );
4910: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_non_taxable_amount',
4911: 'trx_id : ' || p_trx_id_tbl(i) || ' trx_line_id : ' || p_trx_line_id(i) );
4912: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_non_taxable_amount',
4913: 'p_vat_tax : ' || p_vat_tax || ' p_vat_addit_tax : ' || p_vat_addit_tax || ' p_vat_percep_tax : ' || p_vat_percep_tax );

Line 4917: FROM zx_lines zxl

4913: 'p_vat_tax : ' || p_vat_tax || ' p_vat_addit_tax : ' || p_vat_addit_tax || ' p_vat_percep_tax : ' || p_vat_percep_tax );
4914: END IF;
4915: SELECT SUM(nvl(zxl.tax_amt_funcl_curr,zxl.tax_amt))
4916: INTO l_non_taxable_amt_tbl(k)
4917: FROM zx_lines zxl
4918: WHERE zxl.application_id = 222
4919: AND zxl.entity_code = 'TRANSACTIONS'
4920: AND zxl.trx_level_type = 'LINE'
4921: AND zxl.trx_id = p_trx_id_tbl(i)

Line 8211: FROM zx_lines lines,

8207: IF l_dgi_tax_regime_code_tbl(k) IS NULL THEN
8208: BEGIN
8209: SELECT val.tax_attr_value_code
8210: INTO l_dgi_tax_regime_code_tbl(k)
8211: FROM zx_lines lines,
8212: jl_zz_ar_tx_categ_all catg,
8213: jl_zz_ar_tx_att_cls_all attcls,
8214: jl_zz_ar_tx_att_val_all val
8215: WHERE catg.tax_category = P_VAT_PERCEP_TAX