APPS.PO_LOCATIONS_SV2 dependencies on HZ_LOCATIONS

Line 75: FROM hz_locations hz

71: -- bug 1942696 hr_location changes to reflect the new view
72: if (x_location_count = 0) then
73: SELECT count(1)
74: INTO x_location_count
75: FROM hz_locations hz
76: WHERE hz.location_id = x_location_id
77: AND sysdate < nvl(hz.address_expiration_date, sysdate + 1);
78: end if;
79: