APPS.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_WBS_HEADER

Line 2086: PJI_PJP_WBS_HEADER wbs_hdr,

2082: pjp1.CUSTOM14,
2083: pjp1.CUSTOM15
2084: from
2085: PJI_FP_AGGR_PJP1 pjp1,
2086: PJI_PJP_WBS_HEADER wbs_hdr,
2087: PA_XBS_DENORM wbs,
2088: PJI_XBS_DENORM prg,
2089: (
2090: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 2240: PJI_PJP_WBS_HEADER wbs_hdr,

2236: pjp1.CUSTOM14,
2237: pjp1.CUSTOM15
2238: from
2239: PJI_FP_AGGR_PJP1 pjp1,
2240: PJI_PJP_WBS_HEADER wbs_hdr,
2241: PJI_XBS_DENORM prg,
2242: (
2243: select 'Y' CB_FLAG,
2244: 'N' CO_FLAG,

Line 2327: PJI_PJP_WBS_HEADER wbs_hdr,

2323: decode(prg.SUB_LEVEL,
2324: prg.SUP_LEVEL, 'A',
2325: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2326: ) prg,
2327: PJI_PJP_WBS_HEADER wbs_hdr,
2328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2330: PA_PROJ_WORKPLAN_ATTR sup_wpa
2331: where

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

2437:
2438: --below call is required for updating
2439: --the date columns on the wbs header
2440:
2441: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
2442: PJI_PJP_WBS_HEADER whdr
2443: SET ( MIN_TXN_DATE
2444: , MAX_TXN_DATE
2445: , LAST_UPDATE_DATE

Line 2442: PJI_PJP_WBS_HEADER whdr

2438: --below call is required for updating
2439: --the date columns on the wbs header
2440:
2441: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
2442: PJI_PJP_WBS_HEADER whdr
2443: SET ( MIN_TXN_DATE
2444: , MAX_TXN_DATE
2445: , LAST_UPDATE_DATE
2446: , LAST_UPDATED_BY

Line 2694: , pji_pjp_wbs_header ver3

2690: , CUSTOM14
2691: , CUSTOM15
2692: , tmp.plan_type_code
2693: FROM pji_fp_aggr_pjp1 tmp
2694: , pji_pjp_wbs_header ver3
2695: WHERE 1 = 1
2696: AND ver3.plan_version_id = tmp.plan_version_id
2697: AND ver3.plan_type_code = tmp.plan_type_code /* 4471527 */
2698: AND tmp.project_id = ver3.project_id -- use index.

Line 2770: PJI_PJP_WBS_HEADER wbs_hdr

2766: select
2767: wbs_hdr.ROWID HDR_ROWID
2768: from
2769: PJI_PJP_PROJ_BATCH_MAP map,
2770: PJI_PJP_WBS_HEADER wbs_hdr
2771: where
2772: map.WORKER_ID = p_worker_id and
2773: wbs_hdr.PROJECT_ID = map.PROJECT_ID and
2774: wbs_hdr.PLAN_VERSION_ID = -1

Line 3740: update PJI_PJP_WBS_HEADER wbs_hdr

3736: from PJI_PJP_PROJ_BATCH_MAP
3737: where WORKER_ID = p_worker_id);
3738:
3739: for c in lock_headers(p_worker_id) loop
3740: update PJI_PJP_WBS_HEADER wbs_hdr
3741: set wbs_hdr.LOCK_FLAG = 'P'
3742: where wbs_hdr.ROWID = c.HDR_ROWID;
3743: end loop;
3744: