DBA Data[Home] [Help]

APPS.CSI_INV_INTERORG_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3099: FROM hr_all_organization_units haou,

3095: CURSOR c_loc_ids (pc_org_id IN NUMBER,
3096: pc_subinv_name IN VARCHAR2) is
3097: SELECT haou.location_id hr_location_id,
3098: msi.location_id subinv_location_id
3099: FROM hr_all_organization_units haou,
3100: mtl_secondary_inventories msi
3101: WHERE haou.organization_id = pc_org_id
3102: AND msi.organization_id = pc_org_id
3103: AND msi.secondary_inventory_name = pc_subinv_name;