DBA Data[Home] [Help]

APPS.ZX_AP_EXTRACT_PKG dependencies on DUAL

Line 4155: FROM DUAL

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',
4154: 'NEEDS REAPPROVAL', DECODE((SELECT COUNT(*)
4155: FROM DUAL
4156: WHERE NOT EXISTS (SELECT 1
4157: FROM AP_HOLDS AH
4158: WHERE AI.INVOICE_ID = AH.INVOICE_ID)
4159: OR EXISTS (SELECT 1