DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on DUAL

Line 374: USING ( SELECT 1 FROM dual ) T

370: END IF;
371:
372: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)
373: MERGE INTO zx_rep_trx_jx_ext_t ext
374: USING ( SELECT 1 FROM dual ) T
375: ON ( ext.detail_tax_line_id = l_detail_tax_line_id_tbl(i))
376: WHEN MATCHED THEN UPDATE SET ext.ATTRIBUTE9 = l_trx_currency_desc_tbl(i),
377: ext.attribute8 = l_batch_name_tbl(i),
378: ext.attribute5 = l_match_tbl(i)

Line 2642: SELECT to_number(SubStr(l_balancing_segment,8)) INTO L_SEG_NUM FROM dual;

2638: p_mode => 'SELECT',
2639: p_qualifier => 'GL_BALANCING'
2640: );
2641:
2642: SELECT to_number(SubStr(l_balancing_segment,8)) INTO L_SEG_NUM FROM dual;
2643:
2644: IF ( g_level_statement>= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2646: 'l_balancing_segment : '||l_balancing_segment);