APPS.ZX_AP_EXTRACT_PKG dependencies on AP_INVOICES_ALL

Line 3231: FROM AP_INVOICES_ALL AI

3227: WHERE REQUEST_ID = g_request_id
3228: AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
3229: AND EXISTS
3230: (SELECT 1
3231: FROM AP_INVOICES_ALL AI
3232: WHERE AI.INVOICE_ID = DTL.TRX_ID
3233: AND DECODE(AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE),
3234: 'NEVER APPROVED','Y',
3235: 'UNAPPROVED','Y',