[Home] [Help]
6929:
6930: cursor c_invdist is
6931: select parent_reversal_id
6932: into l_parent_dist_id
6933: from ap_invoice_distributions_all apd
6934: where invoice_distribution_id = NVL(l_SysRef5Tab(p_indx),0)
6935: and nvl(reversal_flag,'N') = 'Y' ;
6936:
6937: cursor c_rcvtxn is
10105: (select po_header_id, po_distribution_id
10106: from po_distributions_all
10107: where po_distribution_id in
10108: (select po_distribution_id
10109: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10110: where inv.invoice_id = pti.cdl_system_reference2
10111: and inv.invoice_distribution_id = pti.cdl_system_reference5 /*REL12 : AP Lines Uptake changes*/
10112: and pti.transaction_source = p_calling_mode
10113: and pti.transaction_status_code = 'R'
10197: l_base_qv NUMBER;
10198: l_base_av NUMBER;
10199: l_period_year pa_bc_packets.period_year%type; --REL12
10200: l_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
10201: l_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
10202:
10203: -- R12 AP lines uptake : Prepayment changes :Cursor to fetch AP related details.
10204: CURSOR C_ap_details (p_invoice_id NUMBER,
10205: p_invoice_distribution_id NUMBER) IS
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'
11749: and apd.invoice_distribution_id = b.invoice_distribution_id