APPS.PO_LOCATIONS_SV2 dependencies on HZ_LOCATIONS
Line 56: FROM hz_locations hz
52: -- bug 1942696 hr_location changes to reflect the new view
53: if (x_location_count = 0) then
54: SELECT count(1)
55: INTO x_location_count 56: FROM hz_locations hz 57: WHERE hz.location_id = x_location_id
58: AND sysdate < nvl(hz.address_expiration_date, sysdate + 1);
59: end if;
60: