APPS.CCT_CLASS_ENGINE_UPG dependencies on DUAL

Line 41: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1 from dual;

37: insert into cct_classification_values (classification_value_id, classification_value,
38: seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
39: select cct_classification_values_s.nextval, 'unClassified', 'Y',
40: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,
41: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1 from dual;
42:
43: --dbms_output.put_line('Classification Values is Upgraded');
44: insert into cct_plsql_functions (function_id, function, function_name, package,appdb,
45: dburl, dbdriver, return_type,seeded,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,

Line 199: select cct_classification_values_s.nextval into l_class_value_id from dual;

195: SELECT classification, classification_id FROM cct_classifications
196: where (upper(type)= 'LITERAL') AND classification_value_id is null
197: AND nvl(f_deletedflag,'N')='D' AND upper(classification) <> 'UNCLASSIFIED')
198: LOOP
199: select cct_classification_values_s.nextval into l_class_value_id from dual;
200: insert into cct_classification_values (classification_value_id, classification_value,seeded,
201: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,f_deletedflag)
202: select l_class_value_id, l_record.classification,'N',
203: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1, TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,'D'

Line 204: from dual;

200: insert into cct_classification_values (classification_value_id, classification_value,seeded,
201: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,f_deletedflag)
202: select l_class_value_id, l_record.classification,'N',
203: TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1, TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1,'D'
204: from dual;
205:
206: update cct_classifications a set a.classification_value_id = l_class_value_id
207: where a.classification_id = l_record.classification_id;
208: