APPS.FV_BE_FUND_PKG dependencies on DUAL

Line 299: FROM dual;

295:
296: SELECT
297: DECODE(x_status_code,'SUCCESS', 0,'ADVISORY',0,'FAIL', 1, 'RFAIL',1, 'PARTIAL', 2, 'FATAL',2,'XLA_ERROR',2)
298: INTO g_retcode
299: FROM dual;
300: ELSE
301: log_message(l_module_name, 'Funds Check Errored Out');
302: g_retcode := 2;
303: END IF;

Line 338: FROM dual;

334: BEGIN
335: l_module_name:= g_module_name || 'update_doc_status';
336: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')
337: INTO l_status
338: FROM dual;
339:
340: UPDATE fv_be_trx_hdrs
341: SET doc_status = l_status,
342: internal_revision_num = DECODE(l_status, 'AR', revision_num,