APPS.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_WBS_HEADER

Line 2063: PJI_PJP_WBS_HEADER wbs_hdr,

2059: pjp1.CUSTOM14,
2060: pjp1.CUSTOM15
2061: from
2062: PJI_FP_AGGR_PJP1 pjp1,
2063: PJI_PJP_WBS_HEADER wbs_hdr,
2064: PA_XBS_DENORM wbs,
2065: PJI_XBS_DENORM prg,
2066: (
2067: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 2217: PJI_PJP_WBS_HEADER wbs_hdr,

2213: pjp1.CUSTOM14,
2214: pjp1.CUSTOM15
2215: from
2216: PJI_FP_AGGR_PJP1 pjp1,
2217: PJI_PJP_WBS_HEADER wbs_hdr,
2218: PJI_XBS_DENORM prg,
2219: (
2220: select 'Y' CB_FLAG,
2221: 'N' CO_FLAG,

Line 2304: PJI_PJP_WBS_HEADER wbs_hdr,

2300: decode(prg.SUB_LEVEL,
2301: prg.SUP_LEVEL, 'A',
2302: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2303: ) prg,
2304: PJI_PJP_WBS_HEADER wbs_hdr,
2305: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2306: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2307: PA_PROJ_WORKPLAN_ATTR sup_wpa
2308: where

Line 2418: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */

2414:
2415: --below call is required for updating
2416: --the date columns on the wbs header
2417:
2418: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
2419: PJI_PJP_WBS_HEADER whdr
2420: SET ( MIN_TXN_DATE
2421: , MAX_TXN_DATE
2422: , LAST_UPDATE_DATE

Line 2419: PJI_PJP_WBS_HEADER whdr

2415: --below call is required for updating
2416: --the date columns on the wbs header
2417:
2418: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
2419: PJI_PJP_WBS_HEADER whdr
2420: SET ( MIN_TXN_DATE
2421: , MAX_TXN_DATE
2422: , LAST_UPDATE_DATE
2423: , LAST_UPDATED_BY

Line 2671: , pji_pjp_wbs_header ver3

2667: , CUSTOM14
2668: , CUSTOM15
2669: , tmp.plan_type_code
2670: FROM pji_fp_aggr_pjp1 tmp
2671: , pji_pjp_wbs_header ver3
2672: WHERE 1 = 1
2673: AND ver3.plan_version_id = tmp.plan_version_id
2674: AND ver3.plan_type_code = tmp.plan_type_code /* 4471527 */
2675: AND tmp.project_id = ver3.project_id -- use index.

Line 2746: PJI_PJP_WBS_HEADER wbs_hdr

2742: select
2743: wbs_hdr.ROWID HDR_ROWID
2744: from
2745: PJI_PJP_PROJ_BATCH_MAP map,
2746: PJI_PJP_WBS_HEADER wbs_hdr
2747: where
2748: map.WORKER_ID = p_worker_id and
2749: wbs_hdr.PROJECT_ID = map.PROJECT_ID and
2750: wbs_hdr.PLAN_VERSION_ID = -1

Line 3542: update PJI_PJP_WBS_HEADER wbs_hdr

3538: from PJI_PJP_PROJ_BATCH_MAP
3539: where WORKER_ID = p_worker_id);
3540:
3541: for c in lock_headers(p_worker_id) loop
3542: update PJI_PJP_WBS_HEADER wbs_hdr
3543: set wbs_hdr.LOCK_FLAG = 'P'
3544: where wbs_hdr.ROWID = c.HDR_ROWID;
3545: end loop;
3546: