APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 1333: AND EXISTS ( SELECT 1 FROM po_location_associations_all pla

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
1335: );
1336:
1337: Begin

Line 1354: and exists(select 1 from po_location_associations_all pla

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); */
1356:
1357: open delivery_location_cur (p_org_id);
1358: FETCH delivery_location_cur INTO x_location_id;