APPS.PJI_FM_PLAN_MAINT dependencies on PJI_FM_EXTR_PLNVER4

Line 93: , PJI_FM_EXTR_PLNVER4 bv

89:
90: CURSOR c_res_list_id_bulk_cur (p_budget_version_id IN NUMBER) IS
91: SELECT rpa.rbs_version_id, bv.plan_version_id
92: FROM pa_rbs_prj_assignments rpa
93: , PJI_FM_EXTR_PLNVER4 bv
94: WHERE 1 = 1
95: AND bv.project_id = rpa.project_id
96: AND bv.rbs_struct_version_id <> rpa.rbs_version_id
97: AND bv.plan_version_id = p_budget_version_id

Line 847: ,p_tabname => 'PJI_FM_EXTR_PLNVER4'

843:
844: /* Added for bug 13897252 starts */
845: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
846: PJI_PJP_PRG_PERF_ALL.GATHER_TEMP_STATS(p_ownname => l_pji_schema
847: ,p_tabname => 'PJI_FM_EXTR_PLNVER4'
848: ,p_partname => 'P'||g_worker_id
849: ,p_percent => 10);
850: END IF;
851: /* Added for bug 13897252 ends */

Line 1516: -- FROM pji_fm_extr_plnver4

1512: WHERE wbs_struct_version_id = p_wbs_version_id;
1513:
1514: -- CURSOR c_wbs_struct_ver_id_bulk IS
1515: -- SELECT wbs_struct_version_id, project_id
1516: -- FROM pji_fm_extr_plnver4
1517: -- WHERE worker_id = g_worker_id;
1518:
1519: BEGIN
1520:

Line 1814: FROM pji_fm_extr_plnver4

1810: FROM pji_fm_extr_plnver3_t;
1811: ELSE
1812: SELECT COUNT(1)
1813: INTO l_count
1814: FROM pji_fm_extr_plnver4
1815: WHERE worker_id = g_worker_id;
1816: END IF;
1817:
1818: print_time ( ' ver3 table has ' || l_count || ' records. ');