APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_PJP_WBS_HEADER

Line 7565: , pji_pjp_wbs_header ver3

7561: , l_last_update_login
7562: FROM
7563: PJI_FP_RMAP_FPR_T rwid
7564: , pji_fp_aggr_pjp1_t tmp
7565: , pji_pjp_wbs_header ver3
7566: WHERE 1 = 1
7567: AND tmp.rowid = rwid.pjp1_rowid
7568: AND rl.rowid = rwid.fpr_rowid
7569: AND rwid.fpr_rowid IS NOT NULL

Line 7837: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.

7833: , CUSTOM15
7834: , tmp.plan_type_code /* 4471527 */
7835: FROM PJI_FP_RMAP_FPR_T rwid
7836: , pji_fp_aggr_pjp1_t tmp
7837: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
7838: WHERE 1 = 1
7839: AND tmp.worker_id = g_worker_id
7840: AND rwid.worker_id = g_worker_id
7841: AND tmp.rowid = rwid.pjp1_rowid

Line 9184: INSERT INTO PJI_PJP_WBS_HEADER

9180: BEGIN
9181:
9182: print_time ( ' Before populate wbs header ' );
9183:
9184: INSERT INTO PJI_PJP_WBS_HEADER
9185: (
9186: PROJECT_ID
9187: , PLAN_VERSION_ID
9188: , WBS_VERSION_ID

Line 9221: , PJI_PJP_WBS_HEADER whdr

9217: , l_creation_date
9218: , l_created_by
9219: , l_last_update_login
9220: FROM PJI_FM_EXTR_PLNVER3_T ver
9221: , PJI_PJP_WBS_HEADER whdr
9222: WHERE ver.plan_version_id = whdr.plan_version_id (+)
9223: AND ver.project_id = whdr.project_id (+)
9224: -- AND ver.wbs_struct_version_id = whdr.wbs_version_id (+)
9225: AND ver.plan_type_id = whdr.plan_type_id (+)

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

9249: BEGIN
9250:
9251: print_time ( ' Before update wbs header ' );
9252:
9253: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
9254: PJI_PJP_WBS_HEADER whdr
9255: SET ( MIN_TXN_DATE
9256: , MAX_TXN_DATE
9257: , LAST_UPDATE_DATE

Line 9254: PJI_PJP_WBS_HEADER whdr

9250:
9251: print_time ( ' Before update wbs header ' );
9252:
9253: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
9254: PJI_PJP_WBS_HEADER whdr
9255: SET ( MIN_TXN_DATE
9256: , MAX_TXN_DATE
9257: , LAST_UPDATE_DATE
9258: , LAST_UPDATED_BY