APPS.FEM_DIM_PRS_UTILS_PVT dependencies on FEM_DIM_ATTRIBUTES_B

Line 189: ,fem_dim_attributes_b ab

185: delete from fem_dim_attr_versions_tl avt
186: where exists (
187: select null
188: from fem_dim_attr_versions_b avb
189: ,fem_dim_attributes_b ab
190: where avb.version_id = avt.version_id
191: --and avb.personal_flag = 'Y'
192: --and avb.created_by = l_user_id
193: and ab.attribute_id = avb.attribute_id

Line 204: from fem_dim_attributes_b

200: --where personal_flag = 'Y'
201: --and created_by = l_user_id
202: where attribute_id in (
203: select attribute_id
204: from fem_dim_attributes_b
205: where dimension_id = l_dimension_id
206: and personal_flag = 'Y'
207: and created_by = l_user_id
208: );

Line 213: from fem_dim_attributes_b

209:
210: delete from fem_dim_attributes_tl
211: where attribute_id in (
212: select attribute_id
213: from fem_dim_attributes_b
214: where dimension_id = l_dimension_id
215: and personal_flag = 'Y'
216: and created_by = l_user_id
217: );

Line 219: delete from fem_dim_attributes_b

215: and personal_flag = 'Y'
216: and created_by = l_user_id
217: );
218:
219: delete from fem_dim_attributes_b
220: where dimension_id = l_dimension_id
221: and personal_flag = 'Y'
222: and created_by = l_user_id;
223: