APPS.CSI_INV_INTERORG_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3157: FROM hr_all_organization_units haou,

3153: CURSOR c_loc_ids (pc_org_id IN NUMBER,
3154: pc_subinv_name IN VARCHAR2) is
3155: SELECT haou.location_id hr_location_id,
3156: msi.location_id subinv_location_id
3157: FROM hr_all_organization_units haou,
3158: mtl_secondary_inventories msi
3159: WHERE haou.organization_id = pc_org_id
3160: AND msi.organization_id = pc_org_id
3161: AND msi.secondary_inventory_name = pc_subinv_name;