APPS.FV_CCR_DATA_LOAD_PKG dependencies on DUAL

Line 296: from dual;

292: CLOSE c_lookup_info;
293: IF not code_exist THEN
294:
295: select decode(p_lookup(i).code,'CS','Corporate Security Code', 'Employee Security Code') into l_token
296: from dual;
297:
298: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
299: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
300: FND_MESSAGE.SET_TOKEN('CODE',l_token);

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

453: -- Bug 3872908
454: IF (p_xml_import = 'Y') THEN
455: l_xml_opt_param_set := SUBSTR(p_update_type, 2, 1);
456: l_update_type := SUBSTR(p_update_type, 1, 1);
457: SELECT sysdate into l_file_date FROM dual; -- Bug 3931555, 3936532
458: ELSE
459: l_update_type := p_update_type;
460: END IF;
461:

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

557:
558: -- Julian date validation
559: l_juliandate := substr(p_file_name,10,5);--Changed 4 to 9
560: begin
561: select to_date(l_juliandate,'YYDDD') into l_file_date from dual;
562: exception when others THEN
563: retcode :=-1;
564: l_errbuf := SQLERRM;
565: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);