APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_SUPPLIERS

Line 185: FROM AP_SUPPLIERS

181: -- Get Vendor Type
182: CURSOR vendor_type_csr(p_vendor_id NUMBER)
183: IS
184: SELECT nvl(vendor_type_lookup_code, 'XXX') -- Bug 6398944
185: FROM AP_SUPPLIERS
186: WHERE vendor_id = p_vendor_id;
187:
188:
189: l_invoice_id NUMBER(15,0);

Line 927: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;

923: )IS
924:
925: l_message VARCHAR2(1000);
926: l_payment_reason_code iby_docs_payable_all.payment_reason_code%TYPE;
927: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;
928: l_module_name VARCHAR2(200) := g_module_name || 'PAY_TAX_BENEFIT';
929:
930: BEGIN
931: x_error_code := g_SUCCESS;

Line 942: ap_suppliers asup

938: INTO l_payment_reason_code,
939: l_vendor_type_lookup_code
940: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all
941: ap_invoices_all aia,
942: ap_suppliers asup
943: WHERE idpa.payment_id=p_payment_id
944: AND idpa.calling_app_doc_unique_ref2 = p_invoice_id
945: AND aia.invoice_id = p_invoice_id
946: AND asup.vendor_id = aia.vendor_id;