APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on PO_VENDORS

Line 96: CURSOR curinfo(p_supplier_id po_vendors.vendor_id%TYPE) IS

92: AI.INVOICE_TYPE_LOOKUP_CODE) = 'APPROVED'
93: ;
94:
95: --Cursor to get the data of distinct invoice currency codes
96: CURSOR curinfo(p_supplier_id po_vendors.vendor_id%TYPE) IS
97: SELECT DISTINCT(invoice_currency_code) invoice_currency_code
98: FROM ap_invoices_all ai
99: WHERE ai.vendor_id=p_supplier_id
100: AND ai.invoice_currency_code=nvl(p_currency,ai.invoice_currency_code);