APPS.AP_INVOICES_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 3484: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D,

3480: OR (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,'N') = 'N'
3481: AND NVL(D.MATCH_STATUS_FLAG,'N') NOT IN ('A','T')))
3482: UNION ALL
3483: SELECT 1
3484: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D,
3485: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3486: WHERE D.INVOICE_ID = AI.INVOICE_ID
3487: AND FSP.ORG_ID = AI.ORG_ID
3488: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID

Line 3495: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D2

3491: OR (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,'N') = 'N'
3492: AND NVL(D.MATCH_STATUS_FLAG,'N') NOT IN ('A','T')))
3493: AND NOT EXISTS
3494: (SELECT 'Cancelled distributions'
3495: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D2
3496: WHERE D2.INVOICE_ID = D.INVOICE_ID
3497: AND D2.CANCELLATION_FLAG = 'Y'
3498: )
3499: );