APPS.CTO_AUTO_PROCURE_PK dependencies on HR_LOCATIONS_ALL

Line 1138: FROM hr_locations_all loc

1134:
1135: --Bugfix 7162037
1136: CURSOR delivery_location_cur (l_dest_org_id number) IS
1137: SELECT location_id
1138: FROM hr_locations_all loc
1139: WHERE inventory_organization_id = l_dest_org_id
1140: AND ship_to_site_flag = 'Y'
1141: AND EXISTS ( SELECT 1 FROM po_location_associations_all pla
1142: WHERE loc.location_id = pla.location_id

Line 1159: hr_locations_all loc

1155:
1156: /* Commented as part of bugfix 7162037
1157: select org.location_id into x_location_id
1158: from hr_all_organization_units org,
1159: hr_locations_all loc
1160: where org.organization_id = p_org_id
1161: and org.location_id = loc.location_id
1162: and exists(select 1 from po_location_associations_all pla
1163: where pla.location_id = loc.location_id); */

Line 1183: hr_locations_all loc

1179:
1180: -- For ER's validating against hr_locations is enough
1181: select org.location_id into x_location_id
1182: from hr_all_organization_units org,
1183: hr_locations_all loc
1184: where org.organization_id = p_org_id
1185: and org.location_id = loc.location_id;
1186:
1187: end if;