DBA Data[Home] [Help]

APPS.CSI_INV_ISO_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4158: FROM hr_all_organization_units haou,

4154: CURSOR c_loc_ids (pc_org_id IN NUMBER,
4155: pc_subinv_name IN VARCHAR2) is
4156: SELECT haou.location_id hr_location_id,
4157: msi.location_id subinv_location_id
4158: FROM hr_all_organization_units haou,
4159: mtl_secondary_inventories msi
4160: WHERE haou.organization_id = pc_org_id
4161: AND msi.organization_id = pc_org_id
4162: AND msi.secondary_inventory_name = pc_subinv_name;