eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 287: DELETE FROM AP_Payment_Hist_Dists

283: END IF;
284:
285:
286: -- Bug 5098657. Added the where condition for both the delete statements
287: DELETE FROM AP_Payment_Hist_Dists
288: WHERE Accounting_Event_ID IN
289: (SELECT Event_ID
290: FROM XLA_Events_GT
291: WHERE Entity_Code = 'AP_PAYMENTS');

Line 340: FROM AP_Payment_Hist_Dists APHD,

336:
337:
338: SELECT SUM(APHD.Amount)
339: INTO l_pay_sum
340: FROM AP_Payment_Hist_Dists APHD,
341: AP_Payment_History_All APH
342: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
343: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
344: AND APH.Related_Event_ID = P_Related_Event_ID

Line 380: FROM AP_Payment_Hist_Dists APHD,

376:
377:
378: SELECT SUM(APHD.Invoice_Dist_Amount)
379: INTO l_inv_dist_sum
380: FROM AP_Payment_Hist_Dists APHD,
381: AP_Payment_History_All APH
382: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
383: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
384: AND APH.Related_Event_ID = P_Related_Event_ID

Line 420: FROM AP_Payment_Hist_Dists APHD,

416:
417:
418: SELECT SUM(APHD.Bank_Curr_Amount)
419: INTO l_bank_curr_sum
420: FROM AP_Payment_Hist_Dists APHD,
421: AP_Payment_History_All APH
422: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
423: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
424: AND APH.Related_Event_ID = P_Related_Event_ID

Line 531: FROM AP_Payment_Hist_Dists APHD,

527:
528:
529: SELECT SUM(APHD.Amount)
530: INTO l_discount_sum
531: FROM AP_Payment_Hist_Dists APHD,
532: AP_Payment_History_All APH
533: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
534: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
535: AND APH.Related_Event_ID = P_Related_Event_ID

Line 570: FROM AP_Payment_Hist_Dists APHD,

566:
567:
568: SELECT SUM(APHD.Invoice_Dist_Amount)
569: INTO l_discount_sum
570: FROM AP_Payment_Hist_Dists APHD,
571: AP_Payment_History_All APH
572: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
573: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
574: AND APH.Related_Event_ID = P_Related_Event_ID

Line 610: FROM AP_Payment_Hist_Dists APHD,

606:
607:
608: SELECT SUM(APHD.Bank_Curr_Amount)
609: INTO l_discount_sum
610: FROM AP_Payment_Hist_Dists APHD,
611: AP_Payment_History_All APH
612: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
613: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
614: AND APH.Related_Event_ID = P_Related_Event_ID

Line 659: FROM AP_Payment_Hist_Dists APHD,

655: SUM(APHD.Bank_Curr_Amount)
656: INTO l_pay_sum,
657: l_inv_dist_sum,
658: l_bank_curr_sum
659: FROM AP_Payment_Hist_Dists APHD,
660: AP_Payment_History_All APH
661: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
662: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')
663: AND NVL(APH.Posted_Flag, 'N') = 'Y'

Line 677: FROM AP_Payment_Hist_Dists APHD,

673: SUM(APHD.Bank_Curr_Amount)
674: INTO l_pay_sum,
675: l_inv_dist_sum,
676: l_bank_curr_sum
677: FROM AP_Payment_Hist_Dists APHD,
678: AP_Payment_History_All APH
679: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
680: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT')
681: AND NVL(APH.Posted_Flag, 'N') = 'Y'

Line 694: FROM AP_Payment_Hist_Dists APHD,

690: SUM(APHD.Bank_Curr_Amount)
691: INTO l_pay_sum,
692: l_inv_dist_sum,
693: l_bank_curr_sum
694: FROM AP_Payment_Hist_Dists APHD,
695: AP_Payment_History_All APH
696: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
697: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT')
698: AND NVL(APH.Posted_Flag, 'N') = 'Y'

Line 826: FROM AP_Payment_Hist_Dists APHD,

822: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
823: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
824: APHD.Amount)
825: INTO l_paid_acctd_amt
826: FROM AP_Payment_Hist_Dists APHD,
827: AP_Invoice_Distributions_All AID,
828: AP_Payment_History_All APH
829: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
830: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 852: FROM AP_Payment_Hist_Dists APHD,

848: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
849: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
850: APHD.Amount)
851: INTO l_paid_acctd_amt
852: FROM AP_Payment_Hist_Dists APHD,
853: AP_Invoice_Distributions_All AID,
854: AP_Payment_History_All APH
855: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
856: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 878: FROM AP_Payment_Hist_Dists APHD,

874: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
875: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
876: APHD.Amount)
877: INTO l_paid_acctd_amt
878: FROM AP_Payment_Hist_Dists APHD,
879: AP_Invoice_Distributions_All AID,
880: AP_Payment_History_All APH
881: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
882: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID