[Home] [Help]
78: where customer_trx_line_id =pr_new.ref_line_id);
79:
80: CURSOR Tax_Amount_Cur IS
81: SELECT sum(a.tax_amount) tax_amount
82: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
83: WHERE a.tax_id = b.tax_id
84: AND a.link_to_cust_trx_line_id = v_ref_line
85: AND b.tax_type NOT IN (
86: jai_constants.tax_type_tds ,