[Home] [Help]
149: SELECT fod.object_definition_id
150: INTO l_hierarchy_obj_def_id
151: FROM fem_xdim_dimensions fxd,
152: fem_object_definition_b fod,
153: fem_cal_periods_attr fcpa
154: WHERE fxd.dimension_id = gcs_utility_pkg.g_gcs_dimension_info (l_index_column_name).dimension_id
155: AND fxd.default_mvs_hierarchy_obj_id = fod.object_id
156: AND fcpa.cal_period_id = p_cal_period_id
157: AND fcpa.attribute_id = l_cal_attribute_id
658: BEGIN
659: SELECT gea.source_system_code
660: INTO l_source_system_code
661: FROM gcs_entities_attr gea,
662: fem_cal_periods_attr fcpa
663: WHERE gea.entity_id = p_entity_id
664: AND gea.data_type_code = p_balance_type_code
665: AND fcpa.cal_period_id = p_target_cal_period_id
666: AND fcpa.attribute_id = l_period_end_date_attr