APPS.GMS_PA_COSTING_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 499: FROM ap_payment_hist_dists Paydist

495:
496: -- AP Invoice payment amount to be relieved
497: CURSOR C_apdist_amount IS
498: SELECT NVL(paydist.invoice_dist_base_amount,paydist.invoice_dist_amount)
499: FROM ap_payment_hist_dists Paydist
500: WHERE paydist.pay_dist_lookup_code = 'CASH'
501: AND Paydist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
502: AND PayDIST.invoice_payment_id = g_xface_rec.cdl_system_reference4;
503:

Line 541: FROM ap_payment_hist_dists Paydist1,

537: -- Cursor to fetch interfaced payment amount for an invoice distribution
538: CURSOR c_ap_interfaced_pay_amt IS
539: SELECT SUM(NVL(paydist1.invoice_dist_base_amount,paydist1.invoice_dist_amount))
540: + SUM(NVL(paydist2.invoice_dist_base_amount,paydist2.invoice_dist_amount))
541: FROM ap_payment_hist_dists Paydist1,
542: ap_payment_hist_dists Paydist2
543: WHERE paydist1.pay_dist_lookup_code = 'CASH'
544: AND Paydist1.invoice_distribution_id = g_xface_rec.invoice_distribution_id
545: and Paydist2.invoice_distribution_id = g_xface_rec.invoice_distribution_id

Line 542: ap_payment_hist_dists Paydist2

538: CURSOR c_ap_interfaced_pay_amt IS
539: SELECT SUM(NVL(paydist1.invoice_dist_base_amount,paydist1.invoice_dist_amount))
540: + SUM(NVL(paydist2.invoice_dist_base_amount,paydist2.invoice_dist_amount))
541: FROM ap_payment_hist_dists Paydist1,
542: ap_payment_hist_dists Paydist2
543: WHERE paydist1.pay_dist_lookup_code = 'CASH'
544: AND Paydist1.invoice_distribution_id = g_xface_rec.invoice_distribution_id
545: and Paydist2.invoice_distribution_id = g_xface_rec.invoice_distribution_id
546: AND ( paydist1.pa_addition_flag = 'Y' OR --interfaced payments

Line 585: from ap_payment_hist_dists b,

581: -- ap amount to relieve := payment amunt + discount amount (when applicable).
582: -- ====================================================================================
583: CURSOR c_get_disc_amount is
584: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
585: from ap_payment_hist_dists b,
586: ap_invoice_distributions_all apd
587: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
588: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
589: and b.pay_dist_lookup_code = 'DISCOUNT'