APPS.ZX_AP_EXTRACT_PKG dependencies on AP_INVOICES_ALL

Line 4149: FROM AP_INVOICES_ALL AI

4145: WHERE REQUEST_ID = g_request_id
4146: AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
4147: AND EXISTS
4148: (SELECT /*+ no_unnest */ 1
4149: FROM AP_INVOICES_ALL AI
4150: WHERE AI.INVOICE_ID = DTL.TRX_ID
4151: AND DECODE(AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE),
4152: 'NEVER APPROVED','Y',
4153: 'UNAPPROVED','Y',