APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FP_RMAP_FPR_T

Line 6663: DELETE FROM PJI_FP_RMAP_FPR_T

6659: BEGIN
6660:
6661: print_time ( 'CLEANUP_FP_RMAP_FPR begin..');
6662:
6663: DELETE FROM PJI_FP_RMAP_FPR_T
6664: WHERE worker_id = g_worker_id;
6665:
6666: print_time ( 'CLEANUP_FP_RMAP_FPR end.' || g_worker_id );
6667:

Line 6687: INSERT INTO PJI_FP_RMAP_FPR_T

6683: --to
6684: --SELECT /*+ full(tmp) index(rl, PJI_FP_XBS_ACCUM_F_N6) use_nl(rl) */
6685: -- End Bug 10632614
6686:
6687: INSERT INTO PJI_FP_RMAP_FPR_T
6688: (
6689: worker_id
6690: , pjp1_rowid
6691: , fpr_rowid

Line 7439: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_FP_RMAP_FPR_T_N1) */

7435: , rl.last_updated_by
7436: , rl.last_update_login
7437: ) =
7438: (
7439: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_FP_RMAP_FPR_T_N1) */
7440: NVL(rl.RAW_COST, 0) + NVL(tmp.RAW_COST, 0)
7441: , NVL(rl.BRDN_COST, 0) + NVL(tmp.BRDN_COST, 0)
7442: , NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
7443: , NVL(rl.BILL_RAW_COST, 0) + NVL(tmp.BILL_RAW_COST, 0)

Line 7563: PJI_FP_RMAP_FPR_T rwid

7559: , SYSDATE
7560: , l_last_updated_by
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

Line 7581: FROM PJI_FP_RMAP_FPR_T rwid

7577: )
7578: WHERE rl.rowid IN
7579: (
7580: SELECT rwid.fpr_rowid
7581: FROM PJI_FP_RMAP_FPR_T rwid
7582: WHERE rwid.fpr_rowid IS NOT NULL
7583: AND rwid.worker_id = g_worker_id
7584: );
7585:

Line 7835: FROM PJI_FP_RMAP_FPR_T rwid

7831: , CUSTOM13
7832: , CUSTOM14
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