APPS.WSH_PICK_LIST dependencies on HR_ORGANIZATION_UNITS

Line 3563: FROM hr_organization_units hr,

3559: AND v_order_hdr_id = 0
3560: AND v_del_detail_id in (0,-1)
3561: AND (v_from_loc_id = -1
3562: OR WND.ORGANIZATION_ID IN (SELECT organization_id
3563: FROM hr_organization_units hr,
3564: wsh_locations wl
3565: WHERE wl.wsh_location_id = v_from_loc_id
3566: AND wl.location_source_code = 'HR'
3567: AND wl.source_location_id =