[Home] [Help]
458: -- p_obj_def_id is the rule version of the parent mapping rule.
459: CURSOR c_row_group_info (cv_obj_def_id NUMBER) IS
460: SELECT f.table_name, f.function_cd, f.sub_object_id,
461: m.preview_row_group, m.preview_row_group_display_seq
462: FROM fem_alloc_br_formula f, fem_function_cd_mapping m
463: WHERE f.function_cd = m.function_cd
464: AND f.object_definition_id = cv_obj_def_id
465: AND nvl(f.enable_flg,'Y') = 'Y'
466: ORDER BY m.preview_row_group_process_seq;
621: -- if the same fact table is designated for both credit and debit,
622: -- it does not make sense to write out to separate temp tables.
623: --
624: -- Since we know from
625: -- FEM_FUNCTION_CD_MAPPING.preview_row_group_process_seq
626: -- that DEBIT is processed first, we will only check if CREDIT table
627: -- is the same as the DEBIT table. If there was no DEBIT table,
628: -- then we automatically need to create a CREDIT table.
629: v_create_temp_table := FALSE;
1527: --
1528: -- ASSUMPTION
1529: -- Before this API can be called, the temporary tables for the source
1530: -- and driver tables have to be first created. That is the purpose
1531: -- of the FEM_FUNCTION_CD_MAPPING.PREVIEW_ROW_GROUP_PROCESS_SEQ column.
1532: -- The Pre_Process procedure relies on that column to determine the
1533: -- order in which to create the temporary tables.
1534: --
1535: -------------------------------------------------------------------------------
2480: ELSIF p_map_table_type = G_ACCT_TRANS_TYPE THEN
2481:
2482: SELECT f.column_name
2483: INTO v_amount_column
2484: FROM fem_alloc_br_formula f, fem_function_cd_mapping m
2485: WHERE f.object_definition_id = p_map_obj_def_id
2486: AND f.function_cd = m.function_cd
2487: AND m.preview_row_group = p_preview_row_group;
2488: