APPS.CSI_INV_TRANSFER_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 126: FROM hr_all_organization_units haou,

122: CURSOR c_loc_ids (pc_org_id IN NUMBER,
123: pc_subinv_name IN VARCHAR2) is
124: SELECT haou.location_id hr_location_id,
125: msi.location_id subinv_location_id
126: FROM hr_all_organization_units haou,
127: mtl_secondary_inventories msi
128: WHERE haou.organization_id = pc_org_id
129: AND msi.organization_id = pc_org_id
130: AND msi.secondary_inventory_name = pc_subinv_name;