APPS.CTO_AUTO_PROCURE_PK dependencies on HR_LOCATIONS_ALL

Line 1330: FROM hr_locations_all loc

1326:
1327: --Bugfix 7162037
1328: CURSOR delivery_location_cur (l_dest_org_id number) IS
1329: SELECT location_id
1330: FROM hr_locations_all loc
1331: WHERE inventory_organization_id = l_dest_org_id
1332: AND ship_to_site_flag = 'Y'
1333: AND EXISTS ( SELECT 1 FROM po_location_associations_all pla
1334: WHERE loc.location_id = pla.location_id

Line 1351: hr_locations_all loc

1347:
1348: /* Commented as part of bugfix 7162037
1349: select org.location_id into x_location_id
1350: from hr_all_organization_units org,
1351: hr_locations_all loc
1352: where org.organization_id = p_org_id
1353: and org.location_id = loc.location_id
1354: and exists(select 1 from po_location_associations_all pla
1355: where pla.location_id = loc.location_id); */

Line 1375: hr_locations_all loc

1371:
1372: -- For ER's validating against hr_locations is enough
1373: select org.location_id into x_location_id
1374: from hr_all_organization_units org,
1375: hr_locations_all loc
1376: where org.organization_id = p_org_id
1377: and org.location_id = loc.location_id;
1378:
1379: end if;