APPS.JAI_PA_BILLING_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2077: v_payment_num ap_payment_schedules_all.payment_num%type;

2073: return boolean is
2074:
2075: v_total_tax_in_payment number;
2076: v_tax_installment number;
2077: v_payment_num ap_payment_schedules_all.payment_num%type;
2078: v_total_payment_amt number;
2079: v_diff_tax_amount number;
2080: ln_precision fnd_currencies.precision%type;
2081:

Line 2085: from ap_payment_schedules_all

2081:
2082:
2083: cursor c_total_payment_amt is
2084: select sum(gross_amount)
2085: from ap_payment_schedules_all
2086: where invoice_id = p_invoice_id;
2087:
2088: cursor c_get_inv_currency
2089: is

Line 2123: from ap_payment_schedules_all

2119:
2120: for c_installments
2121: in ( select gross_amount
2122: ,payment_num
2123: from ap_payment_schedules_all
2124: where invoice_id = p_invoice_id
2125: order by payment_num
2126: )
2127: loop

Line 2136: update ap_payment_schedules_all

2132: v_tax_installment := p_total_tax * (c_installments.gross_amount / v_total_payment_amt);
2133:
2134: v_tax_installment := round(v_tax_installment, ln_precision);
2135:
2136: update ap_payment_schedules_all
2137: set gross_amount = gross_amount + v_tax_installment,
2138: amount_remaining = amount_remaining + v_tax_installment,
2139: inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
2140: payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)

Line 2152: update ap_payment_schedules_all

2148: if v_total_tax_in_payment <> p_total_tax then
2149:
2150: v_diff_tax_amount := round( p_total_tax - v_total_tax_in_payment,ln_precision);
2151:
2152: update ap_payment_schedules_all
2153: set gross_amount = gross_amount + v_diff_tax_amount,
2154: amount_remaining = amount_remaining + v_diff_tax_amount,
2155: inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
2156: where invoice_id = p_invoice_id