APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on HZ_LOCATIONS

Line 883: --HR removes hz_locations from hr_locations; added exception

879: BEGIN
880:
881: x_progress := '001';
882: --Bug# 1942696 togeorge 08/16/2001
883: --HR removes hz_locations from hr_locations; added exception
884: Begin
885: -- validation
886: SELECT distinct 'Y'
887: INTO x_valid_flag

Line 898: FROM HZ_LOCATIONS

894: exception
895: WHEN NO_DATA_FOUND then
896: SELECT distinct 'Y'
897: INTO x_valid_flag
898: FROM HZ_LOCATIONS
899: WHERE nvl(address_expiration_date, trunc(sysdate + 1)) > trunc(sysdate)
900: AND location_id = x_deliver_to_location_id;
901:
902: return x_valid_flag;