APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on HR_LOCATIONS_ALL

Line 3127: FROM hr_locations_all

3123: WHERE organization_id = cp_organization_id;
3124:
3125: CURSOR c_inv_org_linked_to_location(cp_location_id IN NUMBER) IS
3126: SELECT nvl(inventory_organization_id, -99999) inventory_organization_id
3127: FROM hr_locations_all
3128: WHERE location_id = cp_location_id;
3129:
3130: CURSOR c_loc_linked_to_org_subinv(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS
3131: SELECT location_id, decode(bonded, 'Y', 'B', decode(trading, 'Y', 'T', 'N')) loc_subinventory_type