APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on FEM_HIER_DIMENSION_GRPS

Line 284: select nvl((select 'Y' from FEM_HIER_DIMENSION_GRPS where hierarchy_obj_id = p_hier_obj_id and dimension_group_id = p_group_id),'N') into l_valid_flag from dual;

280:
281: PROCEDURE VALIDATE_GROUP (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_group_id IN NUMBER) IS
282: l_valid_flag varchar2(1);
283: BEGIN
284: select nvl((select 'Y' from FEM_HIER_DIMENSION_GRPS where hierarchy_obj_id = p_hier_obj_id and dimension_group_id = p_group_id),'N') into l_valid_flag from dual;
285: x_valid_flag := l_valid_flag;
286: END VALIDATE_GROUP;
287:
288: PROCEDURE VALIDATE_DIM_MEMBER(x_valid_flag OUT NOCOPY VARCHAR2,p_hier_object_id IN NUMBER,p_group_id IN NUMBER,p_dimension_id IN NUMBER,p_member_id IN NUMBER) IS

Line 303: ' WHERE DIMENSION_GROUP_ID IN (SELECT DIMENSION_GROUP_ID FROM FEM_HIER_DIMENSION_GRPS WHERE HIERARCHY_OBJ_ID = ' || p_hier_object_id ||

299: end if;
300:
301: select member_b_table_name,member_col into l_member_table_name,l_member_col from fem_xdim_dimensions where dimension_id = p_dimension_id;
302: l_query := 'select ''Y'' from ' || l_member_table_name ||
303: ' WHERE DIMENSION_GROUP_ID IN (SELECT DIMENSION_GROUP_ID FROM FEM_HIER_DIMENSION_GRPS WHERE HIERARCHY_OBJ_ID = ' || p_hier_object_id ||
304: ') AND DIMENSION_GROUP_ID = ' || p_group_id ||
305: ' AND ' || l_member_col || ' = ' || p_member_id ;
306:
307: l_main_query:= 'select nvl((' || l_query || '),''N'') from dual';