[Home] [Help]
633: 'MARK_AS_PROG_REP') ATTRIBUTE19, -- update header only
634: 'CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
635: from
636: PA_XBS_DENORM prg,
637: PA_PROJ_ELEMENTS emt,
638: PJI_PJP_RBS_HEADER rbs_hdr,
639: PJI_PA_PROJ_EVENTS_LOG log
640: where
641: prg.SUP_PROJECT_ID = c.PROJECT_ID and
1589: distinct
1590: prj_emt.PROJECT_ID
1591: from
1592: PJI_PJP_PROJ_BATCH_MAP map,
1593: PA_PROJ_ELEMENTS prj_emt
1594: where
1595: map.WORKER_ID = p_worker_id and
1596: prj_emt.OBJECT_TYPE = 'PA_STRUCTURES' and
1597: prj_emt.PROJECT_ID = map.PROJECT_ID
1682: distinct
1683: prj_emt.PROJECT_ID
1684: from
1685: PJI_PA_PROJ_EVENTS_LOG log,
1686: PA_PROJ_ELEMENTS prj_emt,
1687: PJI_PJP_WBS_HEADER hdr
1688: where
1689: log.WORKER_ID = p_worker_id and
1690: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH') and
14005: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
14006: prg.SIGN * fpr.CUSTOM15 CUSTOM15
14007: from
14008: PJI_XBS_DENORM_DELTA prg,
14009: PA_PROJ_ELEMENTS prj_emt,
14010: PJI_PJP_WBS_HEADER wbs_hdr,
14011: PJI_FP_XBS_ACCUM_F fpr,
14012: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14406: pjp1.CUSTOM15
14407: from
14408: PJI_FP_AGGR_PJP1 pjp1,
14409: PJI_PJP_WBS_HEADER wbs_hdr,
14410: PA_PROJ_ELEMENTS prj_emt,
14411: PA_XBS_DENORM prg,
14412: PJI_XBS_DENORM_DELTA prg_delta,
14413: PJI_PJP_WBS_HEADER sup_wbs_hdr,
14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14941: prg.SIGN * acr.CUSTOM14 CUSTOM14,
14942: prg.SIGN * acr.CUSTOM15 CUSTOM15
14943: from
14944: PJI_XBS_DENORM_DELTA prg,
14945: PA_PROJ_ELEMENTS prj_emt,
14946: PJI_PJP_WBS_HEADER wbs_hdr,
14947: PJI_AC_XBS_ACCUM_F acr
14948: where
14949: prg.WORKER_ID = p_worker_id and
15018: pjp1.CUSTOM15
15019: from
15020: PJI_AC_AGGR_PJP1 pjp1,
15021: PJI_PJP_WBS_HEADER wbs_hdr,
15022: PA_PROJ_ELEMENTS prj_emt,
15023: PA_XBS_DENORM prg,
15024: PJI_XBS_DENORM_DELTA prg_delta
15025: where
15026: prg.STRUCT_TYPE = 'PRG' and