APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on HR_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 892: FROM HR_LOCATIONS

888: Begin
889: -- validation
890: SELECT distinct 'Y'
891: INTO x_valid_flag
892: FROM HR_LOCATIONS
893: WHERE nvl(inventory_organization_id,x_ship_to_organization_id) = x_ship_to_organization_id
894: AND nvl(inactive_date, trunc(sysdate + 1)) > trunc(sysdate)
895: AND location_id = x_deliver_to_location_id;
896: