DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 90: AND AP_INVOICES_UTILITY_PKG.get_approval_status(AI.INVOICE_ID,

86: AND trunc(ai.invoice_date) <= trunc(p_as_of_date)
87: AND ai.vendor_id = p_vendor_id
88: AND ai.vendor_site_id = p_vendor_site_id
89: AND ai.invoice_currency_code = nvl(p_currency,ai.invoice_currency_code)
90: AND AP_INVOICES_UTILITY_PKG.get_approval_status(AI.INVOICE_ID,
91: AI.INVOICE_AMOUNT, AI.PAYMENT_STATUS_FLAG,
92: AI.INVOICE_TYPE_LOOKUP_CODE) = 'APPROVED'
93: ;
94: