APPS.FEM_DIM_UTILS_PVT dependencies on FEM_DIM_ATTRIBUTES_B

Line 117: from fem_dim_attributes_b

113: -- Cursor to determine if the attribute is read only.
114: --
115: Cursor l_attr_read_only_csr is
116: Select dimension_id, read_only_flag
117: from fem_dim_attributes_b
118: where attribute_id = p_attribute_id;
119:
120: --
121: -- Cursor to determine if the attribute has been used by Groups.

Line 254: from fem_dim_attributes_b

250: -- Cursor to determine if the attribute is read only.
251: --
252: Cursor l_attr_read_only_csr is
253: Select dimension_id, read_only_flag
254: from fem_dim_attributes_b
255: where attribute_id = p_attribute_id;
256:
257: --
258: -- Cursor to determine if the attribute has been used by Groups.

Line 295: (select attribute_varchar_label from fem_dim_attributes_b

291:
292: Cursor l_cond_usage_csr is
293: select 1 from dual where exists(select 1
294: from fem_cond_dim_cmp_dtl where dim_attr_varchar_label =
295: (select attribute_varchar_label from fem_dim_attributes_b
296: where attribute_id = p_attribute_id));
297:
298: --End Bug#4298566
299:

Line 11384: select decode((select 'Y' from FEM_DIM_ATTRIBUTES_B where attribute_id = p_attribute_id and attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and dimension_id in

11380: l_line_nat_dims_flag varchar2(1);
11381:
11382: BEGIN
11383:
11384: select decode((select 'Y' from FEM_DIM_ATTRIBUTES_B where attribute_id = p_attribute_id and attribute_varchar_label = 'EXTENDED_ACCOUNT_TYPE' and dimension_id in
11385: (select dimension_id from fem_dimensions_b where dimension_varchar_label in ('NATURAL_ACCOUNT','LINE_ITEM'))),'Y','Y','N') into
11386: l_line_nat_dims_flag from dual;
11387:
11388: if(l_line_nat_dims_flag = 'Y') then