DBA Data[Home] [Help]

APPS.FEM_DEFCALP_UTIL_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 282: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 322: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 361: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 400: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 439: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 478: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 517: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 556: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 595: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 634: from fem_dim_attributes_b A, fem_dim_attr_versions_b V

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';

Line 904: FROM fem_dim_attributes_b a, fem_dim_attr_versions_b v

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 =

Line 971: FROM fem_cal_periods_attr C, fem_dim_attributes_b A, fem_dim_attr_versions_b V

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