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
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