DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on HR_LOCATIONS_ALL

Line 6034: FROM hr_locations_all loc

6030: -- SQL What: Returns 1 if the given is a valid internal ship-to
6031: -- location, 0 otherwise.
6032: SELECT count(*)
6033: INTO l_ship_to_loc_valid
6034: FROM hr_locations_all loc
6035: WHERE loc.location_id = l_new_ship_to_loc_id
6036: AND NVL(loc.business_group_id, g_business_group_id )
6037: = g_business_group_id
6038: AND loc.ship_to_site_flag = 'Y'