DBA Data[Home] [Help]

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 1463: -- FROM pji_fm_extr_plnver4

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
1463: -- FROM pji_fm_extr_plnver4
1464: -- WHERE worker_id = g_worker_id;
1465:
1466: BEGIN
1467:

Line 1754: FROM pji_fm_extr_plnver4

1750: FROM pji_fm_extr_plnver3_t;
1751: ELSE
1752: SELECT COUNT(1)
1753: INTO l_count
1754: FROM pji_fm_extr_plnver4
1755: WHERE worker_id = g_worker_id;
1756: END IF;
1757:
1758: print_time ( ' ver3 table has ' || l_count || ' records. ');