APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FP_RMAP_FPR

Line 6014: AND epl.rowid IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t);

6010: AND fpo.project_id = bv.project_id
6011: AND bv.fin_plan_type_id = fpo.fin_plan_type_id
6012: AND bv.budget_version_id = fpo.fin_plan_version_id
6013: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
6014: AND epl.rowid IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t);
6015:
6016: /*
6017: SELECT COUNT(1)
6018: INTO l_count

Line 6603: DELETE FROM PJI_FP_RMAP_FPR

6599: BEGIN
6600:
6601: print_time ( 'CLEANUP_FP_RMAP_FPR begin..');
6602:
6603: DELETE FROM PJI_FP_RMAP_FPR
6604: WHERE worker_id = g_worker_id;
6605:
6606: print_time ( 'CLEANUP_FP_RMAP_FPR end.' || g_worker_id );
6607:

Line 6620: INSERT INTO PJI_FP_RMAP_FPR

6616:
6617: PROCEDURE GET_FP_ROW_IDS IS
6618: BEGIN
6619:
6620: INSERT INTO PJI_FP_RMAP_FPR
6621: (
6622: worker_id
6623: , rl_rowid
6624: , tmp_rowid

Line 6759: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_FP_RMAP_FPR_N1) */

6755: , rl.last_updated_by
6756: , rl.last_update_login
6757: ) =
6758: (
6759: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_FP_RMAP_FPR_N1) */
6760: NVL(rl.RAW_COST, 0) + NVL(tmp.RAW_COST, 0)
6761: , NVL(rl.BRDN_COST, 0) + NVL(tmp.BRDN_COST, 0)
6762: , NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
6763: , NVL(rl.BILL_RAW_COST, 0) + NVL(tmp.BILL_RAW_COST, 0)

Line 6883: PJI_FP_RMAP_FPR rwid

6879: , SYSDATE -- l_last_update_date
6880: , l_last_updated_by
6881: , l_last_update_login
6882: FROM
6883: PJI_FP_RMAP_FPR rwid
6884: , pji_fp_aggr_pjp1 tmp
6885: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
6886: WHERE 1 = 1
6887: AND tmp.rowid = rwid.tmp_rowid

Line 6901: FROM PJI_FP_RMAP_FPR rwid

6897: )
6898: WHERE rl.rowid IN
6899: (
6900: SELECT rwid.rl_rowid
6901: FROM PJI_FP_RMAP_FPR rwid
6902: --commented for bug 5927368
6903: -- WHERE rwid.rl_rowid IS NOT NULL
6904: -- AND rwid.worker_id = g_worker_id
6905: WHERE rwid.worker_id = g_worker_id

Line 6934: from PJI_FP_RMAP_FPR rwid

6930: update /*+ use_nl(pjp1_u) rowid(pjp1_u) */
6931: PJI_FP_AGGR_PJP1 pjp1_u
6932: set RECORD_TYPE = 'U'
6933: where ROWID in (select rwid.TMP_ROWID
6934: from PJI_FP_RMAP_FPR rwid
6935: where rwid.WORKER_ID = g_worker_id) and
6936: nvl(RECORD_TYPE, 'X') <> 'U';
6937: commit;
6938: --End of addition for bug 5927368

Line 7165: -- PJI_FP_RMAP_FPR rwid

7161: , CUSTOM15
7162: ,tmp.PLAN_TYPE_CODE PLAN_TYPE_CODE /*4471527 */
7163: FROM
7164: --Commented for 5927368
7165: -- PJI_FP_RMAP_FPR rwid
7166: pji_fp_aggr_pjp1 tmp
7167: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
7168: WHERE 1 = 1
7169: AND tmp.worker_id = g_worker_id