DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on HR_LOCATIONS_V

Line 1438: from hr_locations_v

1434: -- first check against the hr_locations table
1435: begin
1436: select inventory_organization_id
1437: into l_to_ship_to_organization_id
1438: from hr_locations_v
1439: where location_id = l_to_ship_to_location_id
1440: and ship_to_site_flag = 'Y';
1441: exception
1442: when no_data_found then

Line 1512: FROM hr_locations_v

1508: from financials_system_parameters fsp;
1509: end if;
1510: SELECT inventory_organization_id
1511: INTO l_to_ship_to_organization_id
1512: FROM hr_locations_v
1513: WHERE location_id = l_to_ship_to_location_id
1514: AND ship_to_site_flag = 'Y';
1515: exception
1516: when no_data_found then