APPS.PO_COPY_DOCUMENTS_S dependencies on HR_LOCATIONS

Line 530: x_ship_to_loc_org_id hr_locations.inventory_organization_id%type;

526: /* Additional tax variables for R11 tax defaulting functionality */
527: x_tax_id ap_tax_codes.tax_id%type;
528: x_allow_tax_code_override_flag gl_tax_option_accounts.allow_tax_code_override_flag%type;
529: x_ship_to_location_id po_headers.ship_to_location_id%type;
530: x_ship_to_loc_org_id hr_locations.inventory_organization_id%type;
531: x_item_id mtl_system_items.inventory_item_id%type;
532: x_new_tax_flag varchar2(1):=null;
533:
534: -- Bug#5401155

Line 610: FROM hr_locations hrl

606:
607: BEGIN
608: SELECT hrl.inventory_organization_id
609: INTO x_ship_to_loc_org_id
610: FROM hr_locations hrl
611: WHERE hrl.location_id = x_ship_to_location_id;
612: EXCEPTION
613: WHEN NO_DATA_FOUND THEN
614: x_ship_to_loc_org_id := NULL;