APPS.ZPB_BUSAREA_MAINT dependencies on FEM_DIM_ATTRIBUTES_B

Line 177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;

173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
174: l_def_mbr_code FEM_XDIM_DIMENSIONS.DEFAULT_MEMBER_DISPLAY_CODE%type;
175: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
176: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
177: l_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
178: l_is_line ZPB_BUSAREA_DIMENSIONS.EPB_LINE_DIMENSION%type;
179: l_hier NUMBER;
180: l_count NUMBER;
181: l_command VARCHAR2(2000);

Line 231: FEM_DIM_ATTRIBUTES_B D,

227: into l_def_hier
228: from FEM_GLOBAL_VS_COMBO_DEFS A,
229: FEM_VALUE_SETS_VL B,
230: FEM_LEDGERS_ATTR C,
231: FEM_DIM_ATTRIBUTES_B D,
232: FEM_DIM_ATTR_VERSIONS_B E
233: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
234: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
235: and E.DEFAULT_VERSION_FLAG = 'Y'

Line 264: from '||l_attr_table||' A, FEM_DIM_ATTRIBUTES_B B,

260: where A.DIMENSION_ID = B.DIMENSION_ID
261: and B.DIMENSION_VARCHAR_LABEL = 'CALENDAR';
262:
263: l_command := 'select A.DIM_ATTRIBUTE_NUMERIC_MEMBER
264: from '||l_attr_table||' A, FEM_DIM_ATTRIBUTES_B B,
265: FEM_DIM_ATTR_VERSIONS_B C, '||l_dim_table||' D
266: where A.'||l_cal_dim_col||' = D.'||l_cal_dim_col||'
267: and D.'||l_cal_dim_code||' = '''||l_def_mbr_code||'''
268: and A.ATTRIBUTE_ID = B.ATTRIBUTE_ID