APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FP_RMAP_FPR

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

4826: AND fpo.project_id = bv.project_id
4827: AND bv.fin_plan_type_id = fpo.fin_plan_type_id
4828: AND bv.budget_version_id = fpo.fin_plan_version_id
4829: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
4830: AND epl.rowid IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t);
4831:
4832: /*
4833: SELECT COUNT(1)
4834: INTO l_count

Line 5399: DELETE FROM PJI_FP_RMAP_FPR

5395: BEGIN
5396:
5397: print_time ( 'CLEANUP_FP_RMAP_FPR begin..');
5398:
5399: DELETE FROM PJI_FP_RMAP_FPR
5400: WHERE worker_id = g_worker_id;
5401:
5402: print_time ( 'CLEANUP_FP_RMAP_FPR end.' || g_worker_id );
5403:

Line 5416: INSERT INTO PJI_FP_RMAP_FPR

5412:
5413: PROCEDURE GET_FP_ROW_IDS IS
5414: BEGIN
5415:
5416: INSERT INTO PJI_FP_RMAP_FPR
5417: (
5418: worker_id
5419: , rl_rowid
5420: , tmp_rowid

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

5551: , rl.last_updated_by
5552: , rl.last_update_login
5553: ) =
5554: (
5555: SELECT /*+ ORDERED ROWID(TMP) index(rwid,PJI_FP_RMAP_FPR_N1) */
5556: NVL(rl.RAW_COST, 0) + NVL(tmp.RAW_COST, 0)
5557: , NVL(rl.BRDN_COST, 0) + NVL(tmp.BRDN_COST, 0)
5558: , NVL(rl.REVENUE, 0) + NVL(tmp.REVENUE, 0)
5559: , NVL(rl.BILL_RAW_COST, 0) + NVL(tmp.BILL_RAW_COST, 0)

Line 5679: PJI_FP_RMAP_FPR rwid

5675: , SYSDATE -- l_last_update_date
5676: , l_last_updated_by
5677: , l_last_update_login
5678: FROM
5679: PJI_FP_RMAP_FPR rwid
5680: , pji_fp_aggr_pjp1 tmp
5681: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5682: WHERE 1 = 1
5683: AND tmp.rowid = rwid.tmp_rowid

Line 5697: FROM PJI_FP_RMAP_FPR rwid

5693: )
5694: WHERE rl.rowid IN
5695: (
5696: SELECT rwid.rl_rowid
5697: FROM PJI_FP_RMAP_FPR rwid
5698: --commented for bug 5927368
5699: -- WHERE rwid.rl_rowid IS NOT NULL
5700: -- AND rwid.worker_id = g_worker_id
5701: WHERE rwid.worker_id = g_worker_id

Line 5730: from PJI_FP_RMAP_FPR rwid

5726: update /*+ use_nl(pjp1_u) rowid(pjp1_u) */
5727: PJI_FP_AGGR_PJP1 pjp1_u
5728: set RECORD_TYPE = 'U'
5729: where ROWID in (select rwid.TMP_ROWID
5730: from PJI_FP_RMAP_FPR rwid
5731: where rwid.WORKER_ID = g_worker_id) and
5732: nvl(RECORD_TYPE, 'X') <> 'U';
5733: commit;
5734: --End of addition for bug 5927368

Line 5961: -- PJI_FP_RMAP_FPR rwid

5957: , CUSTOM15
5958: ,tmp.PLAN_TYPE_CODE PLAN_TYPE_CODE /*4471527 */
5959: FROM
5960: --Commented for 5927368
5961: -- PJI_FP_RMAP_FPR rwid
5962: pji_fp_aggr_pjp1 tmp
5963: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5964: WHERE 1 = 1
5965: AND tmp.worker_id = g_worker_id