APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 150: FROM fem_object_definition_b od, fem_rule_sets rs

146: -- Make sure its Folder corresponds to the Folder parameter (if specified)
147: IF (p_object_id IS NOT NULL) THEN
148: SELECT Decode(object_type_code, 'RULE_SET',
149: (SELECT rs.rule_set_object_type_code
150: FROM fem_object_definition_b od, fem_rule_sets rs
151: WHERE rs.rule_set_obj_def_id = od.object_definition_id
152: AND od.object_id = p_object_id),
153: object_type_code) rule_type,
154: local_vs_combo_id, folder_id, object_name,

Line 668: FROM fem_object_catalog_b oc, fem_object_definition_b od

664: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
665: -- Add this to make debug log more readable
666: SELECT oc.object_type_code
667: INTO v_rule_type
668: FROM fem_object_catalog_b oc, fem_object_definition_b od
669: WHERE oc.object_id = od.object_id
670: AND od.object_definition_id = p_obj_def_id;
671:
672: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 694: FROM fem_object_catalog_b oc, fem_object_definition_b od

690:
691: -- Get rule type of current rule
692: SELECT oc.object_type_code
693: INTO v_rule_type
694: FROM fem_object_catalog_b oc, fem_object_definition_b od
695: WHERE oc.object_id = od.object_id
696: AND od.object_definition_id = p_obj_def_id;
697:
698: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1649: FROM fem_hier_definitions d, fem_object_definition_b o,

1645: SELECT h.dimension_id, h.hierarchy_obj_id, a.object_name, od.display_name,
1646: h.flattened_rows_flag
1647: INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
1648: v_flat_flag
1649: FROM fem_hier_definitions d, fem_object_definition_b o,
1650: fem_object_definition_vl od,
1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a
1652: WHERE d.hierarchy_obj_def_id = p_obj_def_id
1653: AND d.hierarchy_obj_def_id = o.object_definition_id