[Home] [Help]
198:
199:
200: select dimension_group_id
201: into v_dimension_group_id
202: from fem_dimension_grps_b
203: where dimension_group_display_code = 'Year'
204: and dimension_id=1;
205:
206: select dimension_group_id
204: and dimension_id=1;
205:
206: select dimension_group_id
207: into v_month_dimgrp_id
208: from fem_dimension_grps_b
209: where dimension_group_display_code = 'Month'
210: and dimension_id=1;
211:
212: select dimension_group_id
210: and dimension_id=1;
211:
212: select dimension_group_id
213: into v_qtr_dimgrp_id
214: from fem_dimension_grps_b
215: where dimension_group_display_code = 'Quarter'
216: and dimension_id=1;
217:
218: select to_number(to_char(sysdate,'YYYY'))