DBA Data[Home] [Help]

APPS.PA_REP_UTILS_SUMM_PKG dependencies on DUAL

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'