APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on CSD_REPAIR_TYPES_B

Line 282: FROM CSD_REPAIR_TYPES_B RT,

278: FND_GLOBAL.user_id,
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')

Line 338: UPDATE CSD_REPAIR_TYPES_B

334: END LOOP;
335:
336: -- STEP 4: Update all repair types that do not have a value.
337:
338: UPDATE CSD_REPAIR_TYPES_B
339: SET start_flow_Status_id = FlowStatusIDs(c_open_index),
340: last_update_date = SYSDATE,
341: last_updated_by = FND_GLOBAL.user_id,
342: last_update_login = FND_GLOBAL.login_id