APPS.JAI_PA_BILLING_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2113: v_payment_num ap_payment_schedules_all.payment_num%type;

2109: return boolean is
2110:
2111: v_total_tax_in_payment number;
2112: v_tax_installment number;
2113: v_payment_num ap_payment_schedules_all.payment_num%type;
2114: v_total_payment_amt number;
2115: v_diff_tax_amount number;
2116: ln_precision fnd_currencies.precision%type;
2117:

Line 2121: from ap_payment_schedules_all

2117:
2118:
2119: cursor c_total_payment_amt is
2120: select sum(gross_amount)
2121: from ap_payment_schedules_all
2122: where invoice_id = p_invoice_id;
2123:
2124: cursor c_get_inv_currency
2125: is

Line 2159: from ap_payment_schedules_all

2155:
2156: for c_installments
2157: in ( select gross_amount
2158: ,payment_num
2159: from ap_payment_schedules_all
2160: where invoice_id = p_invoice_id
2161: order by payment_num
2162: )
2163: loop

Line 2172: update ap_payment_schedules_all

2168: v_tax_installment := p_total_tax * (c_installments.gross_amount / v_total_payment_amt);
2169:
2170: v_tax_installment := round(v_tax_installment, ln_precision);
2171:
2172: update ap_payment_schedules_all
2173: set gross_amount = gross_amount + v_tax_installment,
2174: amount_remaining = amount_remaining + v_tax_installment,
2175: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
2176: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 2188: update ap_payment_schedules_all

2184: if v_total_tax_in_payment <> p_total_tax then
2185:
2186: v_diff_tax_amount := round( p_total_tax - v_total_tax_in_payment,ln_precision);
2187:
2188: update ap_payment_schedules_all
2189: set gross_amount = gross_amount + v_diff_tax_amount,
2190: amount_remaining = amount_remaining + v_diff_tax_amount,
2191: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
2192: where invoice_id = p_invoice_id