APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on HR_LOCATIONS_ALL

Line 220: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;

216: IS
217:
218: l_progress VARCHAR2(3) := '000';
219: l_api_name VARCHAR2(30) := 'setup_interface_data';
220: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
221: l_count_dist NUMBER;
222: -- Added for Linking requisition to Modification project
223: l_clin_num_display po_lines_interface.line_num_display%TYPE;
224: l_slin_num_display po_lines_interface.line_num_display%TYPE;

Line 1018: FROM hr_locations_all hrl

1014:
1015: BEGIN
1016: SELECT hrl.inventory_organization_id
1017: INTO l_ship_to_org_id
1018: FROM hr_locations_all hrl
1019: WHERE hrl.location_id = i.ship_to_location_id
1020: AND hrl.ship_to_site_flag = 'Y';
1021: EXCEPTION
1022: WHEN no_data_found THEN