[Home] [Help]
27230: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
27231: prg.SIGN * fpr.CUSTOM15 CUSTOM15
27232: from
27233: PJI_XBS_DENORM_DELTA prg,
27234: PA_PROJ_ELEMENTS prj_emt,
27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27631: pjp1.CUSTOM15
27632: from
27633: PJI_FP_AGGR_PJP1 pjp1,
27634: PJI_PJP_WBS_HEADER wbs_hdr,
27635: PA_PROJ_ELEMENTS prj_emt,
27636: PA_XBS_DENORM prg,
27637: PJI_XBS_DENORM_DELTA prg_delta,
27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28275: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
28276: prg.SIGN * fpr.CUSTOM15 CUSTOM15
28277: from
28278: PJI_XBS_DENORM_DELTA prg,
28279: PA_PROJ_ELEMENTS prj_emt,
28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28676: pjp1.CUSTOM15
28677: from
28678: PJI_FP_AGGR_PJP1 pjp1,
28679: PJI_PJP_WBS_HEADER wbs_hdr,
28680: PA_PROJ_ELEMENTS prj_emt,
28681: PA_XBS_DENORM prg,
28682: PJI_XBS_DENORM_DELTA prg_delta,
28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29320: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
29321: prg.SIGN * fpr.CUSTOM15 CUSTOM15
29322: from
29323: PJI_XBS_DENORM_DELTA prg,
29324: PA_PROJ_ELEMENTS prj_emt,
29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29721: pjp1.CUSTOM15
29722: from
29723: PJI_FP_AGGR_PJP1 pjp1,
29724: PJI_PJP_WBS_HEADER wbs_hdr,
29725: PA_PROJ_ELEMENTS prj_emt,
29726: PA_XBS_DENORM prg,
29727: PJI_XBS_DENORM_DELTA prg_delta,
29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30365: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
30366: prg.SIGN * fpr.CUSTOM15 CUSTOM15
30367: from
30368: PJI_XBS_DENORM_DELTA prg,
30369: PA_PROJ_ELEMENTS prj_emt,
30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30766: pjp1.CUSTOM15
30767: from
30768: PJI_FP_AGGR_PJP1 pjp1,
30769: PJI_PJP_WBS_HEADER wbs_hdr,
30770: PA_PROJ_ELEMENTS prj_emt,
30771: PA_XBS_DENORM prg,
30772: PJI_XBS_DENORM_DELTA prg_delta,
30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31410: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
31411: prg.SIGN * fpr.CUSTOM15 CUSTOM15
31412: from
31413: PJI_XBS_DENORM_DELTA prg,
31414: PA_PROJ_ELEMENTS prj_emt,
31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31811: pjp1.CUSTOM15
31812: from
31813: PJI_FP_AGGR_PJP1 pjp1,
31814: PJI_PJP_WBS_HEADER wbs_hdr,
31815: PA_PROJ_ELEMENTS prj_emt,
31816: PA_XBS_DENORM prg,
31817: PJI_XBS_DENORM_DELTA prg_delta,
31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32455: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
32456: prg.SIGN * fpr.CUSTOM15 CUSTOM15
32457: from
32458: PJI_XBS_DENORM_DELTA prg,
32459: PA_PROJ_ELEMENTS prj_emt,
32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32856: pjp1.CUSTOM15
32857: from
32858: PJI_FP_AGGR_PJP1 pjp1,
32859: PJI_PJP_WBS_HEADER wbs_hdr,
32860: PA_PROJ_ELEMENTS prj_emt,
32861: PA_XBS_DENORM prg,
32862: PJI_XBS_DENORM_DELTA prg_delta,
32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33500: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
33501: prg.SIGN * fpr.CUSTOM15 CUSTOM15
33502: from
33503: PJI_XBS_DENORM_DELTA prg,
33504: PA_PROJ_ELEMENTS prj_emt,
33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33901: pjp1.CUSTOM15
33902: from
33903: PJI_FP_AGGR_PJP1 pjp1,
33904: PJI_PJP_WBS_HEADER wbs_hdr,
33905: PA_PROJ_ELEMENTS prj_emt,
33906: PA_XBS_DENORM prg,
33907: PJI_XBS_DENORM_DELTA prg_delta,
33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34545: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
34546: prg.SIGN * fpr.CUSTOM15 CUSTOM15
34547: from
34548: PJI_XBS_DENORM_DELTA prg,
34549: PA_PROJ_ELEMENTS prj_emt,
34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34946: pjp1.CUSTOM15
34947: from
34948: PJI_FP_AGGR_PJP1 pjp1,
34949: PJI_PJP_WBS_HEADER wbs_hdr,
34950: PA_PROJ_ELEMENTS prj_emt,
34951: PA_XBS_DENORM prg,
34952: PJI_XBS_DENORM_DELTA prg_delta,
34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35590: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
35591: prg.SIGN * fpr.CUSTOM15 CUSTOM15
35592: from
35593: PJI_XBS_DENORM_DELTA prg,
35594: PA_PROJ_ELEMENTS prj_emt,
35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35991: pjp1.CUSTOM15
35992: from
35993: PJI_FP_AGGR_PJP1 pjp1,
35994: PJI_PJP_WBS_HEADER wbs_hdr,
35995: PA_PROJ_ELEMENTS prj_emt,
35996: PA_XBS_DENORM prg,
35997: PJI_XBS_DENORM_DELTA prg_delta,
35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36635: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
36636: prg.SIGN * fpr.CUSTOM15 CUSTOM15
36637: from
36638: PJI_XBS_DENORM_DELTA prg,
36639: PA_PROJ_ELEMENTS prj_emt,
36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37036: pjp1.CUSTOM15
37037: from
37038: PJI_FP_AGGR_PJP1 pjp1,
37039: PJI_PJP_WBS_HEADER wbs_hdr,
37040: PA_PROJ_ELEMENTS prj_emt,
37041: PA_XBS_DENORM prg,
37042: PJI_XBS_DENORM_DELTA prg_delta,
37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,
37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37400: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37401: prg.SIGN * acr.CUSTOM15 CUSTOM15
37402: from
37403: PJI_XBS_DENORM_DELTA prg,
37404: PA_PROJ_ELEMENTS prj_emt,
37405: PJI_PJP_WBS_HEADER wbs_hdr,
37406: PJI_AC_XBS_ACCUM_F acr
37407: where
37408: prg.WORKER_ID = p_worker_id and
37477: pjp1.CUSTOM15
37478: from
37479: PJI_AC_AGGR_PJP1 pjp1,
37480: PJI_PJP_WBS_HEADER wbs_hdr,
37481: PA_PROJ_ELEMENTS prj_emt,
37482: PA_XBS_DENORM prg,
37483: PJI_XBS_DENORM_DELTA prg_delta
37484: where
37485: prg.STRUCT_TYPE = 'PRG' and
37743: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37744: prg.SIGN * acr.CUSTOM15 CUSTOM15
37745: from
37746: PJI_XBS_DENORM_DELTA prg,
37747: PA_PROJ_ELEMENTS prj_emt,
37748: PJI_PJP_WBS_HEADER wbs_hdr,
37749: PJI_AC_XBS_ACCUM_F acr
37750: where
37751: prg.WORKER_ID = p_worker_id and
37820: pjp1.CUSTOM15
37821: from
37822: PJI_AC_AGGR_PJP1 pjp1,
37823: PJI_PJP_WBS_HEADER wbs_hdr,
37824: PA_PROJ_ELEMENTS prj_emt,
37825: PA_XBS_DENORM prg,
37826: PJI_XBS_DENORM_DELTA prg_delta
37827: where
37828: prg.STRUCT_TYPE = 'PRG' and
38085: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38086: prg.SIGN * acr.CUSTOM15 CUSTOM15
38087: from
38088: PJI_XBS_DENORM_DELTA prg,
38089: PA_PROJ_ELEMENTS prj_emt,
38090: PJI_PJP_WBS_HEADER wbs_hdr,
38091: PJI_AC_XBS_ACCUM_F acr
38092: where
38093: prg.WORKER_ID = p_worker_id and
38162: pjp1.CUSTOM15
38163: from
38164: PJI_AC_AGGR_PJP1 pjp1,
38165: PJI_PJP_WBS_HEADER wbs_hdr,
38166: PA_PROJ_ELEMENTS prj_emt,
38167: PA_XBS_DENORM prg,
38168: PJI_XBS_DENORM_DELTA prg_delta
38169: where
38170: prg.STRUCT_TYPE = 'PRG' and
38427: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38428: prg.SIGN * acr.CUSTOM15 CUSTOM15
38429: from
38430: PJI_XBS_DENORM_DELTA prg,
38431: PA_PROJ_ELEMENTS prj_emt,
38432: PJI_PJP_WBS_HEADER wbs_hdr,
38433: PJI_AC_XBS_ACCUM_F acr
38434: where
38435: prg.WORKER_ID = p_worker_id and
38504: pjp1.CUSTOM15
38505: from
38506: PJI_AC_AGGR_PJP1 pjp1,
38507: PJI_PJP_WBS_HEADER wbs_hdr,
38508: PA_PROJ_ELEMENTS prj_emt,
38509: PA_XBS_DENORM prg,
38510: PJI_XBS_DENORM_DELTA prg_delta
38511: where
38512: prg.STRUCT_TYPE = 'PRG' and
38769: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38770: prg.SIGN * acr.CUSTOM15 CUSTOM15
38771: from
38772: PJI_XBS_DENORM_DELTA prg,
38773: PA_PROJ_ELEMENTS prj_emt,
38774: PJI_PJP_WBS_HEADER wbs_hdr,
38775: PJI_AC_XBS_ACCUM_F acr
38776: where
38777: prg.WORKER_ID = p_worker_id and
38846: pjp1.CUSTOM15
38847: from
38848: PJI_AC_AGGR_PJP1 pjp1,
38849: PJI_PJP_WBS_HEADER wbs_hdr,
38850: PA_PROJ_ELEMENTS prj_emt,
38851: PA_XBS_DENORM prg,
38852: PJI_XBS_DENORM_DELTA prg_delta
38853: where
38854: prg.STRUCT_TYPE = 'PRG' and
39111: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39112: prg.SIGN * acr.CUSTOM15 CUSTOM15
39113: from
39114: PJI_XBS_DENORM_DELTA prg,
39115: PA_PROJ_ELEMENTS prj_emt,
39116: PJI_PJP_WBS_HEADER wbs_hdr,
39117: PJI_AC_XBS_ACCUM_F acr
39118: where
39119: prg.WORKER_ID = p_worker_id and
39188: pjp1.CUSTOM15
39189: from
39190: PJI_AC_AGGR_PJP1 pjp1,
39191: PJI_PJP_WBS_HEADER wbs_hdr,
39192: PA_PROJ_ELEMENTS prj_emt,
39193: PA_XBS_DENORM prg,
39194: PJI_XBS_DENORM_DELTA prg_delta
39195: where
39196: prg.STRUCT_TYPE = 'PRG' and
39453: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39454: prg.SIGN * acr.CUSTOM15 CUSTOM15
39455: from
39456: PJI_XBS_DENORM_DELTA prg,
39457: PA_PROJ_ELEMENTS prj_emt,
39458: PJI_PJP_WBS_HEADER wbs_hdr,
39459: PJI_AC_XBS_ACCUM_F acr
39460: where
39461: prg.WORKER_ID = p_worker_id and
39530: pjp1.CUSTOM15
39531: from
39532: PJI_AC_AGGR_PJP1 pjp1,
39533: PJI_PJP_WBS_HEADER wbs_hdr,
39534: PA_PROJ_ELEMENTS prj_emt,
39535: PA_XBS_DENORM prg,
39536: PJI_XBS_DENORM_DELTA prg_delta
39537: where
39538: prg.STRUCT_TYPE = 'PRG' and
39795: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39796: prg.SIGN * acr.CUSTOM15 CUSTOM15
39797: from
39798: PJI_XBS_DENORM_DELTA prg,
39799: PA_PROJ_ELEMENTS prj_emt,
39800: PJI_PJP_WBS_HEADER wbs_hdr,
39801: PJI_AC_XBS_ACCUM_F acr
39802: where
39803: prg.WORKER_ID = p_worker_id and
39872: pjp1.CUSTOM15
39873: from
39874: PJI_AC_AGGR_PJP1 pjp1,
39875: PJI_PJP_WBS_HEADER wbs_hdr,
39876: PA_PROJ_ELEMENTS prj_emt,
39877: PA_XBS_DENORM prg,
39878: PJI_XBS_DENORM_DELTA prg_delta
39879: where
39880: prg.STRUCT_TYPE = 'PRG' and
40137: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40138: prg.SIGN * acr.CUSTOM15 CUSTOM15
40139: from
40140: PJI_XBS_DENORM_DELTA prg,
40141: PA_PROJ_ELEMENTS prj_emt,
40142: PJI_PJP_WBS_HEADER wbs_hdr,
40143: PJI_AC_XBS_ACCUM_F acr
40144: where
40145: prg.WORKER_ID = p_worker_id and
40214: pjp1.CUSTOM15
40215: from
40216: PJI_AC_AGGR_PJP1 pjp1,
40217: PJI_PJP_WBS_HEADER wbs_hdr,
40218: PA_PROJ_ELEMENTS prj_emt,
40219: PA_XBS_DENORM prg,
40220: PJI_XBS_DENORM_DELTA prg_delta
40221: where
40222: prg.STRUCT_TYPE = 'PRG' and
40479: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40480: prg.SIGN * acr.CUSTOM15 CUSTOM15
40481: from
40482: PJI_XBS_DENORM_DELTA prg,
40483: PA_PROJ_ELEMENTS prj_emt,
40484: PJI_PJP_WBS_HEADER wbs_hdr,
40485: PJI_AC_XBS_ACCUM_F acr
40486: where
40487: prg.WORKER_ID = p_worker_id and
40556: pjp1.CUSTOM15
40557: from
40558: PJI_AC_AGGR_PJP1 pjp1,
40559: PJI_PJP_WBS_HEADER wbs_hdr,
40560: PA_PROJ_ELEMENTS prj_emt,
40561: PA_XBS_DENORM prg,
40562: PJI_XBS_DENORM_DELTA prg_delta
40563: where
40564: prg.STRUCT_TYPE = 'PRG' and