172: x_valid number := 0;
173: begin
174: begin
175: --
176: --Modified the query to select from po_vendor_sites_all
177: --instead of po_vendor_sites.
178: select 1
179: into x_valid
180: from po_vendor_sites_all pvs
176: --Modified the query to select from po_vendor_sites_all
177: --instead of po_vendor_sites.
178: select 1
179: into x_valid
180: from po_vendor_sites_all pvs
181: where pvs.VENDOR_ID = x_vendor_id
182: and pvs.vendor_site_id = x_vendor_site_id
183: and pvs.pcard_site_flag = 'Y';
184: