386: v_tax_diff NUMBER;
387: v_new_cpn_amt_dda NUMBER;
388: v_out_rec xtr_mm_covers.CalcBondCpnAmt_out_rec;
389: v_in_rec xtr_mm_covers.CalcBondCpnAmt_in_rec;
390: v_prncpl_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
391: v_prncpl_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
392: v_income_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
393: v_income_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
394:
387: v_new_cpn_amt_dda NUMBER;
388: v_out_rec xtr_mm_covers.CalcBondCpnAmt_out_rec;
389: v_in_rec xtr_mm_covers.CalcBondCpnAmt_in_rec;
390: v_prncpl_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
391: v_prncpl_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
392: v_income_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
393: v_income_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
394:
395: CURSOR C_GET_CURR_RELATED_TRANS(p_deal_number NUMBER,
388: v_out_rec xtr_mm_covers.CalcBondCpnAmt_out_rec;
389: v_in_rec xtr_mm_covers.CalcBondCpnAmt_in_rec;
390: v_prncpl_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
391: v_prncpl_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
392: v_income_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
393: v_income_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
394:
395: CURSOR C_GET_CURR_RELATED_TRANS(p_deal_number NUMBER,
396: p_transaction_number NUMBER) is
389: v_in_rec xtr_mm_covers.CalcBondCpnAmt_in_rec;
390: v_prncpl_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
391: v_prncpl_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
392: v_income_ctype xtr_tax_brokerage_setup.calc_type%TYPE;
393: v_income_method xtr_tax_brokerage_setup.tax_settle_method%TYPE;
394:
395: CURSOR C_GET_CURR_RELATED_TRANS(p_deal_number NUMBER,
396: p_transaction_number NUMBER) is
397: select rt.deal_number,rt.transaction_number,rt.tax_settled_reference,