APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 73: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v

69:
70: select date_assign_value into l_cal_period_end_date from fem_cal_periods_attr
71: where cal_period_id = P_CAL_PERIOD_ID
72: and attribute_id = (
73: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
74: where a.attribute_id = v.attribute_id
75: and a.attribute_varchar_label = 'CAL_PERIOD_END_DATE'
76: and v.default_version_flag = 'Y' );
77:

Line 81: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v

77:
78: select number_assign_value into l_cal_period_number from FEM_CAL_PERIODS_ATTR
79: where cal_period_id = P_CAL_PERIOD_ID
80: and attribute_id = (
81: select a.attribute_id from fem_dim_attributes_b a,fem_dim_attr_versions_b v
82: where a.attribute_id = v.attribute_id
83: and a.attribute_varchar_label = 'GL_PERIOD_NUM'
84: and v.default_version_flag = 'Y' );
85:

Line 93: select a.attribute_id from fem_dim_attributes_b a, fem_dim_attr_versions_b v

89:
90: select dim_attribute_varchar_member into l_ds_balance_type_code from FEM_DATASETS_ATTR
91: where dataset_code = P_DATASET_CODE
92: and attribute_id = (
93: select a.attribute_id from fem_dim_attributes_b a, fem_dim_attr_versions_b v
94: where a.attribute_id = v.attribute_id
95: and attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE'
96: and v.default_version_flag = 'Y');
97: