APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_ROUTE_PARAMS

Line 107: from cct_route_params a, cct_classifications b

103: sequence,value,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,
105: a.datatype,a.direction, a.sequence,a.value, TO_DATE ('01/01/1951', 'DD/MM/YYYY'),
106: 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1
107: from cct_route_params a, cct_classifications b
108: where a.classification_id=b.classification_id AND upper(b.type)='DBPROC'
109: AND nvl(a.f_deletedflag,'N')<>'D' AND nvl(b.f_deletedflag,'N')<>'D';
110:
111: --dbms_output.put_line('Populated pl/sql function params..');

Line 245: select route_param_id, operation from cct_route_params

241: END LOOP;
242: --dbms_output.put_line('At End of 1st For Loop');
243:
244: FOR l_record IN (
245: select route_param_id, operation from cct_route_params
246: WHERE value IS NOT NULL AND direction is null and sequence is null
247: AND param in ('AccountCode','AccountNum','occtRoutePoint', 'ContractNum')
248: AND operation in ('=','>','>=','<','<=','!=','DOESNOTEXISTSIN','BETWEEN')
249: AND nvl(f_deletedflag,'N')<>'D'

Line 260: update cct_route_params set operation=StringOperation

256: ELSIF UPPER(l_record.operation)='DOESNOTEXISTSIN' THEN
257: StringOperation:='DONOTEXISTIN';
258: END IF;
259:
260: update cct_route_params set operation=StringOperation
261: where route_param_id = l_record.route_param_id;
262:
263: END LOOP;
264: