DBA Data[Home] [Help]

APPS.ICX_POR_JOB_TRACK_VALIDATION_S dependencies on PO_VENDOR_SITES_ALL

Line 428: from po_vendor_sites_all

424: if (l_buyer_id = -1) then
425: begin
426: select 'Y'
427: into l_foo
428: from po_vendor_sites_all
429: where vendor_id = l_supplier_id
430: and vendor_site_code = p_supplier_site
431: and rownum = 1;
432:

Line 446: from po_vendor_sites_all

442: begin
443: l_progress := '235_1';
444: select 'Y'
445: into l_foo
446: from po_vendor_sites_all
447: where vendor_id = l_supplier_id
448: and vendor_site_code = p_supplier_site
449: and org_id = l_buyer_id
450: and rownum = 1;