107: BEGIN
108:
109: select count(*)
110: into v_count
111: from fem_tab_columns_b
112: where table_name='FEM_CREDIT_LIMITS'
113: and column_name = 'CREDIT_LIMIT_TYPE';
114:
115: IF v_count > 0 THEN
113: and column_name = 'CREDIT_LIMIT_TYPE';
114:
115: IF v_count > 0 THEN
116:
117: delete from fem_tab_columns_b
118: where table_name='FEM_CREDIT_LIMITS'
119: and column_name in ('CREDIT_LIMIT_ID','CREDIT_LIMIT_TYPE');
120:
121: delete from fem_tab_columns_tl
133: where folder_id in (1200, 1300);
134:
135:
136: --fem4453456.sql
137: delete from FEM_TAB_COLUMNS_B
138: where table_name = 'FEM_CREDIT_LIMITS'
139: and column_name = 'CREDIT_LIMIT_AMOUNT';
140:
141: delete from FEM_INT_COLUMN_MAP