APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_OPERATION_RESOURCE_SEQS

Line 1127: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors

1123: msors.DEPARTMENT_ID,
1124: msors.ACTIVITY_GROUP_ID,
1125: msors.SR_INSTANCE_ID,
1126: msors.ORGANIZATION_ID
1127: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1128: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1129: AND msors.DELETED_FLAG= MSC_UTIL.SYS_NO;
1130:
1131: CURSOR c7_d IS

Line 1137: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors

1133: msors.ROUTING_SEQUENCE_ID,
1134: msors.OPERATION_SEQUENCE_ID,
1135: msors.RESOURCE_SEQ_NUM,
1136: msors.SR_INSTANCE_ID
1137: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1138: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1139: AND msors.DELETED_FLAG= MSC_UTIL.SYS_YES;
1140:
1141:

Line 1207: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'

1203: ||' :v_current_date,'
1204: ||' :v_current_user,'
1205: ||' :v_current_date,'
1206: ||' :v_current_user '
1207: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'
1208: ||' WHERE msors.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1209: ||' AND msors.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
1210:
1211: EXECUTE IMMEDIATE lv_sql_ins