DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on HR_LOCATIONS

Line 539: FROM hr_locations hl,

535: END IF;
536:
537: SELECT org.organization_id
538: INTO x_org_id
539: FROM hr_locations hl,
540: mtl_parameters org
541: WHERE hl.location_id = p_location_id
542: AND hl.inventory_organization_id = org.organization_id;
543:

Line 570: FROM hr_locations_all

566: END IF;
567:
568: SELECT location_id
569: INTO x_location_id
570: FROM hr_locations_all
571: WHERE location_code = p_location_code
572: AND ( business_group_id = NVL(hr_general.get_business_group_id, business_group_id)
573: OR business_group_id IS NULL);
574: