diff options
Diffstat (limited to 'sql/et_tables.sql')
| -rw-r--r-- | sql/et_tables.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 172d348a..03562d90 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -503,9 +503,9 @@ CREATE OR REPLACE FUNCTION et_deal_subordination(p_dealname varchar(10)) IF deal_info."Curr Deal Bal" = 0 THEN curr_subordination := curr_subordination || cast(NULL AS float); ELSE - curr_subordination := curr_subordination || (curr_adjusted_collat_bal-curr_cumsum_cusip_bal)/deal_info."Curr Deal Bal"; + curr_subordination := curr_subordination || (curr_adjusted_collat_bal-curr_cumsum_cusip_bal)/curr_adjusted_collat_bal; END IF; - orig_subordination := orig_subordination || (orig_adjusted_collat_bal - orig_cumsum_cusip_bal)/deal_info."Orig Deal Bal"; + orig_subordination := orig_subordination || (orig_adjusted_collat_bal - orig_cumsum_cusip_bal)/orig_adjusted_collat_bal; cusips := cusips || cusip_row.Cusip; IF i=1 THEN curr_thickness := curr_thickness || 1 - curr_subordination[i]; @@ -521,9 +521,13 @@ CREATE OR REPLACE FUNCTION et_deal_subordination(p_dealname varchar(10)) IF i=2 THEN curr_thickness[i-1] := 1 - curr_subordination[i-1]; orig_thickness[i-1] := 1 - orig_subordination[i-1]; + curr_thickness[i] := curr_thickness[i-1]; + orig_thickness[i] := orig_thickness[i-1]; ELSE curr_thickness[i-1] := curr_subordination[i-2] - curr_subordination[i-1]; orig_thickness[i-1] := orig_subordination[i-2] - orig_subordination[i-1]; + curr_thickness[i] := curr_thickness[i-1]; + orig_thickness[i] := orig_thickness[i-1]; END IF; END IF; END IF; |