APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on CSD_FLOW_STATUSES_B

Line 186: insert into CSD_FLOW_STATUSES_B (

182:
183: FOR i IN FlowStatusCodes.FIRST..FlowStatusCodes.LAST LOOP
184:
185: BEGIN
186: insert into CSD_FLOW_STATUSES_B (
187: FLOW_STATUS_ID,
188: FLOW_STATUS_CODE,
189: STATUS_CODE,
190: SEEDED_FLAG,

Line 239: CSD_FLOW_STATUSES_B FS_B

235: FND_GLOBAL.login_id,
236: L.LANGUAGE_CODE,
237: L.LANGUAGE_CODE
238: from FND_LANGUAGES L,
239: CSD_FLOW_STATUSES_B FS_B
240: where L.INSTALLED_FLAG in ('I', 'B')
241: AND FS_B.flow_status_code in ('C','H','O','D')
242: and not exists
243: (select 'x'

Line 283: CSD_FLOW_STATUSES_B FS_B1,

279: SYSDATE,
280: FND_GLOBAL.user_id,
281: FND_GLOBAL.login_id
282: FROM CSD_REPAIR_TYPES_B RT,
283: CSD_FLOW_STATUSES_B FS_B1,
284: CSD_FLOW_STATUSES_B FS_B2
285: WHERE FS_B1.flow_status_code IN ('C','H','O')
286: AND FS_B2.flow_status_code IN ('C','H','O')
287: AND FS_B2.flow_status_code <> FS_B1.flow_status_code

Line 284: CSD_FLOW_STATUSES_B FS_B2

280: FND_GLOBAL.user_id,
281: FND_GLOBAL.login_id
282: FROM CSD_REPAIR_TYPES_B RT,
283: CSD_FLOW_STATUSES_B FS_B1,
284: CSD_FLOW_STATUSES_B FS_B2
285: WHERE FS_B1.flow_status_code IN ('C','H','O')
286: AND FS_B2.flow_status_code IN ('C','H','O')
287: AND FS_B2.flow_status_code <> FS_B1.flow_status_code
288: AND NOT EXISTS

Line 332: FROM CSD_FLOW_STATUSES_B

328:
329: FOR i IN FlowStatusCodes.FIRST..FlowStatusCodes.LAST LOOP
330: SELECT flow_status_id
331: INTO FlowStatusIDs(i)
332: FROM CSD_FLOW_STATUSES_B
333: WHERE flow_status_code = FlowStatusCodes(i);
334: END LOOP;
335:
336: -- STEP 4: Update all repair types that do not have a value.