APPS.PJI_FM_PLAN_MAINT dependencies on PJI_FM_EXTR_PLNVER3_T

Line 103: , PJI_FM_EXTR_PLNVER3_T bv

99:
100: CURSOR c_res_list_id_online_cur (p_budget_version_id IN NUMBER) IS
101: SELECT rpa.rbs_version_id, bv.plan_version_id
102: FROM pa_rbs_prj_assignments rpa
103: , PJI_FM_EXTR_PLNVER3_T bv
104: WHERE 1 = 1
105: AND bv.project_id = rpa.project_id
106: AND bv.rbs_struct_version_id <> rpa.rbs_version_id
107: AND bv.plan_version_id = p_budget_version_id;

Line 656: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T',10,10,10); -- Seeding the table Ver3_t

652: print_time(' p_Copy_mode ' || p_copy_mode );
653:
654: print_time('CREATE_PRIMARY_PVT 2 : l_count is ... ' || p_fp_version_ids.COUNT );
655:
656: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_FM_EXTR_PLNVER3_T',10,10,10); -- Seeding the table Ver3_t
657:
658: IF (p_is_primary_rbs NOT IN ('T', 'F')) THEN
659: RETURN;
660: END IF;

Line 1355: FROM pji_fm_extr_plnver3_t ver3

1351: ) IS
1352:
1353: CURSOR c_wbs_vers_exist IS
1354: SELECT DISTINCT wbs_struct_version_id
1355: FROM pji_fm_extr_plnver3_t ver3
1356: WHERE EXISTS (
1357: SELECT /*+ index(pxd PA_XBS_DENORM_N1) */ 1
1358: FROM pa_xbs_denorm pxd
1359: WHERE 1=1

Line 1458: FROM pji_fm_extr_plnver3_t

1454: CURSOR c_wbs_struct_ver_id_online (
1455: p_wbs_version_id NUMBER
1456: ) IS
1457: SELECT DISTINCT wbs_struct_version_id, project_id
1458: FROM pji_fm_extr_plnver3_t
1459: WHERE wbs_struct_version_id = p_wbs_version_id;
1460:
1461: -- CURSOR c_wbs_struct_ver_id_bulk IS
1462: -- SELECT wbs_struct_version_id, project_id

Line 1750: FROM pji_fm_extr_plnver3_t;

1746:
1747: IF (p_online = 'T') THEN
1748: SELECT COUNT(1)
1749: INTO l_count
1750: FROM pji_fm_extr_plnver3_t;
1751: ELSE
1752: SELECT COUNT(1)
1753: INTO l_count
1754: FROM pji_fm_extr_plnver4

Line 1799: PJI_FM_EXTR_PLNVER3_T b

1795: , a.project_id, b.plan_version_id
1796: INTO g_process_update_wbs_flag, l_wbs_version_id
1797: , l_project_id, l_plan_version_id
1798: FROM pa_proj_elem_ver_structure a ,
1799: PJI_FM_EXTR_PLNVER3_T b
1800: WHERE a.element_version_id = b.wbs_struct_version_id
1801: AND a.project_id = b.project_id -- 4902584
1802: AND ROWNUM <= 1;
1803: