APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 827: AP_Invoice_Distributions_All AID,

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
831: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')

Line 853: AP_Invoice_Distributions_All AID,

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
857: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')

Line 879: AP_Invoice_Distributions_All AID,

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
883: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')

Line 902: AP_Invoice_Distributions_All AID

898: /* Get the total prepaid amount from the ap_prepay_app_dists table */
899: SELECT SUM(APAD.Amount)
900: INTO l_prepaid_acctd_amt
901: FROM AP_Prepay_App_Dists APAD,
902: AP_Invoice_Distributions_All AID
903: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
904: AND AID.Invoice_Distribution_ID = APAD.Invoice_Distribution_ID
905: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
906: 'PREPAY APPL NONREC TAX', 'AWT');