DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on HR_LOCATIONS_V

Line 1309: from hr_locations_v

1305: -- first check against the hr_locations table
1306: begin
1307: select inventory_organization_id
1308: into l_to_ship_to_organization_id
1309: from hr_locations_v
1310: where location_id = l_to_ship_to_location_id
1311: and ship_to_site_flag = 'Y';
1312: exception
1313: when no_data_found then

Line 1383: FROM hr_locations_v

1379: from financials_system_parameters fsp;
1380: end if;
1381: SELECT inventory_organization_id
1382: INTO l_to_ship_to_organization_id
1383: FROM hr_locations_v
1384: WHERE location_id = l_to_ship_to_location_id
1385: AND ship_to_site_flag = 'Y';
1386: exception
1387: when no_data_found then