APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM2_HIER

Line 3496: elsif p_hier_table_name = 'FEM_USER_DIM2_HIER' then

3492: l_last_update_date,
3493: l_last_update_login,
3494: 1);
3495:
3496: elsif p_hier_table_name = 'FEM_USER_DIM2_HIER' then
3497:
3498: select rowid,
3499: parent_depth_num,
3500: parent_id,

Line 3519: from fem_user_dim2_hier

3515: t_chld_value_set_id,
3516: t_sngle_depth_flag,
3517: t_dspy_order_num,
3518: t_wt_pct
3519: from fem_user_dim2_hier
3520: where hierarchy_obj_def_id = p_src_hier_version_id;
3521:
3522: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3523:

Line 3525: INSERT INTO fem_user_dim2_hier

3521:
3522: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3523:
3524: --Bug#5528200: Corrected typo. Should be dim2 not dim3!
3525: INSERT INTO fem_user_dim2_hier
3526: ( hierarchy_obj_def_id,
3527: parent_depth_num,
3528: parent_id ,
3529: parent_value_set_id,