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 2803: (select 'T' dummy_col from dual union select 'S' from dual) dummytab

2799: 'II'
2800: from pa_rep_util_summ_tmp tmp,
2801: pa_org_hierarchy_denorm org,
2802: pa_implementations imp,
2803: (select 'T' dummy_col from dual union select 'S' from dual) dummytab
2804: where tmp.summ_level_flag = 'O'
2805: and tmp.record_type = 'TMP2'
2806: -- new line below
2807: and tmp.process_mode_flag = 'II'