APPS.FEM_MIR_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 756: FROM fem_dim_attributes_b

752: );
753:
754: SELECT attribute_varchar_label
755: INTO l_attribute_varchar_label
756: FROM fem_dim_attributes_b
757: WHERE attribute_id=p_attribute_id;
758:
759: FEM_ENGINES_PKG.Tech_Message (
760: p_severity => c_log_level_2

Line 865: fem_dim_attributes_b B

861:
862: SELECT B.attribute_id
863: INTO l_dim_attribute_id
864: FROM fem_dimensions_b A,
865: fem_dim_attributes_b B
866: WHERE a.dimension_varchar_label = p_dimension_varchar_label
867: AND B.dimension_id = A.dimension_id
868: AND B.attribute_varchar_label = p_dim_attribute_varchar_label;
869:

Line 977: FROM fem_dim_attributes_b

973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975: SELECT attribute_id
976: INTO l_dim_attribute_id
977: FROM fem_dim_attributes_b
978: WHERE dimension_id = p_dimension_id
979: AND attribute_varchar_label = p_dim_attribute_varchar_label;
980:
981: FEM_ENGINES_PKG.Tech_Message (

Line 1182: fem_dim_attributes_b B

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 ;
1186:

Line 1292: fem_dim_attributes_b B

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;
1296:

Line 2319: ,fem_dim_attributes_b ATTR

2315:
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

Line 2415: ,fem_dim_attributes_b ATTR

2411:
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