APPS.GMD_QC_MIG12 dependencies on PO_VENDOR_SITES_ALL

Line 3093: FROM po_vendor_sites_all

3089: -- Added code to update Operating Unit Information for Supplier Samples
3090: l_org_id := NULL;
3091: IF v_samp_rec.supplier_site_id IS NOT NULL AND v_samp_rec.source = 'S' THEN
3092: SELECT org_id INTO l_org_id
3093: FROM po_vendor_sites_all
3094: WHERE vendor_site_id = v_samp_rec.supplier_site_id;
3095: ELSE
3096: l_org_id := v_samp_rec.org_id;
3097: END IF;

Line 6235: FROM po_vendor_sites_all

6231: l_supl_org_id := NULL;
6232: IF l_supl_spec.supplier_site_id IS NOT NULL THEN
6233: BEGIN
6234: SELECT org_id INTO l_supl_org_id
6235: FROM po_vendor_sites_all
6236: WHERE vendor_site_id = l_supl_spec.supplier_site_id;
6237: EXCEPTION
6238: WHEN OTHERS THEN
6239: l_supl_org_id := NULL;