[Home] [Help]
673: from fem_cal_periods_b cp
674: ,fem_cal_periods_attr cpa_adj
675: ,fem_cal_periods_b cp2
676: ,fem_cal_periods_attr cpa2_adj
677: ,fem_dimensions_b dim
678: ,fem_dim_attributes_b a
679: ,fem_dim_attr_versions_b v
680: where cp.cal_period_id = p_cal_period_id
681: and dim.dimension_varchar_label = 'CAL_PERIOD'
752: ,fem_cal_periods_b cp2
753: ,fem_cal_periods_attr cpa2_adj
754: ,fem_cal_periods_attr cpa2_start
755: ,fem_cal_periods_attr cpa2_end
756: ,fem_dimensions_b dim
757: ,fem_dim_attributes_b a_adj
758: ,fem_dim_attr_versions_b v_adj
759: ,fem_dim_attributes_b a_start
760: ,fem_dim_attr_versions_b v_start
2045: ,a.attribute_dimension_id
2046: ,dim.dimension_varchar_label as attr_dimension_varchar_label
2047: from fem_dim_attributes_b a
2048: ,fem_dim_attr_versions_b v
2049: ,fem_dimensions_b dim
2050: where a.dimension_id = p_dimension_id
2051: and a.personal_flag = 'N'
2052: and a.queryable_for_reporting_flag = 'Y'
2053: and a.allow_multiple_assignment_flag = 'N'
2358: ,version_display_code fem_dim_attr_versions_b.version_display_code%type
2359: ,attribute_data_type_code fem_dim_attributes_b.attribute_data_type_code%type
2360: ,attribute_value_column_name fem_dim_attributes_b.attribute_value_column_name%type
2361: ,attribute_dimension_id fem_dim_attributes_b.attribute_dimension_id%type
2362: ,attr_dimension_varchar_label fem_dimensions_b.dimension_varchar_label%type
2363: );
2364:
2365: type attribute_table is table of attribute_record
2366: index by binary_integer;
2450: ' ,a.attribute_dimension_id'||
2451: ' ,dim.dimension_varchar_label as attr_dimension_varchar_label'||
2452: ' from fem_dim_attributes_b@'||p_seed_db_link||' a'||
2453: ' ,fem_dim_attr_versions_b@'||p_seed_db_link||' v'||
2454: ' ,fem_dimensions_b@'||p_seed_db_link||' dim'||
2455: ' where a.dimension_id = :b_dimension_id'||
2456: ' and a.personal_flag = ''N'''||
2457: ' and a.queryable_for_reporting_flag = ''Y'''||
2458: ' and a.allow_multiple_assignment_flag = ''N'''||