APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 395: FROM fem_object_catalog_vl C, fem_object_definition_vl D

391: D.description
392: INTO v_folder_id, v_local_vs_combo_id, v_object_access_code,
393: v_object_origin_code, v_object_name, v_description, v_display_name,
394: v_objdef_desc
395: FROM fem_object_catalog_vl C, fem_object_definition_vl D
396: WHERE D.object_id = C.object_id
397: AND D.object_definition_id = p_map_rule_obj_def_id
398: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
399:

Line 703: FROM fem_object_catalog_vl C, fem_object_definition_vl D

699: BEGIN
700:
701: SELECT 1
702: INTO v_count
703: FROM fem_object_catalog_vl C, fem_object_definition_vl D
704: WHERE D.object_id = C.object_id
705: AND D.object_definition_id = p_map_rule_obj_def_id
706: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
707:

Line 945: FROM fem_object_catalog_vl C, fem_object_definition_vl D

941: BEGIN
942:
943: SELECT 1
944: INTO v_count
945: FROM fem_object_catalog_vl C, fem_object_definition_vl D
946: WHERE D.object_id = C.object_id
947: AND D.object_definition_id = p_map_rule_obj_def_id
948: AND C.object_type_code IN (C_RULE_OBJTYPE, C_DFLT_OBJTYPE);
949:

Line 1182: FROM fem_object_catalog_vl C, fem_object_definition_vl D,

1178: BEGIN
1179:
1180: SELECT O.map_rule_type_code
1181: INTO v_map_rule_type_code
1182: FROM fem_object_catalog_vl C, fem_object_definition_vl D,
1183: fem_alloc_br_objects O
1184: WHERE D.object_id = C.object_id
1185: AND D.object_definition_id = p_map_rule_obj_def_id
1186: AND C.object_type_code = 'MAPPING_RULE'

Line 1518: FROM fem_object_catalog_vl C

1514:
1515:
1516: SELECT object_name, description, folder_id
1517: INTO v_object_name, v_description, v_dflt_folder_id
1518: FROM fem_object_catalog_vl C
1519: WHERE object_id = v_seeded_dflt_object_id;
1520:
1521: IF p_target_folder_id IS NULL THEN
1522: v_folder_id := v_dflt_folder_id;

Line 2136: fem_object_catalog_vl O

2132: SELECT D.hierarchy_obj_id, O.object_name
2133: FROM (SELECT DISTINCT hierarchy_obj_id
2134: FROM fem_cond_dim_cmp_dtl D
2135: WHERE cond_dim_cmp_obj_def_id = p_cond_obj_def_id) D,
2136: fem_object_catalog_vl O
2137: WHERE D.hierarchy_obj_id = O.object_id;
2138:
2139:
2140: cursor c_attr (p_cond_obj_def_id IN NUMBER, p_dimension_id IN NUMBER) IS

Line 3003: FROM fem_object_catalog_vl

2999: IF dim.hier_object_id IS NOT NULL THEN
3000:
3001: SELECT object_name
3002: INTO v_hier_name
3003: FROM fem_object_catalog_vl
3004: WHERE object_id = dim.hier_object_id;
3005: END IF;
3006:
3007: IF dim.hier_group_id IS NOT NULL THEN