[Home] [Help]
45064: OPEN c1(p_batch_id);
45065: FETCH c1 into p_worker_id, l_level, l_partial_mode, l_fpm_upgrade;
45066: close c1;
45067:
45068: insert into PJI_PJP_WBS_HEADER_T
45069: (
45070: PROJECT_ID,
45071: PLAN_VERSION_ID,
45072: WBS_VERSION_ID,
45147: STRUCT_EMT_ID,
45148: RELATIONSHIP_TYPE
45149: from PA_XBS_DENORM a
45150: where a.STRUCT_VERSION_ID in ( select /*+ cardinality(b,1) */ b.wbs_VERSION_ID -- Hint added for bug 11694228
45151: from PJI_PJP_WBS_HEADER_T b, PJI_PJP_PROJ_BATCH_MAP c
45152: where c.worker_id = p_worker_id
45153: and b.project_id = c.project_id)
45154: and a.struct_type||'' = 'WBS'||'';
45155: -- Bug 13097931 - Forward port bugfix 12879208
46041: pjp1.CUSTOM15
46042: from
46043: PJI_FP_AGGR_PJP1 pjp1,
46044: PJI_HELPER_420 helper,
46045: PJI_PJP_WBS_HEADER_T wbs_hdr,
46046: PA_XBS_DENORM wbs,
46047: PJI_XBS_DENORM_T prg,
46048: (
46049: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46198: pjp1.CUSTOM15
46199: from
46200: PJI_FP_AGGR_PJP1 pjp1,
46201: PJI_HELPER_420 helper, -- order in the From clause should not be changed unless recommended by perf team
46202: PJI_PJP_WBS_HEADER_T wbs_hdr,
46203: PJI_XBS_DENORM_T prg,
46204: (
46205: select 'Y' CB_FLAG,
46206: 'N' CO_FLAG,
46352: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
46353: from
46354: PJI_PA_PROJ_EVENTS_LOG log,
46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46472: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
46473: -1 = prg_delta.SIGN (+) and
46474: prg_delta.SUP_PROJECT_ID is null
46475: ) prg,
46476: PJI_PJP_WBS_HEADER_T wbs_hdr,
46477: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
46478: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
46479: PA_PROJ_WORKPLAN_ATTR sup_wpa
46480: where