APPS.XTR_RESET_BOND_RATE dependencies on XTR_DEAL_DATE_AMOUNTS

Line 451: --update XTR_DEAL_DATE_AMOUNTS

447: UPDATED_ON = sysdate,
448: UPDATED_BY = fnd_global.user_id
449: where deal_number=curr_trans_info.deal_number
450: and transaction_number=curr_trans_info.transaction_number;
451: --update XTR_DEAL_DATE_AMOUNTS
452: if nvl(v_income_method,'NUL')='NIA' then
453: v_new_cpn_amt_dda:=v_new_cpn_amt-v_tax_amt;
454: else
455: v_new_cpn_amt_dda:=v_new_cpn_amt;

Line 457: UPDATE xtr_deal_date_amounts

453: v_new_cpn_amt_dda:=v_new_cpn_amt-v_tax_amt;
454: else
455: v_new_cpn_amt_dda:=v_new_cpn_amt;
456: end if;
457: UPDATE xtr_deal_date_amounts
458: set amount=nvl(v_new_cpn_amt_dda,0),
459: cashflow_amount=decode(curr_trans_info.deal_subtype,'BUY',1,-1)*nvl(v_new_cpn_amt_dda,0),
460: UPDATED_ON = sysdate,
461: UPDATED_BY = fnd_global.user_id

Line 469: UPDATE xtr_deal_date_amounts

465: and amount_type='COUPON' and date_type='COUPON';
466: --update the TAX DDA
467: if curr_trans_info.tax_code is not null then
468: if nvl(v_income_method,'NUL')='NIA' then
469: UPDATE xtr_deal_date_amounts
470: set amount=v_tax_amt,
471: UPDATED_ON = sysdate,
472: UPDATED_BY = fnd_global.user_id
473: where deal_type='BOND'