APPS.PA_TRX_IMPORT dependencies on AP_PAYMENT_HIST_DISTS

Line 7593: from ap_payment_hist_dists Paydist

7589:
7590: IF NVL(l_payment_status_flag,'N') = 'Y' THEN
7591: SELECT max(Invoice_Payment_Id)
7592: into l_finalPaymentIdTab(j)
7593: from ap_payment_hist_dists Paydist
7594: where NVL(paydist.pay_dist_lookup_code, 'CASH') = 'CASH'
7595: and Paydist.invoice_distribution_id = NVL(l_SysRef5Tab(j) ,0) ;
7596: END IF ; -- l_payment_status_flag = 'Y'
7597:

Line 11744: from ap_payment_hist_dists b,

11740: -- ap amount to relieve := payment amunt + discount amount (when applicable).
11741: -- ====================================================================================
11742: CURSOR c_get_disc_amount is
11743: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
11744: from ap_payment_hist_dists b,
11745: ap_invoice_distributions_all apd
11746: where b.invoice_payment_id = p_sys_ref4
11747: and b.invoice_distribution_id = p_sys_ref5
11748: and b.pay_dist_lookup_code = 'DISCOUNT'

Line 11763: FROM ap_payment_hist_dists Paydist

11759: apd.line_type_lookup_code ) ;
11760: -- AP Invoice dist amount to be relieved for payment with ERV
11761: CURSOR C_payment_erv_amount IS
11762: SELECT NVL(paydist.invoice_dist_base_amount,paydist.invoice_dist_amount)
11763: FROM ap_payment_hist_dists Paydist
11764: WHERE paydist.pay_dist_lookup_code = 'CASH'
11765: AND Paydist.invoice_distribution_id = p_sys_ref5
11766: AND PayDIST.invoice_payment_id = p_sys_ref4
11767: AND EXISTS