APPS.PO_COPYDOC_SUB dependencies on HR_LOCATIONS_ALL

Line 2068: FROM HR_LOCATIONS_ALL

2064: -- bug 1942696 hr_location changes to reflect the new view
2065: begin
2066: SELECT distinct 'Y'
2067: INTO x_valid_flag
2068: FROM HR_LOCATIONS_ALL
2069: WHERE nvl(inventory_organization_id,x_ship_to_organization_id) = x_ship_to_organization_id
2070: AND nvl(inactive_date, trunc(sysdate + 1)) > trunc(sysdate)
2071: AND location_id = x_deliver_to_location_id;
2072: