APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 3041: HR_ALL_ORGANIZATION_UNITS_VL HROU

3037: HROU.name,
3038: WSH.subinventory
3039: FROM CSD_REPAIR_HISTORY HIST,
3040: WSH_DELIVERY_DETAILS WSH,
3041: HR_ALL_ORGANIZATION_UNITS_VL HROU
3042: WHERE HIST.EVENT_CODE = 'PS'
3043: AND HIST.REPAIR_HISTORY_ID >= v_min
3044: AND HIST.REPAIR_HISTORY_ID <= v_max
3045: AND HIST.PARAMN1 IS NOT NULL

Line 3075: FROM hr_all_organization_units_vl HROU,

3071: -- statement to update all lines.
3072: -- We update the field with organization_name.
3073: UPDATE CSD_REPAIR_HISTORY HIST
3074: SET HIST.PARAMC3 = ( SELECT hrou.name
3075: FROM hr_all_organization_units_vl HROU,
3076: RCV_TRANSACTIONS RCV
3077: WHERE RCV.transaction_id = HIST.paramn1
3078: AND HROU.organization_id = RCV.organization_id
3079: )