5117: mswth.MAX_SEPARATION,
5118: mswth.MAX_SEP_TIME_UNIT,
5119: mswth.ORGANIZATION_ID,
5120: mswth.SR_INSTANCE_ID
5121: FROM MSC_ST_WO_TASK_HIERARCHY mswth
5122: WHERE mswth.deleted_flag = MSC_UTIL.SYS_NO
5123: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5124:
5125: CURSOR c_del IS
5127: mswth.CURR_SUPPLY_ID,
5128: mswth.NEXT_SUPPLY_ID,
5129: mswth.ORGANIZATION_ID,
5130: mswth.SR_INSTANCE_ID
5131: FROM MSC_ST_WO_TASK_HIERARCHY mswth
5132: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES
5133: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
5134:
5135: BEGIN