APPS.FV_CCR_DATA_LOAD_PKG dependencies on DUAL

Line 288: from dual;

284: CLOSE c_lookup_info;
285: IF not code_exist THEN
286:
287: select decode(p_lookup(i).code,'CS','Corporate Security Code', 'Employee Security Code') into l_token
288: from dual;
289:
290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);

Line 442: SELECT sysdate into l_file_date FROM dual; -- Bug 3931555, 3936532

438: -- Bug 3872908
439: IF (p_xml_import = 'Y') THEN
440: l_xml_opt_param_set := SUBSTR(p_update_type, 2, 1);
441: l_update_type := SUBSTR(p_update_type, 1, 1);
442: SELECT sysdate into l_file_date FROM dual; -- Bug 3931555, 3936532
443: ELSE
444: l_update_type := p_update_type;
445: END IF;
446:

Line 546: select to_date(l_juliandate,'YYDDD') into l_file_date from dual;

542:
543: -- Julian date validation
544: l_juliandate := substr(p_file_name,4,5);
545: begin
546: select to_date(l_juliandate,'YYDDD') into l_file_date from dual;
547: exception when others THEN
548: retcode :=-1;
549: l_errbuf := SQLERRM;
550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);