DBA Data[Home] [Help]

APPS.ZX_AP_EXTRACT_PKG dependencies on DUAL

Line 3237: FROM DUAL

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
3238: WHERE NOT EXISTS (SELECT 1
3239: FROM AP_HOLDS AH
3240: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
3241: OR