APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_XDIM_DIMENSIONS

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 501: ,FEM_XDIM_DIMENSIONS x

497: ,x.member_display_code_col
498: ,x.member_b_table_name
499: ,x.value_set_required_flag
500: FROM FEM_COLUMN_REQUIREMNT_B c
501: ,FEM_XDIM_DIMENSIONS x
502: WHERE c.dimension_id = x.dimension_id
503: AND c.cost_obj_dim_component_flag = 'Y'
504: ORDER BY 1 )
505: LOOP

Line 597: ,FEM_XDIM_DIMENSIONS x

593: ,x.member_display_code_col
594: ,x.member_b_table_name
595: ,x.value_set_required_flag
596: FROM FEM_COLUMN_REQUIREMNT_B c
597: ,FEM_XDIM_DIMENSIONS x
598: WHERE c.dimension_id = x.dimension_id
599: AND c.activity_dim_component_flag = 'Y'
600: ORDER BY 1 )
601: LOOP

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