APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_SUPPLIERS

Line 187: FROM AP_SUPPLIERS

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

Line 931: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;

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

Line 946: ap_suppliers asup

942: INTO l_payment_reason_code,
943: l_vendor_type_lookup_code
944: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all
945: ap_supplier_sites_all asst,
946: ap_suppliers asup
947: WHERE idpa.payment_id=p_payment_id
948: AND idpa.calling_app_doc_unique_ref2 = p_invoice_id
949: AND idpa.document_status = 'PAYMENT_CREATED'
950: AND idpa.calling_app_id=200