APPS.ZPB_BUSAREA_VAL dependencies on FEM_HIER_DIMENSION_GRPS

Line 561: FEM_HIER_DIMENSION_GRPS C

557: where A.VERSION_ID = p_version_id
558: and A.LEVEL_ID not in
559: (select B.DIMENSION_GROUP_ID
560: from FEM_DIMENSION_GRPS_B B,
561: FEM_HIER_DIMENSION_GRPS C
562: where B.DIMENSION_GROUP_ID = C.DIMENSION_GROUP_ID
563: and C.HIERARCHY_OBJ_ID = A.HIERARCHY_ID
564: and B.PERSONAL_FLAG = 'N');
565:

Line 1444: FEM_HIER_DIMENSION_GRPS X,

1440: ---------------------------------------------------------------------
1441: if (l_dim_type = 'TIME') then
1442: l_command :=
1443: 'select distinct Y.HIERARCHY_ID, Y.VERSION_ID from
1444: FEM_HIER_DIMENSION_GRPS X,
1445: (select distinct A.HIERARCHY_ID, A.VERSION_ID,
1446: B.RELATIVE_DIMENSION_GROUP_SEQ PARENT_SEQ,
1447: C.RELATIVE_DIMENSION_GROUP_SEQ CHILD_SEQ
1448: from (table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS

Line 1451: FEM_HIER_DIMENSION_GRPS B, FEM_HIER_DIMENSION_GRPS C,

1447: C.RELATIVE_DIMENSION_GROUP_SEQ CHILD_SEQ
1448: from (table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS
1449: ('||each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||
1450: l_vers_type||'''))) A,
1451: FEM_HIER_DIMENSION_GRPS B, FEM_HIER_DIMENSION_GRPS C,
1452: '||l_dim_table||' D, '||l_dim_table||' E
1453: where A.PARENT_ID = D.'||l_col||'
1454: and D.DIMENSION_GROUP_ID = B.DIMENSION_GROUP_ID
1455: and B.HIERARCHY_OBJ_ID = A.HIERARCHY_ID