APPS.FEM_DATA_LOADER_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 638: fem_dim_attr_versions_b dav

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
642: AND dav.default_version_flag = 'Y';

Line 681: fem_dim_attr_versions_b dav

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
685: AND dav.default_version_flag = 'Y';

Line 705: fem_dim_attr_versions_b dav

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
709: AND dav.default_version_flag = 'Y';

Line 746: fem_dim_attr_versions_b dav

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
750: AND dav.default_version_flag = 'Y';

Line 770: fem_dim_attr_versions_b dav

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
774: AND dav.default_version_flag = 'Y';