APPS.IGI_STP_CREATE_PCK_PKG dependencies on IGI_PO_VENDORS

Line 165: select vendor_id from igi_po_vendors

161: and cand.org_id = p_org_id
162: and cand.org_id = net.org_id;
163:
164: CURSOR get_vendor (p_customer_id in number) is
165: select vendor_id from igi_po_vendors
166: where customer_id = p_customer_id;
167:
168: CURSOR get_vendor_sites(p_vendor_id in number) is
169: select vendor_site_id , accts_pay_code_combination_id

Line 177: select customer_id from igi_po_vendors

173: and org_id = p_org_id
174: and rownum = 1;
175:
176: CURSOR get_customer (p_vendor_id in number) is
177: select customer_id from igi_po_vendors
178: where vendor_id = p_vendor_id;
179:
180: CURSOR get_customer_sites(p_customer_id in number ) is
181: select CSU.site_use_id, gl_id_rec