APPS.FV_BE_FUND_PKG dependencies on DUAL

Line 304: FROM dual;

300:
301: SELECT
302: DECODE(x_status_code,'SUCCESS', 0,'ADVISORY',0,'FAIL', 1, 'RFAIL',1, 'PARTIAL', 2, 'FATAL',2,'XLA_ERROR',2)
303: INTO g_retcode
304: FROM dual;
305: ELSE
306: log_message(l_module_name, 'Funds Check Errored Out');
307: g_retcode := 2;
308: END IF;

Line 343: FROM dual;

339: BEGIN
340: l_module_name:= g_module_name || 'update_doc_status';
341: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')
342: INTO l_status
343: FROM dual;
344:
345: UPDATE fv_be_trx_hdrs
346: SET doc_status = l_status,
347: internal_revision_num = DECODE(l_status, 'AR', revision_num,