278: ,sysdate
279: ,null
280: ,1
281: ,'N'
282: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
283: where A.attribute_Varchar_label = 'RECON_LEAF_NODE_FLAG'
284: and A.attribute_id = V.attribute_id
285: and A.dimension_id = 1
286: and V.default_version_flag = 'Y';
318: ,sysdate
319: ,null
320: ,1
321: ,'N'
322: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
323: where A.attribute_Varchar_label = 'ADJ_PERIOD_FLAG'
324: and A.attribute_id = V.attribute_id
325: and A.dimension_id = 1
326: and V.default_version_flag = 'Y';
357: ,sysdate
358: ,null
359: ,1
360: ,'N'
361: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
362: where A.attribute_Varchar_label = 'GL_ORIGIN_FLAG'
363: and A.attribute_id = V.attribute_id
364: and A.dimension_id = 1
365: and V.default_version_flag = 'Y';
396: ,sysdate
397: ,null
398: ,1
399: ,'N'
400: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
401: where A.attribute_Varchar_label = 'CUR_PERIOD_FLAG'
402: and A.attribute_id = V.attribute_id
403: and A.dimension_id = 1
404: and V.default_version_flag = 'Y';
435: ,sysdate
436: ,null
437: ,1
438: ,'N'
439: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
440: where A.attribute_Varchar_label = 'ACCOUNTING_YEAR'
441: and A.attribute_id = V.attribute_id
442: and A.dimension_id = 1
443: and V.default_version_flag = 'Y';
474: ,sysdate
475: ,null
476: ,1
477: ,'N'
478: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
479: where A.attribute_Varchar_label = 'CAL_PERIOD_START_DATE'
480: and A.attribute_id = V.attribute_id
481: and A.dimension_id = 1
482: and V.default_version_flag = 'Y';
513: ,sysdate
514: ,null
515: ,1
516: ,'N'
517: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
518: where A.attribute_Varchar_label = 'CAL_PERIOD_END_DATE'
519: and A.attribute_id = V.attribute_id
520: and A.dimension_id = 1
521: and V.default_version_flag = 'Y';
552: ,sysdate
553: ,null
554: ,1
555: ,'N'
556: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
557: where A.attribute_Varchar_label = 'GL_PERIOD_NUM'
558: and A.attribute_id = V.attribute_id
559: and A.dimension_id = 1
560: and V.default_version_flag = 'Y';
591: ,sysdate
592: ,null
593: ,1
594: ,'N'
595: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
596: where A.attribute_Varchar_label = 'SOURCE_SYSTEM_CODE'
597: and A.attribute_id = V.attribute_id
598: and A.dimension_id = 1
599: and V.default_version_flag = 'Y';
630: ,sysdate
631: ,null
632: ,1
633: ,'N'
634: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
635: where A.attribute_Varchar_label = 'CAL_PERIOD_PREFIX'
636: and A.attribute_id = V.attribute_id
637: and A.dimension_id = 1
638: and V.default_version_flag = 'Y';
900: IF v_ledger_id IS NULL THEN
901: -- First find attrib and version id for CAL_PERIOD_HIER_OBJ_DEF_ID attrib
902: SELECT a.attribute_id, v.version_id
903: INTO v_cal_hier_attribute_id, v_cal_hier_version_id
904: FROM fem_dim_attributes_b a, fem_dim_attr_versions_b v
905: WHERE a.attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID'
906: AND v.attribute_id = a.attribute_id
907: AND v.default_version_flag = 'Y'
908: AND a.dimension_id =
967: -- accounting year of the BUDGET_LAST_PERIOD.
968: IF v_accounting_year IS NULL THEN
969: SELECT C.number_assign_value
970: INTO v_accounting_year
971: FROM fem_cal_periods_attr C, fem_dim_attributes_b A, fem_dim_attr_versions_b V
972: WHERE C.cal_period_id = v_cal_period_id
973: AND A.attribute_varchar_label = 'ACCOUNTING_YEAR'
974: AND C.attribute_id = V.attribute_id
975: AND C.version_id = V.version_id