APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_VALUE_SETS_VL

Line 580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,

576: l.meaning context, b.dimension_id, dim.dimension_name,
577: b.dimension_member, b.value_set_id, v.value_set_name,
578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
583: WHERE b.object_definition_id = p_obj_def_id
584: AND b.object_definition_id = d.object_definition_id

Line 1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;

1603: v_hier_obj_id FEM_HIERARCHIES.HIERARCHY_OBJ_ID%TYPE;
1604: v_hier_obj_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1605: v_hier_obj_def_name FEM_OBJECT_DEFINITION_VL.DISPLAY_NAME%TYPE;
1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;
1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1610: v_child_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1611: v_child_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;

Line 1673: FROM fem_global_vs_combo_defs d, fem_value_sets_vl s

1669:
1670: IF (v_value_set_flag = 'Y' AND p_global_vs_id is not null) THEN
1671: SELECT d.value_set_id, s.value_set_name
1672: INTO v_value_set_id, v_value_set_name
1673: FROM fem_global_vs_combo_defs d, fem_value_sets_vl s
1674: WHERE d.GLOBAL_VS_COMBO_ID = p_global_vs_id
1675: AND d.dimension_id = v_dim_id
1676: AND d.value_set_id = s.value_set_id;
1677: ELSE