APPS.FEM_MIR_PKG dependencies on FEM_DIMENSIONS_B

Line 77: fem_dimensions_b B

73:
74: SELECT A.dimension_group_display_code
75: INTO l_grp_display_code
76: FROM fem_dimension_grps_b A,
77: fem_dimensions_b B
78: WHERE A.DIMENSION_GROUP_ID = p_dimension_group_id
79: AND B.dimension_id = A.dimension_id
80: AND B.dimension_varchar_label = p_dimension_varchar_label;
81:

Line 183: fem_dimensions_b B

179:
180: SELECT A.dimension_group_display_code
181: INTO l_grp_display_code
182: FROM fem_dimension_grps_b A,
183: fem_dimensions_b B
184: WHERE A.DIMENSION_GROUP_ID = p_dimension_group_id
185: AND B.dimension_id = A.dimension_id
186: AND B.dimension_id = p_dimension_id;
187:

Line 295: fem_dimensions_b B

291:
292: SELECT A.DIMENSION_GROUP_ID
293: INTO l_dimension_group_id
294: FROM fem_dimension_grps_b A,
295: fem_dimensions_b B
296: WHERE A.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code
297: AND B.dimension_id = A.dimension_id
298: AND B.dimension_varchar_label = p_dimension_varchar_label;
299:

Line 407: fem_dimensions_b B

403:
404: SELECT A.DIMENSION_GROUP_ID
405: INTO l_dimension_group_id
406: FROM fem_dimension_grps_b A,
407: fem_dimensions_b B
408: WHERE A.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code
409: AND B.dimension_id = A.dimension_id
410: AND B.dimension_id = p_dimension_id;
411:

Line 526: fem_dimensions_b D

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
530: AND B.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code

Line 864: FROM fem_dimensions_b A,

860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861:
862: SELECT B.attribute_id
863: INTO l_dim_attribute_id
864: FROM fem_dimensions_b A,
865: fem_dim_attributes_b B
866: WHERE a.dimension_varchar_label = p_dimension_varchar_label
867: AND B.dimension_id = A.dimension_id
868: AND B.attribute_varchar_label = p_dim_attribute_varchar_label;