APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1328: AP_INVOICE_PAYMENTS_ALL AIP

1324: INTO l_paid_acctd_amt
1325: FROM AP_Payment_Hist_Dists APHD,
1326: AP_Invoice_Distributions_All AID,
1327: AP_Payment_History_All APH,
1328: AP_INVOICE_PAYMENTS_ALL AIP
1329: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1330: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
1331: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT') --bug 9265516, removed 'AWT'
1332: AND APH.Posted_Flag IN ('Y', 'S') --bug 7614480, added status 'S'

Line 1818: , ap_invoice_payments_all aip

1814: FROM DUAL
1815: WHERE EXISTS(
1816: SELECT 'unreversed, unaccounted payment not selected for accounting'
1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip
1819: , xla_event_types_b xet
1820: , xla_event_types_b xet_rel
1821: , xla_events xe
1822: WHERE aip.invoice_id = p_inv_rec.invoice_id

Line 1892: , ap_invoice_payments_all aip

1888: (
1889: -- payment
1890: SELECT MAX(aph.accounting_event_id) accounting_event_id
1891: FROM ap_payment_history_all aph
1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt

Line 2037: from ap_invoice_payments_all aip

2033: ap_system_parameters_all asp,
2034: xla_ae_headers xah
2035: where aph.check_id in
2036: (select aip.check_id
2037: from ap_invoice_payments_all aip
2038: where aip.invoice_id = p_inv_rec.invoice_id
2039: and nvl(aip.reversal_flag, 'N') <> 'Y'
2040: )
2041: and aph.transaction_type IN ('PAYMENT CLEARING',

Line 2069: from ap_invoice_payments_all aip

2065: ap_system_parameters_all asp,
2066: xla_ae_headers xah
2067: where aph.check_id in
2068: (select aip.check_id
2069: from ap_invoice_payments_all aip
2070: where aip.invoice_id = p_inv_rec.invoice_id
2071: and nvl(aip.reversal_flag, 'N') <> 'Y'
2072: )
2073: and aph.transaction_type IN ('PAYMENT MATURITY',

Line 2101: from ap_invoice_payments_all aip

2097: ap_system_parameters_all asp,
2098: xla_ae_headers xah
2099: where aph.check_id in
2100: (select aip.check_id
2101: from ap_invoice_payments_all aip
2102: where aip.invoice_id = p_inv_rec.invoice_id
2103: and nvl(aip.reversal_flag, 'N') <> 'Y'
2104: )
2105: and aph.transaction_type IN ('PAYMENT CREATED', 'PAYMENT CANCELLED', 'PAYMENT ADJUSTED',

Line 2167: from ap_invoice_payments_all aip

2163: ap_system_parameters_all asp,
2164: xla_ae_headers xah
2165: where aph.check_id in
2166: (select aip.check_id
2167: from ap_invoice_payments_all aip
2168: where aip.invoice_id = p_invoice_payment_id
2169: )
2170: and aph.org_id = asp.org_id
2171: and aph.accounting_event_id = xah.event_id