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 1408: FROM pji_fm_extr_plnver3_t ver3

1404: ) IS
1405:
1406: CURSOR c_wbs_vers_exist IS
1407: SELECT DISTINCT wbs_struct_version_id
1408: FROM pji_fm_extr_plnver3_t ver3
1409: WHERE EXISTS (
1410: SELECT /*+ no_unnest */ 1 -- bug 7607077 asahoo - replaced index hint
1411: FROM pa_xbs_denorm pxd
1412: WHERE 1=1

Line 1511: FROM pji_fm_extr_plnver3_t

1507: CURSOR c_wbs_struct_ver_id_online (
1508: p_wbs_version_id NUMBER
1509: ) IS
1510: SELECT DISTINCT wbs_struct_version_id, project_id
1511: FROM pji_fm_extr_plnver3_t
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

Line 1810: FROM pji_fm_extr_plnver3_t;

1806:
1807: IF (p_online = 'T') THEN
1808: SELECT COUNT(1)
1809: INTO l_count
1810: FROM pji_fm_extr_plnver3_t;
1811: ELSE
1812: SELECT COUNT(1)
1813: INTO l_count
1814: FROM pji_fm_extr_plnver4

Line 1859: PJI_FM_EXTR_PLNVER3_T b

1855: , a.project_id, b.plan_version_id
1856: INTO g_process_update_wbs_flag, l_wbs_version_id
1857: , l_project_id, l_plan_version_id
1858: FROM pa_proj_elem_ver_structure a ,
1859: PJI_FM_EXTR_PLNVER3_T b
1860: WHERE a.element_version_id = b.wbs_struct_version_id
1861: AND a.project_id = b.project_id -- 4902584
1862: AND ROWNUM <= 1;
1863: