DBA Data[Home] [Help]

APPS.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 10976: ',fem_object_definition_b D'||

10972:
10973: IF p_value_set_required_flag = 'Y' THEN
10974: x_select_stmt := 'SELECT count(*)'||
10975: ' FROM '||p_hier_table_name||' H'||
10976: ',fem_object_definition_b D'||
10977: ',fem_hierarchies O'||
10978: ' WHERE H.hierarchy_obj_def_id = D.object_definition_id'||
10979: ' AND D.object_id = O.hierarchy_obj_id'||
10980: ' AND O.group_sequence_enforced_code '||

Line 10987: ',fem_object_definition_b D'||

10983: ' AND H.child_value_set_id = :b_value_set_id';
10984: ELSE
10985: x_select_stmt := 'SELECT count(*)'||
10986: ' FROM '||p_hier_table_name||' H'||
10987: ',fem_object_definition_b D'||
10988: ',fem_hierarchies O'||
10989: ' WHERE H.hierarchy_obj_def_id = D.object_definition_id'||
10990: ' AND D.object_id = O.hierarchy_obj_id'||
10991: ' AND O.group_sequence_enforced_code '||

Line 17089: FROM fem_object_definition_b

17085: -- Get Object ID
17086: BEGIN
17087: SELECT object_id
17088: INTO v_object_id
17089: FROM fem_object_definition_b
17090: WHERE object_definition_id = v_object_definition_id
17091: AND object_id IN (SELECT object_id FROM fem_object_catalog_b
17092: WHERE object_type_code = 'DIM_MEMBER_LOADER');
17093: EXCEPTION