APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 1358: AP_PREPAY_HISTORY_ALL APPH

1354: SELECT SUM(APAD.Amount)
1355: INTO l_prepaid_acctd_amt
1356: FROM AP_Prepay_App_Dists APAD,
1357: AP_Invoice_Distributions_All AID,
1358: AP_PREPAY_HISTORY_ALL APPH
1359: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1360: AND AID.Invoice_Distribution_ID = APAD.Invoice_Distribution_ID
1361: AND APAD.prepay_history_id = APPH.PREPAY_HISTORY_ID
1362: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',

Line 1625: -- this API is unable to create the ap_prepay_history_all/ap_prepay_app_dists

1621: -- which are encumbered.
1622: --
1623: -- In case an 11i historical prepayment application or unapplication
1624: -- encumbered but unaccounted invoice distribution is upgraded to R12,
1625: -- this API is unable to create the ap_prepay_history_all/ap_prepay_app_dists
1626: -- data for those prepayment application and unapplication distributions.
1627: --
1628: -- Logic will be added to momentarily set the encumbered flag to 'N',
1629: -- before calling prepay_dist_appl, after that the encumbered flag would

Line 1860: FROM ap_prepay_history_all apph

1856: AND p_xla_event_rec.event_id IS NOT NULL -- added for bug13334090
1857: UNION
1858: -- prepay application adjustment
1859: SELECT 'unreversed, unaccounted prepay adjustment not selected for accounting'
1860: FROM ap_prepay_history_all apph
1861: WHERE apph.posted_flag = 'N'
1862: AND apph.invoice_id = p_inv_rec.invoice_id
1863: AND apph.invoice_adjustment_event_id IS NOT NULL
1864: AND NOT EXISTS(

Line 1918: FROM ap_prepay_history_all apph,

1914: AND aph_rev.rev_pmt_hist_id IS NOT NULL)
1915: UNION
1916: -- prepay adjustment
1917: SELECT MAX(apph.accounting_event_id) accounting_event_id
1918: FROM ap_prepay_history_all apph,
1919: xla_events_gt xgt
1920: WHERE xgt.event_id = apph.accounting_event_id
1921: AND apph.posted_flag = 'S'
1922: AND apph.invoice_id = p_inv_rec.invoice_id