APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on HZ_LOCATIONS

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

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

Line 902: FROM HZ_LOCATIONS

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