DBA Data[Home] [Help]

APPS.ZX_AP_EXTRACT_PKG dependencies on AP_INVOICES_PKG

Line 3233: AND DECODE(AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE),

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',
3236: 'NEEDS REAPPROVAL',DECODE((SELECT COUNT(*)
3237: FROM DUAL