APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_FACTOR_TABLE_DIMS

Line 1897: FROM fem_factor_table_dims

1893:
1894: -- Dimensions referenced by a Factor Table rule.
1895: CURSOR c_dims (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1896: SELECT DISTINCT dimension_id
1897: FROM fem_factor_table_dims
1898: WHERE object_definition_id = p_obj_def_id
1899: AND dimension_id = nvl(p_param_dim_id, dimension_id);
1900:
1901: BEGIN

Line 1951: ||' FROM fem_factor_table_dims D, fem_factor_table_fctrs F'

1947: 'INSERT INTO fem_br_disabled_mbrs_gt(object_definition_id,'
1948: || ' dimension_id, dimension_member, value_set_id, context_code)'
1949: ||' SELECT D.object_definition_id, D.dimension_id, F.dim_member, '
1950: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||''''
1951: ||' FROM fem_factor_table_dims D, fem_factor_table_fctrs F'
1952: ||' WHERE D.object_definition_id = :obj_def_id'
1953: ||' AND D.dimension_id = :dim_id'
1954: ||' AND D.object_definition_id = F.object_definition_id'
1955: ||' AND D.level_num = F.level_num'