APPS.FEM_MIR_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 1081: FROM fem_dim_attr_versions_b

1077: );
1078:
1079: SELECT version_display_code
1080: INTO l_attr_ver_display_code
1081: FROM fem_dim_attr_versions_b
1082: WHERE attribute_id = p_attribute_id
1083: AND version_id = p_version_id;
1084:
1085: FEM_ENGINES_PKG.Tech_Message (

Line 1181: FROM fem_dim_attr_versions_b A,

1177: );
1178:
1179: SELECT a.version_display_code
1180: INTO l_attr_ver_display_code
1181: FROM fem_dim_attr_versions_b A,
1182: fem_dim_attributes_b B
1183: WHERE b.attribute_varchar_label = p_dim_attr_varchar_label
1184: AND a.attribute_id = B.attribute_id
1185: AND a.version_id = p_version_id ;

Line 1291: FROM fem_dim_attr_versions_b A,

1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1288:
1289: SELECT A.version_id
1290: INTO l_dim_attr_version_id
1291: FROM fem_dim_attr_versions_b A,
1292: fem_dim_attributes_b B
1293: WHERE B.attribute_varchar_label = p_dim_attr_varchar_label
1294: AND A.attribute_id = B.attribute_id
1295: AND A.version_display_code = p_dim_attr_ver_display_code;

Line 1404: FROM fem_dim_attr_versions_b

1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: SELECT version_id
1403: INTO l_dim_attr_version_id
1404: FROM fem_dim_attr_versions_b
1405: WHERE attribute_id = p_dim_attribute_id
1406: AND version_display_code = p_dim_attr_ver_display_code;
1407:
1408: FEM_ENGINES_PKG.Tech_Message (

Line 2320: ,fem_dim_attr_versions_b VER

2316: SELECT CALP_ATTR.number_assign_value
2317: INTO l_gl_period_num
2318: FROM fem_cal_periods_attr calp_attr
2319: ,fem_dim_attributes_b ATTR
2320: ,fem_dim_attr_versions_b VER
2321: ,fem_xdim_dimensions_vl XDIM
2322: WHERE XDIM.dimension_varchar_label = 'CAL_PERIOD'
2323: AND ATTR.dimension_id = XDIM.dimension_id
2324: AND ATTR.attribute_varchar_label = 'GL_PERIOD_NUM'

Line 2416: ,fem_dim_attr_versions_b VER

2412: SELECT CALP_ATTR.date_assign_value
2413: INTO l_cal_period_end_date
2414: FROM fem_cal_periods_attr calp_attr
2415: ,fem_dim_attributes_b ATTR
2416: ,fem_dim_attr_versions_b VER
2417: ,fem_xdim_dimensions_vl XDIM
2418: WHERE XDIM.dimension_varchar_label = 'CAL_PERIOD'
2419: AND ATTR.dimension_id = XDIM.dimension_id
2420: AND ATTR.attribute_varchar_label = 'CAL_PERIOD_END_DATE'