APPS.FEM_SETUP_PKG dependencies on FEM_COLUMN_REQUIREMNT_B

Line 74: FROM fem_column_requiremnt_b fcr,

70: 'USER_DIM9_ID', DECODE(activity_dim_component_flag,'Y','SEGMENT15','UNKNOWN'),
71: 'USER_DIM10_ID', DECODE(activity_dim_component_flag,'Y','SEGMENT16','UNKNOWN'),
72: 'UNKNOWN') act_segment_num,
73: vs_member_vl_object_name vs_name
74: FROM fem_column_requiremnt_b fcr,
75: fem_xdim_dimensions fxd
76: WHERE fcr.dimension_id = fxd.dimension_id
77: AND fcr.activity_dim_component_flag = 'Y'
78: ORDER BY act_segment_num; --Bug#4209065

Line 326: FROM fem_column_requiremnt_b fcr,

322: 'USER_DIM9_ID', DECODE(cost_obj_dim_component_flag,'Y','SEGMENT16','UNKNOWN'),
323: 'USER_DIM10_ID', DECODE(cost_obj_dim_component_flag,'Y','SEGMENT17','UNKNOWN'),
324: 'UNKNOWN') cost_segment_num,
325: vs_member_vl_object_name vs_name
326: FROM fem_column_requiremnt_b fcr,
327: fem_xdim_dimensions fxd
328: WHERE fcr.dimension_id = fxd.dimension_id
329: AND cost_obj_dim_component_flag = 'Y'
330: ORDER BY cost_segment_num; --Bug#4209065

Line 820: FROM fem_column_requiremnt_b comp

816:
817:
818: CURSOR l_inv_act_dim_column_cur IS
819: SELECT comp.column_name
820: FROM fem_column_requiremnt_b comp
821: WHERE comp.activity_dim_component_flag = 'Y'
822: AND NOT EXISTS (
823: SELECT 1
824: FROM fem_tab_column_prop proc

Line 832: FROM fem_column_requiremnt_b comp

828: );
829:
830: CURSOR l_inv_co_dim_column_cur IS
831: SELECT comp.column_name
832: FROM fem_column_requiremnt_b comp
833: WHERE comp.cost_obj_dim_component_flag = 'Y'
834: AND NOT EXISTS (
835: SELECT 1
836: FROM fem_tab_column_prop proc