APPS.PA_TRX_IMPORT dependencies on AP_PAYMENT_HIST_DISTS

Line 8239: from ap_payment_hist_dists Paydist

8235:
8236: IF NVL(l_payment_status_flag,'N') = 'Y' THEN
8237: SELECT max(Invoice_Payment_Id)
8238: into l_finalPaymentIdTab(j)
8239: from ap_payment_hist_dists Paydist
8240: where NVL(paydist.pay_dist_lookup_code, 'CASH') = 'CASH'
8241: and Paydist.invoice_distribution_id = NVL(l_SysRef5Tab(j) ,0) ;
8242: END IF ; -- l_payment_status_flag = 'Y'
8243:

Line 9192: from ap_payment_hist_dists

9188: log_message('log_message: ' || pa_debug.G_err_stage);
9189:
9190: select decode(reversal_flag, 'Y', reversed_pay_hist_dist_id,l_SysRef1Tab(j))
9191: into l_SysRef5Tab(j)
9192: from ap_payment_hist_dists
9193: where payment_hist_dist_id = l_SysRef1Tab(j);
9194:
9195: pa_debug.G_err_stage := '2. After l_SysRef5Tab(j) : '|| l_SysRef5Tab(j) ;
9196: log_message('log_message: ' || pa_debug.G_err_stage);

Line 12637: from ap_payment_hist_dists b,

12633: -- ap amount to relieve := payment amunt + discount amount (when applicable).
12634: -- ====================================================================================
12635: CURSOR c_get_disc_amount is
12636: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
12637: from ap_payment_hist_dists b,
12638: ap_invoice_distributions_all apd
12639: where b.invoice_payment_id = p_sys_ref4
12640: and b.invoice_distribution_id = p_sys_ref5
12641: and b.pay_dist_lookup_code = 'DISCOUNT'

Line 12656: FROM ap_payment_hist_dists Paydist

12652: apd.line_type_lookup_code ) ;
12653: -- AP Invoice dist amount to be relieved for payment with ERV
12654: CURSOR C_payment_erv_amount IS
12655: SELECT NVL(paydist.invoice_dist_base_amount,paydist.invoice_dist_amount)
12656: FROM ap_payment_hist_dists Paydist
12657: WHERE paydist.pay_dist_lookup_code = 'CASH'
12658: AND Paydist.invoice_distribution_id = p_sys_ref5
12659: AND PayDIST.invoice_payment_id = p_sys_ref4
12660: AND EXISTS