DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on DUAL

Line 267: USING ( SELECT 1 FROM dual ) T

263: END IF;
264:
265: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)
266: MERGE INTO zx_rep_trx_jx_ext_t ext
267: USING ( SELECT 1 FROM dual ) T
268: ON ( ext.detail_tax_line_id = l_detail_tax_line_id_tbl(i))
269: WHEN MATCHED THEN UPDATE SET ext.ATTRIBUTE9 = l_trx_currency_desc_tbl(i),
270: ext.attribute8 = l_batch_name_tbl(i),
271: ext.attribute5 = l_match_tbl(i)

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

1319: p_mode => 'SELECT',
1320: p_qualifier => 'GL_BALANCING'
1321: );
1322:
1323: SELECT to_number(SubStr(l_balancing_segment,8)) INTO L_SEG_NUM FROM dual;
1324:
1325: IF ( g_level_statement>= g_current_runtime_level ) THEN
1326: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1327: 'l_balancing_segment : '||l_balancing_segment);