DBA Data[Home] [Help]

APPS.FEM_REFRESH_UTIL_PKG dependencies on FEM_TAB_COLUMNS_B

Line 111: from fem_tab_columns_b

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

Line 117: delete from fem_tab_columns_b

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

Line 137: delete from FEM_TAB_COLUMNS_B

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