APPS.CTO_AUTO_PROCURE_PK dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 1141: AND EXISTS ( SELECT 1 FROM po_location_associations_all pla

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
1143: );
1144:
1145: Begin

Line 1162: and exists(select 1 from po_location_associations_all pla

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); */
1164:
1165: open delivery_location_cur (p_org_id);
1166: FETCH delivery_location_cur INTO x_location_id;