DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on HR_LOCATIONS_ALL

Line 6084: FROM hr_locations_all loc

6080: -- SQL What: Returns 1 if the given is a valid internal ship-to
6081: -- location, 0 otherwise.
6082: SELECT count(*)
6083: INTO l_ship_to_loc_valid
6084: FROM hr_locations_all loc
6085: WHERE loc.location_id = l_new_ship_to_loc_id
6086: AND NVL(loc.business_group_id, g_business_group_id )
6087: = g_business_group_id
6088: AND loc.ship_to_site_flag = 'Y'