APPS.PO_COPYDOC_SUB dependencies on HR_LOCATIONS_ALL

Line 1923: FROM HR_LOCATIONS_ALL

1919: -- bug 1942696 hr_location changes to reflect the new view
1920: begin
1921: SELECT distinct 'Y'
1922: INTO x_valid_flag
1923: FROM HR_LOCATIONS_ALL
1924: WHERE nvl(inventory_organization_id,x_ship_to_organization_id) = x_ship_to_organization_id
1925: AND nvl(inactive_date, trunc(sysdate + 1)) > trunc(sysdate)
1926: AND location_id = x_deliver_to_location_id;
1927: