APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_XDIM_DIMENSIONS_VL

Line 446: FROM Fem_Xdim_Dimensions_VL

442: BEGIN
443:
444: SELECT dimension_active_flag
445: INTO l_dim_active_flag
446: FROM Fem_Xdim_Dimensions_VL
447: WHERE dimension_varchar_label = p_dimension_varchar_label;
448:
449: EXCEPTION
450:

Line 2149: FROM Fem_Xdim_Dimensions_VL

2145: EXCEPTION
2146: WHEN no_data_found THEN
2147: BEGIN
2148: SELECT default_member_display_code INTO t_uom_code(j)
2149: FROM Fem_Xdim_Dimensions_VL
2150: WHERE dimension_varchar_label = 'UOM';
2151:
2152: IF t_uom_code(j) IS NULL THEN
2153: t_status(j) := 'INVALID_COST_OBJ_DEFAULT_UOM' ;

Line 2161: FROM Fem_Xdim_Dimensions_VL

2157:
2158: ELSE -- prodcut dimension is not a component dimension or invalid members
2159:
2160: SELECT default_member_display_code INTO t_uom_code(j)
2161: FROM Fem_Xdim_Dimensions_VL
2162: WHERE dimension_varchar_label = 'UOM';
2163:
2164: IF t_uom_code(j) IS NULL THEN
2165: IF t_status(j) = 'LOAD' THEN