DBA Data[Home] [Help]

APPS.FEM_DATA_LOADER_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 637: FROM fem_dim_attributes_b da,

633:
634: BEGIN
635: SELECT da.attribute_id
636: INTO g_cal_period_hier_attr
637: FROM fem_dim_attributes_b da,
638: fem_dim_attr_versions_b dav
639: WHERE da.dimension_id = g_ledger_dim_id
640: AND da.attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID'
641: AND dav.attribute_id = da.attribute_id

Line 680: FROM fem_dim_attributes_b da,

676:
677: BEGIN
678: SELECT da.attribute_id
679: INTO g_start_date_attr
680: FROM fem_dim_attributes_b da,
681: fem_dim_attr_versions_b dav
682: WHERE da.dimension_id = g_cal_period_dim_id
683: AND da.attribute_varchar_label = 'CAL_PERIOD_START_DATE'
684: AND dav.attribute_id = da.attribute_id

Line 704: FROM fem_dim_attributes_b da,

700:
701: BEGIN
702: SELECT da.attribute_id
703: INTO g_end_date_attr
704: FROM fem_dim_attributes_b da,
705: fem_dim_attr_versions_b dav
706: WHERE da.dimension_id = g_cal_period_dim_id
707: AND da.attribute_varchar_label = 'CAL_PERIOD_END_DATE'
708: AND dav.attribute_id = da.attribute_id

Line 745: FROM fem_dim_attributes_b da,

741:
742: BEGIN
743: SELECT da.attribute_id
744: INTO g_dataset_bal_attr
745: FROM fem_dim_attributes_b da,
746: fem_dim_attr_versions_b dav
747: WHERE da.dimension_id = g_dataset_dim_id
748: AND da.attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE'
749: AND dav.attribute_id = da.attribute_id

Line 769: FROM fem_dim_attributes_b da,

765:
766: BEGIN
767: SELECT da.attribute_id
768: INTO g_production_attr
769: FROM fem_dim_attributes_b da,
770: fem_dim_attr_versions_b dav
771: WHERE da.dimension_id = g_dataset_dim_id
772: AND da.attribute_varchar_label = 'PRODUCTION_FLAG'
773: AND dav.attribute_id = da.attribute_id