Line 158: * Step 1 - Populate the global temporary table from individual PL/SQL Table
154: BEGIN
155:
156: PA_DEBUG.set_curr_function('summarize_by_period');
157: /* 158: * Step 1 - Populate the global temporary table from individual PL/SQL Table 159: * in bulk.
160: */
161:
162: /*
Line 2802: (select 'T' dummy_col from dual union select 'S' from dual) dummytab
2798: 'II'
2799: from pa_rep_util_summ_tmp tmp,
2800: pa_org_hierarchy_denorm org,
2801: pa_implementations imp, 2802: (select 'T' dummy_col from dual union select 'S' from dual) dummytab 2803: where tmp.summ_level_flag = 'O'
2804: and tmp.record_type = 'TMP2'
2805: -- new line below
2806: and tmp.process_mode_flag = 'II'