APPS.FEM_MIR_PKG dependencies on FEM_HIER_DIMENSION_GRPS

Line 525: fem_hier_dimension_grps C,

521: SELECT B.DIMENSION_GROUP_DISPLAY_CODE
522: INTO l_dim_group_display_code
523: FROM fem_object_catalog_vl A,
524: fem_dimension_grps_b B,
525: fem_hier_dimension_grps C,
526: fem_dimensions_b D
527: WHERE D.dimension_varchar_label = p_dimension_varchar_label
528: AND D.DIMENSION_ID=B.DIMENSION_ID
529: AND A.OBJECT_NAME = p_hierarchy_name

Line 653: FROM fem_hier_dimension_grps A

649: SELECT A.relative_dimension_group_seq,
650: C.relative_dimension_group_seq
651: INTO l_count_parent
652: ,l_count_child
653: FROM fem_hier_dimension_grps A
654: ,fem_object_catalog_vl B
655: ,fem_hier_dimension_grps C
656: WHERE B.object_name = p_hierarchy_name
657: AND A.hierarchy_obj_id=B.object_id

Line 655: ,fem_hier_dimension_grps C

651: INTO l_count_parent
652: ,l_count_child
653: FROM fem_hier_dimension_grps A
654: ,fem_object_catalog_vl B
655: ,fem_hier_dimension_grps C
656: WHERE B.object_name = p_hierarchy_name
657: AND A.hierarchy_obj_id=B.object_id
658: AND A.dimension_group_id = l_parent_group_id
659: AND C.hierarchy_obj_id=B.object_id