APPS.PA_CHECK_COMMITMENTS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 24: AP_INVOICE_DISTRIBUTIONS_ALL APD

20: WHERE EXISTS (
21: SELECT NVL(GLSLA.SLA_LEDGER_CASH_BASIS_FLAG,'N')
22: FROM GL_LEDGERS GLSLA,
23: PA_IMPLEMENTATIONS_ALL IMP,
24: AP_INVOICE_DISTRIBUTIONS_ALL APD
25: WHERE NVL(GLSLA.SLA_LEDGER_CASH_BASIS_FLAG,'N') = 'Y'
26: AND GLSLA.LEDGER_ID = IMP.SET_OF_BOOKS_ID
27: AND APD.PROJECT_ID = p_ProjectID
28: AND DECODE(APD.PA_ADDITION_FLAG,'Z','Y','T','Y','E','Y', null,'N', APD.PA_ADDITION_FLAG) <> 'Y'

Line 224: , AP_INVOICE_DISTRIBUTIONS_ALL D /* Changed for the bug #1530740 */

220: SELECT '1'
221: FROM
222: AP_INVOICES_ALL I /* Changed for the bug #1530740 */
223: , PO_DISTRIBUTIONS POD
224: , AP_INVOICE_DISTRIBUTIONS_ALL D /* Changed for the bug #1530740 */
225: WHERE
226: I.Invoice_ID = D.Invoice_ID
227: AND NVL(POD.Distribution_type, 'XX') <> 'PREPAYMENT'
228: AND D.PO_Distribution_ID = POD.PO_Distribution_ID(+)

Line 495: AP_INVOICE_DISTRIBUTIONS_ALL D

491: AND NOT EXISTS
492: (
493: SELECT '2'
494: FROM
495: AP_INVOICE_DISTRIBUTIONS_ALL D
496: , AP_INVOICES_ALL I
497: , PO_VENDORS V
498: , HR_ALL_ORGANIZATION_UNITS O
499: , PA_EXPEND_TYP_SYS_LINKS ES