APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on HR_LOCATIONS_ALL

Line 3594: FROM hr_locations_all

3590: WHERE organization_id = cp_organization_id;
3591:
3592: CURSOR c_inv_org_linked_to_location(cp_location_id IN NUMBER) IS
3593: SELECT nvl(inventory_organization_id, -99999) inventory_organization_id
3594: FROM hr_locations_all
3595: WHERE location_id = cp_location_id;
3596:
3597: CURSOR c_loc_linked_to_org_subinv(cp_organization_id IN NUMBER, cp_subinventory IN VARCHAR2) IS
3598: SELECT location_id, decode(bonded, 'Y', 'B', decode(trading, 'Y', 'T', 'N')) loc_subinventory_type