[Home] [Help]
3613: 'MARK_AS_PROG_REP') ATTRIBUTE19, -- update header only
3614: 'CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
3615: from
3616: PA_XBS_DENORM prg,
3617: PA_PROJ_ELEMENTS emt,
3618: PJI_PJP_RBS_HEADER rbs_hdr,
3619: PJI_PA_PROJ_EVENTS_LOG log
3620: where
3621: prg.SUP_PROJECT_ID = c.PROJECT_ID and
4739: distinct
4740: prj_emt.PROJECT_ID
4741: from
4742: PJI_PJP_PROJ_BATCH_MAP map,
4743: PA_PROJ_ELEMENTS prj_emt
4744: where
4745: map.WORKER_ID = p_worker_id and
4746: prj_emt.OBJECT_TYPE = 'PA_STRUCTURES' and
4747: prj_emt.PROJECT_ID = map.PROJECT_ID
4832: distinct
4833: prj_emt.PROJECT_ID
4834: from
4835: PJI_PA_PROJ_EVENTS_LOG log,
4836: PA_PROJ_ELEMENTS prj_emt,
4837: PJI_PJP_WBS_HEADER hdr
4838: where
4839: log.WORKER_ID = p_worker_id and
4840: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
16129: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
16130: prg.SIGN * fpr.CUSTOM15 CUSTOM15
16131: from
16132: PJI_XBS_DENORM_DELTA prg,
16133: PA_PROJ_ELEMENTS prj_emt,
16134: PJI_PJP_WBS_HEADER wbs_hdr,
16135: PJI_FP_XBS_ACCUM_F fpr,
16136: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16530: pjp1.CUSTOM15
16531: from
16532: PJI_FP_AGGR_PJP1 pjp1,
16533: PJI_PJP_WBS_HEADER wbs_hdr,
16534: PA_PROJ_ELEMENTS prj_emt,
16535: PA_XBS_DENORM prg,
16536: PJI_XBS_DENORM_DELTA prg_delta,
16537: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16538: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
17070: prg.SIGN * acr.CUSTOM14 CUSTOM14,
17071: prg.SIGN * acr.CUSTOM15 CUSTOM15
17072: from
17073: PJI_XBS_DENORM_DELTA prg,
17074: PA_PROJ_ELEMENTS prj_emt,
17075: PJI_PJP_WBS_HEADER wbs_hdr,
17076: PJI_AC_XBS_ACCUM_F acr
17077: where
17078: prg.WORKER_ID = p_worker_id and
17147: pjp1.CUSTOM15
17148: from
17149: PJI_AC_AGGR_PJP1 pjp1,
17150: PJI_PJP_WBS_HEADER wbs_hdr,
17151: PA_PROJ_ELEMENTS prj_emt,
17152: PA_XBS_DENORM prg,
17153: PJI_XBS_DENORM_DELTA prg_delta
17154: where
17155: prg.STRUCT_TYPE = 'PRG' and