APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 124: FROM fem_object_catalog_b

120: --
121: -- Get all root rules as limited by the runtime parameters.
122: CURSOR c_all_root_rules IS
123: SELECT object_id
124: FROM fem_object_catalog_b
125: WHERE object_type_code = p_rule_type
126: AND local_vs_combo_id = p_global_vs_id
127: AND folder_id = Nvl(p_folder_id, folder_id)
128: AND object_id = Nvl(p_object_id, object_id);

Line 426: FROM fem_object_catalog_b c

422: FROM fem_object_dependencies d
423: WHERE object_definition_id = cv_obj_def_id
424: AND EXISTS (
425: SELECT null
426: FROM fem_object_catalog_b c
427: WHERE c.object_id = d.required_object_id);
428: --
429: BEGIN
430: --

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 1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a

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
1654: AND o.object_definition_id = od.object_definition_id
1655: AND o.object_id = c.object_id