DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 92: FROM pa_rbs_prj_assignments rpa

88: j NUMBER(15) := NULL;
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

Line 102: FROM pa_rbs_prj_assignments rpa

98: AND bv.worker_id = g_worker_id;
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