162: p_target_obj_def_id AS object_definition_id,
163: factor_type,
164: p_created_by,
165: p_creation_date,
166: fnd_global.user_id,
167: fnd_global.login_id,
168: sysdate,
169: 0
170: FROM fem_factor_tables
163: factor_type,
164: p_created_by,
165: p_creation_date,
166: fnd_global.user_id,
167: fnd_global.login_id,
168: sysdate,
169: 0
170: FROM fem_factor_tables
171: WHERE object_definition_id = p_source_obj_def_id;
201: c_dim_rec.hier_group_id,
202: c_dim_rec.hier_relation_code,
203: p_creation_date,
204: p_created_by,
205: fnd_global.user_id,
206: fnd_global.login_id,
207: sysdate,
208: 0
209: );
202: c_dim_rec.hier_relation_code,
203: p_creation_date,
204: p_created_by,
205: fnd_global.user_id,
206: fnd_global.login_id,
207: sysdate,
208: 0
209: );
210: END LOOP;
234: c_ft_fctrs_rec.dim_member,
235: c_ft_fctrs_rec.factor_value,
236: p_creation_date,
237: p_created_by,
238: fnd_global.login_id,
239: fnd_global.user_id,
240: sysdate,
241: 0
242: );
235: c_ft_fctrs_rec.factor_value,
236: p_creation_date,
237: p_created_by,
238: fnd_global.login_id,
239: fnd_global.user_id,
240: sysdate,
241: 0
242: );
243: END LOOP;