eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FP_AGGR_PJP1

Line 139: INSERT /+ parallel(pjp1) / INTO PJI_FP_AGGR_PJP1 pjp1

135: BEGIN
136:
137: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
138:
139: INSERT /*+ parallel(pjp1) */ INTO PJI_FP_AGGR_PJP1 pjp1
140: (
141: WORKER_ID
142: , PRG_LEVEL
143: , PROJECT_ID

Line 306: PJI_FP_AGGR_PJP1 fact1

302: , SUM(CUSTOM15)
303: , 'ENTR'
304: , PLAN_TYPE_CODE
305: FROM
306: PJI_FP_AGGR_PJP1 fact1
307: , pji_time_ENT_PERIOD period
308: , pji_time_ENT_QTR qtr
309: WHERE
310: fact1.calendar_type = 'E'

Line 353: INSERT /+ parallel(pjp1) / INTO pji_fp_aggr_pjp1 pjp1

349: BEGIN
350:
351: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
352:
353: INSERT /*+ parallel(pjp1) */ INTO pji_fp_aggr_pjp1 pjp1
354: (
355: WORKER_ID
356: , PRG_LEVEL
357: , PROJECT_ID

Line 520: pji_fp_aggr_pjp1 fact1

516: , SUM(CUSTOM15) CUSTOM15
517: , l_line_type line_type
518: , fact1.plan_type_code plan_type_code
519: FROM
520: pji_fp_aggr_pjp1 fact1
521: , pji_time_CAL_PERIOD period
522: , pji_time_CAL_QTR qtr
523: WHERE
524: fact1.calendar_type = 'P'

Line 613: ,p_tabname => 'PJI_FP_AGGR_PJP1'

609: ,p_partname => 'P'||g_worker_id
610: ,p_percent => 10);
611:
612: GATHER_TEMP_STATS(p_ownname => l_pji_schema
613: ,p_tabname => 'PJI_FP_AGGR_PJP1'
614: ,p_partname => 'P'||g_worker_id
615: ,p_percent => 10);
616:
617: GATHER_TEMP_STATS(p_ownname => l_pji_schema

Line 662: INSERT /+ parallel(pjp1) / INTO pji_fp_aggr_pjp1 pjp1

658:
659: END IF;
660: /* Added for Bug 13813361 End */
661:
662: INSERT /*+ parallel(pjp1) */ INTO pji_fp_aggr_pjp1 pjp1
663: (
664: WORKER_ID
665: , PRG_LEVEL
666: , PROJECT_ID

Line 829: pji_fp_aggr_pjp1 fact1

825: , SUM(CUSTOM15) CUSTOM15
826: , l_line_type
827: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
828: FROM
829: pji_fp_aggr_pjp1 fact1
830: , pji_time_CAL_PERIOD period
831: , pji_time_CAL_QTR qtr
832: WHERE
833: fact1.calendar_type = l_calendar_type

Line 895: INSERT /+ parallel(PJP1) / INTO PJI_FP_AGGR_PJP1 PJP1

891: INTO l_plan_type_id
892: FROM PA_FIN_PLAN_TYPES_B
893: WHERE USE_FOR_WORKPLAN_FLAG='Y';
894:
895: INSERT /*+ parallel(PJP1) */ INTO PJI_FP_AGGR_PJP1 PJP1
896: (
897: WORKER_ID
898: , PRG_LEVEL
899: , PROJECT_ID

Line 1062: PJI_FP_AGGR_PJP1 fact1

1058: , SUM(CUSTOM15) CUSTOM15
1059: ,l_line_type
1060: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
1061: FROM
1062: PJI_FP_AGGR_PJP1 fact1
1063: , pji_time_CAL_PERIOD period
1064: , pji_time_CAL_QTR qtr
1065: , pji_fm_extr_plnver4 ver
1066: WHERE

Line 1115: INSERT INTO pji_fp_aggr_pjp1

1111: BEGIN
1112:
1113: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1114:
1115: INSERT INTO pji_fp_aggr_pjp1
1116: (
1117: WORKER_ID
1118: , PROJECT_ID
1119: , PROJECT_ORG_ID

Line 1348: FROM pji_fp_aggr_pjp1 fact

1344: , (LEAST(non_pa_cal.end_date,pa_cal.end_date) -
1345: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
1346: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
1347: , fact.plan_type_code plan_type_code
1348: FROM pji_fp_aggr_pjp1 fact
1349: , pji_time_cal_period_v non_pa_cal
1350: , pji_time_ent_period_v pa_cal
1351: , pji_fm_extr_plnver4 ver
1352: , (SELECT currency_code,

Line 1410: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.

1406: BEGIN
1407:
1408: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1409:
1410: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries in pjp1 table.
1411: (
1412: WORKER_ID
1413: , PROJECT_ID
1414: , PROJECT_ORG_ID

Line 1642: FROM pji_fp_aggr_pjp1 fact

1638: , cur.mau mau
1639: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
1640: / (fact.end_date - fact.start_date+1) factor
1641: , fact.plan_type_code plan_type_code
1642: FROM pji_fp_aggr_pjp1 fact
1643: , pji_time_ent_period_v entCal
1644: , pji_fm_extr_plnver4 ver
1645: , (SELECT currency_code,
1646: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),

Line 1705: INSERT INTO pji_fp_aggr_pjp1

1701: BEGIN
1702:
1703: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1704:
1705: INSERT INTO pji_fp_aggr_pjp1
1706: (
1707: worker_id
1708: , PROJECT_ID
1709: , PROJECT_ORG_ID

Line 1934: FROM pji_fp_aggr_pjp1 fact,

1930: , ROUND (nvl(fact.custom15,0)*calDet.factor/cur.mau)*cur.mau custom15
1931: , fact.time_dangling_flag time_dangling_flag
1932: , fact.rate_dangling_flag rate_dangling_flag
1933: , fact.plan_type_code plan_type_code
1934: FROM pji_fp_aggr_pjp1 fact,
1935: (SELECT /*+ NO_MERGE LEADING (orginfo sec pri ppa ver) USE_HASH(ver) parallel(ver) */
1936: (LEAST(pri.end_date,sec.end_date) - Greatest(pri.start_date,sec.start_date)+1)
1937: / (pri.end_date - pri.start_date+1) factor,
1938: ppa.project_id,

Line 2024: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..

2020: END IF;
2021:
2022: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2023:
2024: INSERT INTO pji_fp_aggr_pjp1 -- Non time phased entries..
2025: (
2026: worker_id
2027: , PROJECT_ID
2028: , PROJECT_ORG_ID

Line 2257: FROM pji_fp_aggr_pjp1 fact

2253: , cur.mau mau
2254: , (LEAST(fact.end_date,pa_cal.end_date) - Greatest(fact.start_date,pa_cal.start_date)+1)
2255: / (fact.end_date - fact.start_date+1) factor
2256: , fact.plan_type_code plan_type_code
2257: FROM pji_fp_aggr_pjp1 fact
2258: , pji_org_extr_info orginfo
2259: , pji_time_cal_period_v pa_cal
2260: , pji_fm_extr_plnver4 ver
2261: ,(SELECT currency_code,

Line 2502: pji_fp_aggr_pjp1 pjp1

2498: , pjp1.CUSTOM14
2499: , pjp1.CUSTOM15
2500: , pjp1.PLAN_TYPE_CODE
2501: FROM
2502: pji_fp_aggr_pjp1 pjp1
2503: WHERE 1=1
2504: AND worker_id = g_worker_id;
2505:
2506: /* Added for Bug 13813361 Start */

Line 3004: delete from pji_fp_aggr_pjp1_t; -- 5309891

3000:
3001: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3002:
3003: commit;
3004: delete from pji_fp_aggr_pjp1_t; -- 5309891
3005:
3006: commit;
3007: INSERT INTO pji_fp_aggr_pjp1_t
3008: ( WORKER_ID

Line 3007: INSERT INTO pji_fp_aggr_pjp1_t

3003: commit;
3004: delete from pji_fp_aggr_pjp1_t; -- 5309891
3005:
3006: commit;
3007: INSERT INTO pji_fp_aggr_pjp1_t
3008: ( WORKER_ID
3009: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID
3010: , TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL
3011: , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG , CURR_RECORD_TYPE_ID ,CURRENCY_CODE

Line 3023: FROM PJI_FP_AGGR_PJP1 pjp1

3019: , whdr.plan_version_id, NVL(whdr.plan_type_id, -1)
3020: , whdr.PLAN_TYPE_CODE
3021: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
3022: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
3023: FROM PJI_FP_AGGR_PJP1 pjp1
3024: , pji_time_cal_period_v cal
3025: , pji_pjp_wbs_header whdr
3026: WHERE
3027: pjp1.worker_id = g_worker_id

Line 3050: FROM pji_fp_aggr_pjp1_t dates

3046: , end_date
3047: , l_last_update_date
3048: , l_last_updated_by
3049: , l_last_update_login
3050: FROM pji_fp_aggr_pjp1_t dates
3051: WHERE
3052: dates.plan_version_id = whdr.plan_version_id
3053: AND dates.project_id = whdr.project_id
3054: AND dates.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 3059: FROM PJI_FP_AGGR_PJP1_T ver

3055: AND dates.plan_type_code = whdr.plan_type_code
3056: )
3057: WHERE (project_id, NVL(plan_type_id, -1), plan_version_id, plan_type_code) IN (
3058: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
3059: FROM PJI_FP_AGGR_PJP1_T ver
3060: );
3061: commit;
3062: delete from pji_fp_aggr_pjp1_t;
3063: commit;

Line 3062: delete from pji_fp_aggr_pjp1_t;

3058: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
3059: FROM PJI_FP_AGGR_PJP1_T ver
3060: );
3061: commit;
3062: delete from pji_fp_aggr_pjp1_t;
3063: commit;
3064:
3065: EXCEPTION
3066: WHEN OTHERS THEN

Line 3085: INSERT INTO PJI_FP_AGGR_PJP1

3081: , x_global2_currency_code => g_global2_currency_code
3082: , x_global1_currency_mau => g_global1_currency_mau
3083: , x_global2_currency_mau => g_global2_currency_mau ) ;
3084:
3085: INSERT INTO PJI_FP_AGGR_PJP1
3086: (
3087: WORKER_ID
3088: , PROJECT_ID
3089: , PROJECT_ORG_ID

Line 4193: INSERT INTO PJI_FP_AGGR_PJP1

4189: BEGIN
4190:
4191: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4192:
4193: INSERT INTO PJI_FP_AGGR_PJP1
4194: (
4195: WORKER_ID
4196: , PROJECT_ID
4197: , PROJECT_ORG_ID

Line 4406: FROM PJI_FP_AGGR_PJP1 pjp1

4402: , NVL(pjp1.plan_type_id, -1) plan_type_id
4403: , pjp1.PLAN_TYPE_CODE
4404: , MIN(cal.start_date) min_txn_date
4405: , MAX(cal.end_date) max_txn_date
4406: FROM PJI_FP_AGGR_PJP1 pjp1
4407: , pji_time_cal_period_v cal
4408: WHERE
4409: pjp1.worker_id = g_worker_id
4410: AND pjp1.time_id = cal.cal_period_id

Line 5723: insert /+ append parallel(pjp1_i) / into PJI_FP_AGGR_PJP1 pjp1_i

5719:
5720: end if; -- Partial Refresh Performance Improvement
5721:
5722:
5723: insert /*+ append parallel(pjp1_i) */ into PJI_FP_AGGR_PJP1 pjp1_i
5724: (
5725: WORKER_ID,
5726: RECORD_TYPE,
5727: PRG_LEVEL,

Line 6524: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_FP_AGGR_PJP1','NORMAL','P'||g_worker_id);

6520:
6521: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
6522:
6523: /* Added for bug 13897252 */
6524: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_FP_AGGR_PJP1','NORMAL','P'||g_worker_id);
6525:
6526: IF (l_extraction_type IN ('PARTIAL', 'RBS', 'INCREMENTAL', 'FULL')) THEN
6527:
6528: /* Commented for bug 13897252 */

Line 6530: -- from PJI_FP_AGGR_PJP1 pjp1

6526: IF (l_extraction_type IN ('PARTIAL', 'RBS', 'INCREMENTAL', 'FULL')) THEN
6527:
6528: /* Commented for bug 13897252 */
6529: -- delete /*+ PARALLEL(pjp1) */
6530: -- from PJI_FP_AGGR_PJP1 pjp1
6531: -- where pjp1.WORKER_ID = p_worker_id and
6532: -- nvl(pjp1.LINE_TYPE, 'X') <> 'AGGR_PLAN';
6533:
6534: delete /*+ PARALLEL(pjp1) */

Line 6767: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

6763: OUTLINE(@"SEL$30")
6764: OUTLINE(@"SEL$2")
6765: OUTLINE(@"SEL$1")
6766: OUTLINE(@"INS$1")
6767: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
6768: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
6769: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
6770: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
6771: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 6850: /+ parallel(PJI_FP_AGGR_PJP1) /

6846: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
6847: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
6848: END_OUTLINE_DATA
6849: */
6850: /*+ parallel(PJI_FP_AGGR_PJP1) */
6851: into PJI_FP_AGGR_PJP1 partition(P1)
6852: (
6853: WORKER_ID,
6854: RECORD_TYPE,

Line 6851: into PJI_FP_AGGR_PJP1 partition(P1)

6847: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
6848: END_OUTLINE_DATA
6849: */
6850: /*+ parallel(PJI_FP_AGGR_PJP1) */
6851: into PJI_FP_AGGR_PJP1 partition(P1)
6852: (
6853: WORKER_ID,
6854: RECORD_TYPE,
6855: PRG_LEVEL,

Line 7636: PJI_FP_AGGR_PJP1 pjp1,

7632: pjp1.CUSTOM13,
7633: pjp1.CUSTOM14,
7634: pjp1.CUSTOM15
7635: from
7636: PJI_FP_AGGR_PJP1 pjp1,
7637: PJI_PJP_WBS_HEADER wbs_hdr,
7638: PA_XBS_DENORM wbs,
7639: PJI_XBS_DENORM prg,
7640: (

Line 7790: PJI_FP_AGGR_PJP1 pjp1,

7786: pjp1.CUSTOM13,
7787: pjp1.CUSTOM14,
7788: pjp1.CUSTOM15
7789: from
7790: PJI_FP_AGGR_PJP1 pjp1,
7791: PJI_PJP_WBS_HEADER wbs_hdr,
7792: PJI_XBS_DENORM prg,
7793: (
7794: select 'Y' CB_FLAG,

Line 8261: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

8257: OUTLINE(@"SEL$30")
8258: OUTLINE(@"SEL$2")
8259: OUTLINE(@"SEL$1")
8260: OUTLINE(@"INS$1")
8261: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
8262: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
8263: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
8264: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
8265: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 8344: /+ parallel(PJI_FP_AGGR_PJP1) /

8340: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
8341: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
8342: END_OUTLINE_DATA
8343: */
8344: /*+ parallel(PJI_FP_AGGR_PJP1) */
8345: into PJI_FP_AGGR_PJP1 partition(P2)
8346: (
8347: WORKER_ID,
8348: RECORD_TYPE,

Line 8345: into PJI_FP_AGGR_PJP1 partition(P2)

8341: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
8342: END_OUTLINE_DATA
8343: */
8344: /*+ parallel(PJI_FP_AGGR_PJP1) */
8345: into PJI_FP_AGGR_PJP1 partition(P2)
8346: (
8347: WORKER_ID,
8348: RECORD_TYPE,
8349: PRG_LEVEL,

Line 9130: PJI_FP_AGGR_PJP1 pjp1,

9126: pjp1.CUSTOM13,
9127: pjp1.CUSTOM14,
9128: pjp1.CUSTOM15
9129: from
9130: PJI_FP_AGGR_PJP1 pjp1,
9131: PJI_PJP_WBS_HEADER wbs_hdr,
9132: PA_XBS_DENORM wbs,
9133: PJI_XBS_DENORM prg,
9134: (

Line 9284: PJI_FP_AGGR_PJP1 pjp1,

9280: pjp1.CUSTOM13,
9281: pjp1.CUSTOM14,
9282: pjp1.CUSTOM15
9283: from
9284: PJI_FP_AGGR_PJP1 pjp1,
9285: PJI_PJP_WBS_HEADER wbs_hdr,
9286: PJI_XBS_DENORM prg,
9287: (
9288: select 'Y' CB_FLAG,

Line 9755: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

9751: OUTLINE(@"SEL$30")
9752: OUTLINE(@"SEL$2")
9753: OUTLINE(@"SEL$1")
9754: OUTLINE(@"INS$1")
9755: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
9756: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
9757: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
9758: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
9759: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 9838: /+ parallel(PJI_FP_AGGR_PJP1) /

9834: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
9835: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
9836: END_OUTLINE_DATA
9837: */
9838: /*+ parallel(PJI_FP_AGGR_PJP1) */
9839: into PJI_FP_AGGR_PJP1 partition(P3)
9840: (
9841: WORKER_ID,
9842: RECORD_TYPE,

Line 9839: into PJI_FP_AGGR_PJP1 partition(P3)

9835: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
9836: END_OUTLINE_DATA
9837: */
9838: /*+ parallel(PJI_FP_AGGR_PJP1) */
9839: into PJI_FP_AGGR_PJP1 partition(P3)
9840: (
9841: WORKER_ID,
9842: RECORD_TYPE,
9843: PRG_LEVEL,

Line 10624: PJI_FP_AGGR_PJP1 pjp1,

10620: pjp1.CUSTOM13,
10621: pjp1.CUSTOM14,
10622: pjp1.CUSTOM15
10623: from
10624: PJI_FP_AGGR_PJP1 pjp1,
10625: PJI_PJP_WBS_HEADER wbs_hdr,
10626: PA_XBS_DENORM wbs,
10627: PJI_XBS_DENORM prg,
10628: (

Line 10778: PJI_FP_AGGR_PJP1 pjp1,

10774: pjp1.CUSTOM13,
10775: pjp1.CUSTOM14,
10776: pjp1.CUSTOM15
10777: from
10778: PJI_FP_AGGR_PJP1 pjp1,
10779: PJI_PJP_WBS_HEADER wbs_hdr,
10780: PJI_XBS_DENORM prg,
10781: (
10782: select 'Y' CB_FLAG,

Line 11248: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

11244: OUTLINE(@"SEL$30")
11245: OUTLINE(@"SEL$2")
11246: OUTLINE(@"SEL$1")
11247: OUTLINE(@"INS$1")
11248: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
11249: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
11250: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
11251: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
11252: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 11331: /+ parallel(PJI_FP_AGGR_PJP1) /

11327: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
11328: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
11329: END_OUTLINE_DATA
11330: */
11331: /*+ parallel(PJI_FP_AGGR_PJP1) */
11332: into PJI_FP_AGGR_PJP1 partition(P4)
11333: (
11334: WORKER_ID,
11335: RECORD_TYPE,

Line 11332: into PJI_FP_AGGR_PJP1 partition(P4)

11328: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
11329: END_OUTLINE_DATA
11330: */
11331: /*+ parallel(PJI_FP_AGGR_PJP1) */
11332: into PJI_FP_AGGR_PJP1 partition(P4)
11333: (
11334: WORKER_ID,
11335: RECORD_TYPE,
11336: PRG_LEVEL,

Line 12117: PJI_FP_AGGR_PJP1 pjp1,

12113: pjp1.CUSTOM13,
12114: pjp1.CUSTOM14,
12115: pjp1.CUSTOM15
12116: from
12117: PJI_FP_AGGR_PJP1 pjp1,
12118: PJI_PJP_WBS_HEADER wbs_hdr,
12119: PA_XBS_DENORM wbs,
12120: PJI_XBS_DENORM prg,
12121: (

Line 12271: PJI_FP_AGGR_PJP1 pjp1,

12267: pjp1.CUSTOM13,
12268: pjp1.CUSTOM14,
12269: pjp1.CUSTOM15
12270: from
12271: PJI_FP_AGGR_PJP1 pjp1,
12272: PJI_PJP_WBS_HEADER wbs_hdr,
12273: PJI_XBS_DENORM prg,
12274: (
12275: select 'Y' CB_FLAG,

Line 12742: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

12738: OUTLINE(@"SEL$30")
12739: OUTLINE(@"SEL$2")
12740: OUTLINE(@"SEL$1")
12741: OUTLINE(@"INS$1")
12742: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
12743: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
12744: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
12745: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
12746: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 12825: /+ parallel(PJI_FP_AGGR_PJP1) /

12821: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
12822: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
12823: END_OUTLINE_DATA
12824: */
12825: /*+ parallel(PJI_FP_AGGR_PJP1) */
12826: into PJI_FP_AGGR_PJP1 partition(P5)
12827: (
12828: WORKER_ID,
12829: RECORD_TYPE,

Line 12826: into PJI_FP_AGGR_PJP1 partition(P5)

12822: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
12823: END_OUTLINE_DATA
12824: */
12825: /*+ parallel(PJI_FP_AGGR_PJP1) */
12826: into PJI_FP_AGGR_PJP1 partition(P5)
12827: (
12828: WORKER_ID,
12829: RECORD_TYPE,
12830: PRG_LEVEL,

Line 13611: PJI_FP_AGGR_PJP1 pjp1,

13607: pjp1.CUSTOM13,
13608: pjp1.CUSTOM14,
13609: pjp1.CUSTOM15
13610: from
13611: PJI_FP_AGGR_PJP1 pjp1,
13612: PJI_PJP_WBS_HEADER wbs_hdr,
13613: PA_XBS_DENORM wbs,
13614: PJI_XBS_DENORM prg,
13615: (

Line 13765: PJI_FP_AGGR_PJP1 pjp1,

13761: pjp1.CUSTOM13,
13762: pjp1.CUSTOM14,
13763: pjp1.CUSTOM15
13764: from
13765: PJI_FP_AGGR_PJP1 pjp1,
13766: PJI_PJP_WBS_HEADER wbs_hdr,
13767: PJI_XBS_DENORM prg,
13768: (
13769: select 'Y' CB_FLAG,

Line 14235: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

14231: OUTLINE(@"SEL$30")
14232: OUTLINE(@"SEL$2")
14233: OUTLINE(@"SEL$1")
14234: OUTLINE(@"INS$1")
14235: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
14236: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
14237: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
14238: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
14239: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 14318: /+ parallel(PJI_FP_AGGR_PJP1) /

14314: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
14315: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
14316: END_OUTLINE_DATA
14317: */
14318: /*+ parallel(PJI_FP_AGGR_PJP1) */
14319: into PJI_FP_AGGR_PJP1 partition(P6)
14320: (
14321: WORKER_ID,
14322: RECORD_TYPE,

Line 14319: into PJI_FP_AGGR_PJP1 partition(P6)

14315: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
14316: END_OUTLINE_DATA
14317: */
14318: /*+ parallel(PJI_FP_AGGR_PJP1) */
14319: into PJI_FP_AGGR_PJP1 partition(P6)
14320: (
14321: WORKER_ID,
14322: RECORD_TYPE,
14323: PRG_LEVEL,

Line 15104: PJI_FP_AGGR_PJP1 pjp1,

15100: pjp1.CUSTOM13,
15101: pjp1.CUSTOM14,
15102: pjp1.CUSTOM15
15103: from
15104: PJI_FP_AGGR_PJP1 pjp1,
15105: PJI_PJP_WBS_HEADER wbs_hdr,
15106: PA_XBS_DENORM wbs,
15107: PJI_XBS_DENORM prg,
15108: (

Line 15258: PJI_FP_AGGR_PJP1 pjp1,

15254: pjp1.CUSTOM13,
15255: pjp1.CUSTOM14,
15256: pjp1.CUSTOM15
15257: from
15258: PJI_FP_AGGR_PJP1 pjp1,
15259: PJI_PJP_WBS_HEADER wbs_hdr,
15260: PJI_XBS_DENORM prg,
15261: (
15262: select 'Y' CB_FLAG,

Line 15728: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

15724: OUTLINE(@"SEL$30")
15725: OUTLINE(@"SEL$2")
15726: OUTLINE(@"SEL$1")
15727: OUTLINE(@"INS$1")
15728: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
15729: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
15730: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
15731: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
15732: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 15811: /+ parallel(PJI_FP_AGGR_PJP1) /

15807: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
15808: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
15809: END_OUTLINE_DATA
15810: */
15811: /*+ parallel(PJI_FP_AGGR_PJP1) */
15812: into PJI_FP_AGGR_PJP1 partition(P7)
15813: (
15814: WORKER_ID,
15815: RECORD_TYPE,

Line 15812: into PJI_FP_AGGR_PJP1 partition(P7)

15808: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
15809: END_OUTLINE_DATA
15810: */
15811: /*+ parallel(PJI_FP_AGGR_PJP1) */
15812: into PJI_FP_AGGR_PJP1 partition(P7)
15813: (
15814: WORKER_ID,
15815: RECORD_TYPE,
15816: PRG_LEVEL,

Line 16597: PJI_FP_AGGR_PJP1 pjp1,

16593: pjp1.CUSTOM13,
16594: pjp1.CUSTOM14,
16595: pjp1.CUSTOM15
16596: from
16597: PJI_FP_AGGR_PJP1 pjp1,
16598: PJI_PJP_WBS_HEADER wbs_hdr,
16599: PA_XBS_DENORM wbs,
16600: PJI_XBS_DENORM prg,
16601: (

Line 16751: PJI_FP_AGGR_PJP1 pjp1,

16747: pjp1.CUSTOM13,
16748: pjp1.CUSTOM14,
16749: pjp1.CUSTOM15
16750: from
16751: PJI_FP_AGGR_PJP1 pjp1,
16752: PJI_PJP_WBS_HEADER wbs_hdr,
16753: PJI_XBS_DENORM prg,
16754: (
16755: select 'Y' CB_FLAG,

Line 17222: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

17218: OUTLINE(@"SEL$30")
17219: OUTLINE(@"SEL$2")
17220: OUTLINE(@"SEL$1")
17221: OUTLINE(@"INS$1")
17222: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
17223: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
17224: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
17225: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
17226: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 17305: /+ parallel(PJI_FP_AGGR_PJP1) /

17301: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
17302: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
17303: END_OUTLINE_DATA
17304: */
17305: /*+ parallel(PJI_FP_AGGR_PJP1) */
17306: into PJI_FP_AGGR_PJP1 partition(P8)
17307: (
17308: WORKER_ID,
17309: RECORD_TYPE,

Line 17306: into PJI_FP_AGGR_PJP1 partition(P8)

17302: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
17303: END_OUTLINE_DATA
17304: */
17305: /*+ parallel(PJI_FP_AGGR_PJP1) */
17306: into PJI_FP_AGGR_PJP1 partition(P8)
17307: (
17308: WORKER_ID,
17309: RECORD_TYPE,
17310: PRG_LEVEL,

Line 18091: PJI_FP_AGGR_PJP1 pjp1,

18087: pjp1.CUSTOM13,
18088: pjp1.CUSTOM14,
18089: pjp1.CUSTOM15
18090: from
18091: PJI_FP_AGGR_PJP1 pjp1,
18092: PJI_PJP_WBS_HEADER wbs_hdr,
18093: PA_XBS_DENORM wbs,
18094: PJI_XBS_DENORM prg,
18095: (

Line 18245: PJI_FP_AGGR_PJP1 pjp1,

18241: pjp1.CUSTOM13,
18242: pjp1.CUSTOM14,
18243: pjp1.CUSTOM15
18244: from
18245: PJI_FP_AGGR_PJP1 pjp1,
18246: PJI_PJP_WBS_HEADER wbs_hdr,
18247: PJI_XBS_DENORM prg,
18248: (
18249: select 'Y' CB_FLAG,

Line 18716: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

18712: OUTLINE(@"SEL$30")
18713: OUTLINE(@"SEL$2")
18714: OUTLINE(@"SEL$1")
18715: OUTLINE(@"INS$1")
18716: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
18717: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
18718: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
18719: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
18720: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 18799: /+ parallel(PJI_FP_AGGR_PJP1) /

18795: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
18796: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
18797: END_OUTLINE_DATA
18798: */
18799: /*+ parallel(PJI_FP_AGGR_PJP1) */
18800: into PJI_FP_AGGR_PJP1 partition(P9)
18801: (
18802: WORKER_ID,
18803: RECORD_TYPE,

Line 18800: into PJI_FP_AGGR_PJP1 partition(P9)

18796: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
18797: END_OUTLINE_DATA
18798: */
18799: /*+ parallel(PJI_FP_AGGR_PJP1) */
18800: into PJI_FP_AGGR_PJP1 partition(P9)
18801: (
18802: WORKER_ID,
18803: RECORD_TYPE,
18804: PRG_LEVEL,

Line 19585: PJI_FP_AGGR_PJP1 pjp1,

19581: pjp1.CUSTOM13,
19582: pjp1.CUSTOM14,
19583: pjp1.CUSTOM15
19584: from
19585: PJI_FP_AGGR_PJP1 pjp1,
19586: PJI_PJP_WBS_HEADER wbs_hdr,
19587: PA_XBS_DENORM wbs,
19588: PJI_XBS_DENORM prg,
19589: (

Line 19739: PJI_FP_AGGR_PJP1 pjp1,

19735: pjp1.CUSTOM13,
19736: pjp1.CUSTOM14,
19737: pjp1.CUSTOM15
19738: from
19739: PJI_FP_AGGR_PJP1 pjp1,
19740: PJI_PJP_WBS_HEADER wbs_hdr,
19741: PJI_XBS_DENORM prg,
19742: (
19743: select 'Y' CB_FLAG,

Line 20210: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")

20206: OUTLINE(@"SEL$30")
20207: OUTLINE(@"SEL$2")
20208: OUTLINE(@"SEL$1")
20209: OUTLINE(@"INS$1")
20210: FULL(@"INS$1" "PJI_FP_AGGR_PJP1"@"INS$1")
20211: NO_ACCESS(@"SEL$1" "PJP1_I"@"SEL$1")
20212: INDEX_RS_ASC(@"SEL$1" "SUP_WPA"@"SEL$1" ("PA_PROJ_WORKPLAN_ATTR"."PROJ_ELEMENT_ID"))
20213: INDEX_RS_ASC(@"SEL$1" "SUP_FIN_VER"@"SEL$1" ("PA_PROJ_ELEM_VER_STRUCTURE"."ELEMENT_VERSION_ID"))
20214: LEADING(@"SEL$1" "PJP1_I"@"SEL$1" "SUP_WPA"@"SEL$1" "SUP_FIN_VER"@"SEL$1")

Line 20293: /+ parallel(PJI_FP_AGGR_PJP1) /

20289: SWAP_JOIN_INPUTS(@"SEL$3" "FIN_PLAN"@"SEL$3")
20290: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
20291: END_OUTLINE_DATA
20292: */
20293: /*+ parallel(PJI_FP_AGGR_PJP1) */
20294: into PJI_FP_AGGR_PJP1 partition(P10)
20295: (
20296: WORKER_ID,
20297: RECORD_TYPE,

Line 20294: into PJI_FP_AGGR_PJP1 partition(P10)

20290: SWAP_JOIN_INPUTS(@"SEL$3" "TOP_SLICE"@"SEL$3")
20291: END_OUTLINE_DATA
20292: */
20293: /*+ parallel(PJI_FP_AGGR_PJP1) */
20294: into PJI_FP_AGGR_PJP1 partition(P10)
20295: (
20296: WORKER_ID,
20297: RECORD_TYPE,
20298: PRG_LEVEL,

Line 21079: PJI_FP_AGGR_PJP1 pjp1,

21075: pjp1.CUSTOM13,
21076: pjp1.CUSTOM14,
21077: pjp1.CUSTOM15
21078: from
21079: PJI_FP_AGGR_PJP1 pjp1,
21080: PJI_PJP_WBS_HEADER wbs_hdr,
21081: PA_XBS_DENORM wbs,
21082: PJI_XBS_DENORM prg,
21083: (

Line 21233: PJI_FP_AGGR_PJP1 pjp1,

21229: pjp1.CUSTOM13,
21230: pjp1.CUSTOM14,
21231: pjp1.CUSTOM15
21232: from
21233: PJI_FP_AGGR_PJP1 pjp1,
21234: PJI_PJP_WBS_HEADER wbs_hdr,
21235: PJI_XBS_DENORM prg,
21236: (
21237: select 'Y' CB_FLAG,

Line 21800: PJI_FP_AGGR_PJP1 pjp1

21796: sum(pjp1.CUSTOM13) CUSTOM13,
21797: sum(pjp1.CUSTOM14) CUSTOM14,
21798: sum(pjp1.CUSTOM15) CUSTOM15
21799: from
21800: PJI_FP_AGGR_PJP1 pjp1
21801: where
21802: pjp1.WORKER_ID = p_worker_id
21803: group by
21804: pjp1.WORKER_ID,

Line 22218: PJI_FP_AGGR_PJP1 pjp1

22214: sum(pjp1.CUSTOM13) CUSTOM13,
22215: sum(pjp1.CUSTOM14) CUSTOM14,
22216: sum(pjp1.CUSTOM15) CUSTOM15
22217: from
22218: PJI_FP_AGGR_PJP1 pjp1
22219: where
22220: pjp1.WORKER_ID = p_worker_id
22221: group by
22222: pjp1.WORKER_ID,

Line 22635: PJI_FP_AGGR_PJP1 pjp1

22631: sum(pjp1.CUSTOM13) CUSTOM13,
22632: sum(pjp1.CUSTOM14) CUSTOM14,
22633: sum(pjp1.CUSTOM15) CUSTOM15
22634: from
22635: PJI_FP_AGGR_PJP1 pjp1
22636: where
22637: pjp1.WORKER_ID = p_worker_id
22638: group by
22639: pjp1.WORKER_ID,

Line 23052: PJI_FP_AGGR_PJP1 pjp1

23048: sum(pjp1.CUSTOM13) CUSTOM13,
23049: sum(pjp1.CUSTOM14) CUSTOM14,
23050: sum(pjp1.CUSTOM15) CUSTOM15
23051: from
23052: PJI_FP_AGGR_PJP1 pjp1
23053: where
23054: pjp1.WORKER_ID = p_worker_id
23055: group by
23056: pjp1.WORKER_ID,

Line 23469: PJI_FP_AGGR_PJP1 pjp1

23465: sum(pjp1.CUSTOM13) CUSTOM13,
23466: sum(pjp1.CUSTOM14) CUSTOM14,
23467: sum(pjp1.CUSTOM15) CUSTOM15
23468: from
23469: PJI_FP_AGGR_PJP1 pjp1
23470: where
23471: pjp1.WORKER_ID = p_worker_id
23472: group by
23473: pjp1.WORKER_ID,

Line 23886: PJI_FP_AGGR_PJP1 pjp1

23882: sum(pjp1.CUSTOM13) CUSTOM13,
23883: sum(pjp1.CUSTOM14) CUSTOM14,
23884: sum(pjp1.CUSTOM15) CUSTOM15
23885: from
23886: PJI_FP_AGGR_PJP1 pjp1
23887: where
23888: pjp1.WORKER_ID = p_worker_id
23889: group by
23890: pjp1.WORKER_ID,

Line 24303: PJI_FP_AGGR_PJP1 pjp1

24299: sum(pjp1.CUSTOM13) CUSTOM13,
24300: sum(pjp1.CUSTOM14) CUSTOM14,
24301: sum(pjp1.CUSTOM15) CUSTOM15
24302: from
24303: PJI_FP_AGGR_PJP1 pjp1
24304: where
24305: pjp1.WORKER_ID = p_worker_id
24306: group by
24307: pjp1.WORKER_ID,

Line 24720: PJI_FP_AGGR_PJP1 pjp1

24716: sum(pjp1.CUSTOM13) CUSTOM13,
24717: sum(pjp1.CUSTOM14) CUSTOM14,
24718: sum(pjp1.CUSTOM15) CUSTOM15
24719: from
24720: PJI_FP_AGGR_PJP1 pjp1
24721: where
24722: pjp1.WORKER_ID = p_worker_id
24723: group by
24724: pjp1.WORKER_ID,

Line 25137: PJI_FP_AGGR_PJP1 pjp1

25133: sum(pjp1.CUSTOM13) CUSTOM13,
25134: sum(pjp1.CUSTOM14) CUSTOM14,
25135: sum(pjp1.CUSTOM15) CUSTOM15
25136: from
25137: PJI_FP_AGGR_PJP1 pjp1
25138: where
25139: pjp1.WORKER_ID = p_worker_id
25140: group by
25141: pjp1.WORKER_ID,

Line 25554: PJI_FP_AGGR_PJP1 pjp1

25550: sum(pjp1.CUSTOM13) CUSTOM13,
25551: sum(pjp1.CUSTOM14) CUSTOM14,
25552: sum(pjp1.CUSTOM15) CUSTOM15
25553: from
25554: PJI_FP_AGGR_PJP1 pjp1
25555: where
25556: pjp1.WORKER_ID = p_worker_id
25557: group by
25558: pjp1.WORKER_ID,