APPS.ZPB_DHMINTERFACE_GRP dependencies on FEM_DIM_ATTRIBUTES_B

Line 156: FEM_DIM_ATTRIBUTES_B B

152: A.MEMBER_COL,
153: B.ATTRIBUTE_ID,
154: B.ATTRIBUTE_VARCHAR_LABEL
155: from FEM_XDIM_DIMENSIONS A,
156: FEM_DIM_ATTRIBUTES_B B
157: where A.DIMENSION_ID = B.ATTRIBUTE_DIMENSION_ID
158: and B.DIMENSION_ID = 14
159: and B.ATTRIBUTE_VARCHAR_LABEL in
160: ('DEFAULT_AGG_METHOD',

Line 167: from FEM_DIM_ATTRIBUTES_B B

163: cursor l_epb_time_attrs is
164: select distinct
165: B.ATTRIBUTE_ID,
166: B.ATTRIBUTE_VARCHAR_LABEL
167: from FEM_DIM_ATTRIBUTES_B B
168: where B.DIMENSION_ID = 1
169: and B.ATTRIBUTE_VARCHAR_LABEL in
170: ('CAL_PERIOD_END_DATE', 'CAL_PERIOD_START_DATE');
171:

Line 176: from FEM_DIM_ATTRIBUTES_B a,

172: cursor l_epb_dim_attrs is
173: select a.ATTRIBUTE_ID,
174: decode (b.DIMENSION_TYPE_CODE, 'LINE', 'L', to_char(a.DIMENSION_ID))
175: DIMENSION_ID
176: from FEM_DIM_ATTRIBUTES_B a,
177: FEM_XDIM_DIMENSIONS b
178: where a.ATTRIBUTE_DIMENSION_ID = p_dimension_id
179: and a.DIMENSION_ID = b.DIMENSION_ID ;
180: begin

Line 321: FEM_DIM_ATTRIBUTES_B D,

317: select A.VALUE_SET_ID
318: into l_value_set_id
319: from FEM_GLOBAL_VS_COMBO_DEFS A,
320: FEM_LEDGERS_ATTR C,
321: FEM_DIM_ATTRIBUTES_B D,
322: FEM_DIM_ATTR_VERSIONS_B E
323: where A.DIMENSION_ID = p_dimension_id
324: and A.GLOBAL_VS_COMBO_ID = C.DIM_ATTRIBUTE_NUMERIC_MEMBER
325: and D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'

Line 417: from fem_dim_attributes_b

413: --
414: begin
415: select attribute_dimension_id
416: into l_attr_dim_id
417: from fem_dim_attributes_b
418: where attribute_id = l_fem_attr;
419:
420: insert into FEM_DIM_ATTRIBUTES_PRIV
421: (USER_ID,

Line 1801: FEM_DIM_ATTRIBUTES_B C,

1797: select B.NUMBER_ASSIGN_VALUE TIME_LVL_PERIODS
1798: into l_num_periods_in_year
1799: from FEM_DIMENSION_GRPS_B A,
1800: FEM_TIME_GRP_TYPES_ATTR B,
1801: FEM_DIM_ATTRIBUTES_B C,
1802: FEM_DIM_ATTR_VERSIONS_B D
1803: where A.DIMENSION_GROUP_ID = l_level
1804: AND A.TIME_GROUP_TYPE_CODE = B.TIME_GROUP_TYPE_CODE(+)
1805: AND B.ATTRIBUTE_ID = C.ATTRIBUTE_ID(+)

Line 2155: from FEM_DIM_ATTRIBUTES_B C, '||l_dim_mbr_table||' D,

2151: else
2152: l_command := 'select D.'||l_dim_column||', ';
2153: end if;
2154: l_command := l_command||'C.ATTRIBUTE_ID, C.ATTRIBUTE_VARCHAR_LABEL
2155: from FEM_DIM_ATTRIBUTES_B C, '||l_dim_mbr_table||' D,
2156: ZPB_BUSAREA_ATTRIBUTES E, ZPB_BUSAREA_VERSIONS F
2157: where C.DIMENSION_ID = '||p_dimension_id||'
2158: and D.PERSONAL_FLAG = ''Y''
2159: and D.CREATED_BY = '||l_apps_id||'

Line 2233: FEM_DIM_ATTRIBUTES_B C

2229: A.NUMBER_ASSIGN_VALUE,
2230: A.VARCHAR_ASSIGN_VALUE,
2231: A.DATE_ASSIGN_VALUE
2232: from '||l_dim_attr_table||' A, '||l_dim_mbr_table||' B,
2233: FEM_DIM_ATTRIBUTES_B C
2234: where A.'||l_dim_column||' = B.'||l_dim_column||'
2235: and B.PERSONAL_FLAG = ''Y''
2236: and B.CREATED_BY = '||l_apps_id||'
2237: and A.LAST_UPDATE_DATE > '||l_upd_date||'

Line 2294: FEM_DIM_ATTRIBUTES_B B

2290: if (l_attr_label = 'EXTENDED_ACCOUNT_TYPE') then
2291: select A.DIM_ATTRIBUTE_VARCHAR_MEMBER
2292: into l_attr_var_mbr
2293: from FEM_EXT_ACCT_TYPES_ATTR A,
2294: FEM_DIM_ATTRIBUTES_B B
2295: where A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
2296: and B.ATTRIBUTE_VARCHAR_LABEL = 'BASIC_ACCOUNT_TYPE_CODE'
2297: and A.EXT_ACCOUNT_TYPE_CODE = l_attr_var_mbr
2298: and A.AW_SNAPSHOT_FLAG = 'N';