APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_COND_DATA_CMP_STEPS

Line 1305: v_sequence FEM_COND_DATA_CMP_STEPS.STEP_SEQUENCE%TYPE;

1301: v_member_table FEM_TAB_COLUMNS_B.TABLE_NAME%TYPE;
1302: v_member_column FEM_TAB_COLUMNS_B.COLUMN_NAME%TYPE;
1303: v_column_name FEM_XDIM_DIMENSIONS.MEMBER_COL%TYPE;
1304: v_table_name FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
1305: v_sequence FEM_COND_DATA_CMP_STEPS.STEP_SEQUENCE%TYPE;
1306: v_criteria_seq FEM_COND_DATA_CMP_ST_DTL.CRITERIA_SEQUENCE%TYPE;
1307: v_value_set_id FEM_GLOBAL_VS_COMBO_DEFS.VALUE_SET_ID%TYPE;
1308: v_dim_id FEM_TAB_COLUMNS_B.DIMENSION_ID%TYPE;
1309: v_value_set_flag VARCHAR2(1);

Line 1322: FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,

1318: -- Note: hier_editor_managed_flag denotes if a dimension is managed by DHM
1319: cursor c_objdef (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1320: SELECT A.column_name, A.table_name, A.step_sequence, B.dimension_id,
1321: D.criteria_sequence
1322: FROM fem_cond_data_cmp_steps A, fem_tab_columns_b B,
1323: fem_cond_data_cmp_st_dtl D, fem_xdim_dimensions X
1324: WHERE A.column_name = B.column_name
1325: AND A.table_name = B.table_name
1326: AND A.cond_data_cmp_obj_def_id = p_obj_def_id