APPS.PO_LOCATIONS_SV2 dependencies on HR_LOCATIONS_ALL

Line 31: FROM hr_locations_all hl

27: -- association exist in the source Organization Operating Unit
28:
29: SELECT count(1)
30: INTO x_location_count
31: FROM hr_locations_all hl
32: WHERE hl.location_id = x_location_id
33: AND sysdate < nvl(hl.inactive_date, sysdate + 1)
34: AND nvl(hl.ship_to_site_flag, 'N') = decode(x_ship_to, 'Y', x_ship_to,
35: nvl(hl.ship_to_site_flag, 'N'))