APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_PREPAY_APP_DISTS

Line 403: DELETE FROM AP_Prepay_App_Dists

399: (SELECT Event_ID
400: FROM XLA_Events_GT
401: WHERE Entity_Code = 'AP_PAYMENTS');
402:
403: DELETE FROM AP_Prepay_App_Dists
404: WHERE Accounting_Event_ID IN
405: (SELECT Event_ID
406: FROM XLA_Events_GT
407: WHERE Event_Type_Code IN ('PREPAYMENT APPLICATION ADJ'));

Line 569: FROM AP_Prepay_App_Dists APAD

565:
566:
567: SELECT SUM(APAD.Amount)
568: INTO l_prepay_sum
569: FROM AP_Prepay_App_Dists APAD
570: WHERE APAD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
571: AND APAD.Prepay_App_Distribution_ID = P_Prepay_App_Dist_ID
572: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
573: 'PREPAY APPL NONREC TAX', 'AWT',

Line 605: FROM AP_Prepay_App_Dists APAD

601:
602:
603: SELECT SUM(APAD.Amount)
604: INTO l_tax_diff_sum
605: FROM AP_Prepay_App_Dists APAD
606: WHERE APAD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
607: AND APAD.Prepay_App_Distribution_ID = P_Prepay_App_Dist_ID
608: AND APAD.Prepay_Dist_Lookup_Code IN ('TAX DIFF');
609:

Line 1097: FROM AP_Prepay_App_Dists APAD,

1093:
1094:
1095: SELECT SUM(APAD.Amount)
1096: INTO l_prepay_sum
1097: FROM AP_Prepay_App_Dists APAD,
1098: AP_Invoice_Distributions_All AID
1099: WHERE APAD.Invoice_Distribution_ID in ( /*bug 8882706*/
1100: select p_invoice_distribution_id from dual
1101: union

Line 1150: FROM AP_Prepay_App_Dists APAD

1146: , SUM( APAD.Base_Amt_At_Prepay_Clr_XRate )
1147: INTO P_Inv_Dist_Base_Sum
1148: , P_Paid_Base_Sum
1149: , P_Clr_Base_Curr_Sum
1150: FROM AP_Prepay_App_Dists APAD
1151: WHERE APAD.Invoice_Distribution_ID IN
1152: ( SELECT p_invoice_distribution_id FROM dual
1153: UNION
1154: SELECT DISTINCT aid_awt.invoice_distribution_id

Line 1351: /* Get the total prepaid amount from the ap_prepay_app_dists table */

1347:
1348: END IF;
1349:
1350:
1351: /* Get the total prepaid amount from the ap_prepay_app_dists table */
1352: /* bug9322001, changed the where clause to remove conditions on accounting */
1353: /* events, and checked only for reversal flag on the Prepay Application dists */
1354: SELECT SUM(APAD.Amount)
1355: INTO l_prepaid_acctd_amt

Line 1356: FROM AP_Prepay_App_Dists APAD,

1352: /* bug9322001, changed the where clause to remove conditions on accounting */
1353: /* events, and checked only for reversal flag on the Prepay Application dists */
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

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