DBA Data[Home] [Help]

APPS.IGI_STP_CREATE_PCK_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 170: from ap_supplier_sites_all

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
170: from ap_supplier_sites_all
171: where vendor_id = p_vendor_id
172: and pay_site_flag = 'Y'
173: and org_id = p_org_id
174: and rownum = 1;

Line 233: from ap_supplier_sites_all

229:
230: --Fwd port bug6743918
231: cursor get_ap_site is
232: select vendor_site_id
233: from ap_supplier_sites_all
234: where vendor_id = l_stp_id
235: and pay_site_flag ='Y'
236: and vendor_site_id = l_site_id
237: and org_id = p_org_id;

Line 683: --po_vendor_sites replaced with ap_supplier_sites_all and org_id added

679:
680: -- Get the contra_party_site_id
681: l_message := 'Get the contra_party_site_id';
682: l_flag := '1';
683: --po_vendor_sites replaced with ap_supplier_sites_all and org_id added
684: SELECT vendor_site_id
685: INTO l_contra_party_site_id
686: FROM ap_supplier_sites_all
687: WHERE vendor_id = p_contra_party_id

Line 686: FROM ap_supplier_sites_all

682: l_flag := '1';
683: --po_vendor_sites replaced with ap_supplier_sites_all and org_id added
684: SELECT vendor_site_id
685: INTO l_contra_party_site_id
686: FROM ap_supplier_sites_all
687: WHERE vendor_id = p_contra_party_id
688: AND org_id = p_org_id
689: AND rownum = 1;
690: l_variable := 'l_contra_party_site_id';