APPS.CSI_INV_ISO_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4180: FROM hr_all_organization_units haou,

4176: CURSOR c_loc_ids (pc_org_id IN NUMBER,
4177: pc_subinv_name IN VARCHAR2) is
4178: SELECT haou.location_id hr_location_id,
4179: msi.location_id subinv_location_id
4180: FROM hr_all_organization_units haou,
4181: mtl_secondary_inventories msi
4182: WHERE haou.organization_id = pc_org_id
4183: AND msi.organization_id = pc_org_id
4184: AND msi.secondary_inventory_name = pc_subinv_name;