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 556: FROM ap_payment_hist_dists Paydist1,

552: -- Cursor to fetch interfaced payment amount for an invoice distribution
553: CURSOR c_ap_interfaced_pay_amt IS
554: SELECT SUM(NVL(paydist1.invoice_dist_base_amount,paydist1.invoice_dist_amount))
555: + SUM(NVL(paydist2.invoice_dist_base_amount,paydist2.invoice_dist_amount))
556: FROM ap_payment_hist_dists Paydist1,
557: ap_payment_hist_dists Paydist2
558: WHERE paydist1.pay_dist_lookup_code = 'CASH'
559: AND Paydist1.invoice_distribution_id = g_xface_rec.invoice_distribution_id
560: and Paydist2.invoice_distribution_id = g_xface_rec.invoice_distribution_id

Line 557: ap_payment_hist_dists Paydist2

553: CURSOR c_ap_interfaced_pay_amt IS
554: SELECT SUM(NVL(paydist1.invoice_dist_base_amount,paydist1.invoice_dist_amount))
555: + SUM(NVL(paydist2.invoice_dist_base_amount,paydist2.invoice_dist_amount))
556: FROM ap_payment_hist_dists Paydist1,
557: ap_payment_hist_dists Paydist2
558: WHERE paydist1.pay_dist_lookup_code = 'CASH'
559: AND Paydist1.invoice_distribution_id = g_xface_rec.invoice_distribution_id
560: and Paydist2.invoice_distribution_id = g_xface_rec.invoice_distribution_id
561: AND ( paydist1.pa_addition_flag = 'Y' OR --interfaced payments

Line 600: from ap_payment_hist_dists b,

596: -- ap amount to relieve := payment amunt + discount amount (when applicable).
597: -- ====================================================================================
598: CURSOR c_get_disc_amount is
599: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
600: from ap_payment_hist_dists b,
601: ap_invoice_distributions_all apd
602: where b.invoice_payment_id = g_xface_rec.cdl_system_reference4
603: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
604: and b.pay_dist_lookup_code = 'DISCOUNT'

Line 618: from AP_PAYMENT_HIST_DISTS B,

614: 'SYSTEM', 'NOT APPLICABLE',
615: apd.line_type_lookup_code )
616: union /* BUG 14216205 : Added the union for SAT */
617: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
618: from AP_PAYMENT_HIST_DISTS B,
619: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
620: where B.INVOICE_PAYMENT_ID = G_XFACE_REC.CDL_SYSTEM_REFERENCE4
621: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
622: and b.pay_dist_lookup_code = 'DISCOUNT'