DBA Data[Home] [Help]

APPS.GCS_UTILITY_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 41: fem_dim_attr_versions_b fdavb

37: BULK COLLECT INTO l_index_dimension_attr_info
38: FROM fem_tab_columns_b ftcb,
39: fem_dim_attributes_b fda,
40: fem_tab_column_prop ftcp,
41: fem_dim_attr_versions_b fdavb
42: WHERE ftcb.table_name = 'FEM_BALANCES'
43: AND ftcb.dimension_id = fda.dimension_id
44: AND ftcp.table_name = 'FEM_BALANCES'
45: AND ftcp.column_property_code = 'PROCESSING_KEY'

Line 74: fem_dim_attr_versions_b fdavb

70: fdavb.version_id
71: BULK COLLECT INTO l_index_dimension_attr_info
72: FROM fem_dim_attributes_b fda,
73: fem_dimensions_b fdb,
74: fem_dim_attr_versions_b fdavb
75: WHERE fdb.dimension_id = fda.dimension_id
76: AND fdavb.attribute_id = fda.attribute_id
77: AND fdavb.default_version_flag = 'Y'
78: AND fdb.dimension_varchar_label IN ('EXTENDED_ACCOUNT_TYPE','COST_CENTER');

Line 290: fem_dim_attr_versions_b fdavb

286: fem_cal_periods_attr fcpa_year,
287: fem_dimension_grps_b fdgb,
288: fem_time_grp_types_attr ftgta,
289: fem_dim_attributes_b feab,
290: fem_dim_attr_versions_b fdavb
291: WHERE fcpb.cal_period_id = p_cal_period_id
292: AND fcpb.dimension_group_id = fdgb.dimension_group_id
293: AND fdgb.time_group_type_code = ftgta.time_group_type_code
294: AND ftgta.attribute_id = feab.attribute_id