185:
186:
187: SELECT DATE_ASSIGN_VALUE
188: INTO g_period_start_date
189: FROM fem_cal_periods_attr fcpa
190: WHERE fcpa.cal_period_id = p_cal_period_id
191: AND fcpa.attribute_id =
192: g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').attribute_id
193: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').version_id;
193: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_START_DATE').version_id;
194:
195: SELECT DATE_ASSIGN_VALUE
196: INTO g_period_end_date
197: FROM fem_cal_periods_attr fcpa
198: WHERE fcpa.cal_period_id = p_cal_period_id
199: AND fcpa.attribute_id =
200: g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').attribute_id
201: AND fcpa.version_id = g_dimension_attr_info ('CAL_PERIOD_ID-CAL_PERIOD_END_DATE').version_id;