DBA Data[Home] [Help]

APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_STAT_LOOKUP_REL

Line 1469: FROM fem_stat_lookups A, fem_stat_lookup_rel B, fem_tab_columns_b C,

1465: --object definition id. This ensures that each is checked for
1466: --disabled members.
1467: cursor c_objdef (p_obj_def_id IN NUMBER, p_param_dim_id IN NUMBER) IS
1468: SELECT C.column_name, C.table_name, C.dimension_id
1469: FROM fem_stat_lookups A, fem_stat_lookup_rel B, fem_tab_columns_b C,
1470: fem_xdim_dimensions X
1471: WHERE A.stat_lookup_obj_def_id = p_obj_def_id
1472: AND A.stat_lookup_obj_def_id = B.stat_lookup_obj_def_id
1473: AND A.stat_lookup_table = C.table_name

Line 1534: ''' FROM FEM_STAT_LOOKUP_REL

1530: 'INSERT INTO fem_br_disabled_mbrs_gt (object_definition_id,
1531: dimension_id, dimension_member, value_set_id, context_code)
1532: SELECT ' || p_obj_def_id || ',' || v_dim_id || ', value, '
1533: || nvl(to_char(v_value_set_id), 'NULL') || ', ''' || C_CONTEXT ||
1534: ''' FROM FEM_STAT_LOOKUP_REL
1535: WHERE stat_lookup_obj_def_id = :obj_def_id
1536: AND stat_lookup_tbl_col = :column_name
1537: AND value IN
1538: (SELECT to_char(' || v_member_column ||