DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_XDIM_DIMENSIONS

Line 563: from fem_xdim_dimensions

559: For l_dim_csr_rec in
560: (
561: Select hierarchy_table_name,
562: value_set_required_flag
563: from fem_xdim_dimensions
564: where dimension_id = l_dimension_id
565: )
566: Loop
567: l_hier_table_name := l_dim_csr_rec.hierarchy_table_name;

Line 4392: FROM fem_xdim_dimensions

4388:
4389: CURSOR l_dimension_detail_csr (c_hierarchy_id IN NUMBER)
4390: IS
4391: SELECT hier_versioning_type_code
4392: FROM fem_xdim_dimensions
4393: WHERE dimension_id = (SELECT dimension_id
4394: FROM fem_hierarchies
4395: WHERE hierarchy_obj_id = c_hierarchy_id);
4396:

Line 7195: FROM FEM_XDIM_DIMENSIONS_VL

7191: l_member_vl_object_name,
7192: l_hierarchy_table_name,
7193: l_per_hierarchy_table_name,
7194: l_value_set_required_flag
7195: FROM FEM_XDIM_DIMENSIONS_VL
7196: WHERE DIMENSION_ID = p_dimension_id;
7197:
7198: IF p_comp_dim_flag = 'N' then -- BOR project - added the check condition
7199: -- Construct select statement