DBA Data[Home] [Help]

APPS.FEM_MIR_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 523: FROM fem_object_catalog_vl A,

519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
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

Line 654: ,fem_object_catalog_vl B

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
658: AND A.dimension_group_id = l_parent_group_id