102: )
103: SELECT
104: p_target_obj_def_id
105: ,dimension_id
106: ,nvl(p_created_by,fnd_global.user_id )
107: ,nvl(p_creation_date,sysdate)
108: ,nvl(p_created_by,fnd_global.user_id )
109: ,nvl(p_creation_date,sysdate)
110: ,fnd_global.login_id
104: p_target_obj_def_id
105: ,dimension_id
106: ,nvl(p_created_by,fnd_global.user_id )
107: ,nvl(p_creation_date,sysdate)
108: ,nvl(p_created_by,fnd_global.user_id )
109: ,nvl(p_creation_date,sysdate)
110: ,fnd_global.login_id
111: ,0
112: FROM fem_dim_load_dim_params
106: ,nvl(p_created_by,fnd_global.user_id )
107: ,nvl(p_creation_date,sysdate)
108: ,nvl(p_created_by,fnd_global.user_id )
109: ,nvl(p_creation_date,sysdate)
110: ,fnd_global.login_id
111: ,0
112: FROM fem_dim_load_dim_params
113: WHERE loader_obj_def_id = p_source_obj_def_id;
114:
129: ,p_target_obj_def_id
130: ,dimension_id
131: ,hier_obj_id
132: ,hier_obj_def_id
133: ,nvl(p_created_by,fnd_global.user_id )
134: ,nvl(p_creation_date,sysdate)
135: ,nvl(p_created_by,fnd_global.user_id )
136: ,nvl(p_creation_date,sysdate)
137: ,fnd_global.login_id
131: ,hier_obj_id
132: ,hier_obj_def_id
133: ,nvl(p_created_by,fnd_global.user_id )
134: ,nvl(p_creation_date,sysdate)
135: ,nvl(p_created_by,fnd_global.user_id )
136: ,nvl(p_creation_date,sysdate)
137: ,fnd_global.login_id
138: ,0
139: FROM fem_dim_load_hier_params
133: ,nvl(p_created_by,fnd_global.user_id )
134: ,nvl(p_creation_date,sysdate)
135: ,nvl(p_created_by,fnd_global.user_id )
136: ,nvl(p_creation_date,sysdate)
137: ,fnd_global.login_id
138: ,0
139: FROM fem_dim_load_hier_params
140: WHERE LOADER_OBJ_DEF_ID = p_source_obj_def_id;
141: