[Home] [Help]
11: -- Added column project_structure_version_id to select cluase
12: -- Bug 3799921, 26-AUG-2004, jwhite -------------------------------------------------
13: -- Removed columns project_structure_version_id and wp_version_flag
14:
15: cursor get_budget_ver_csr(c_budget_version_id pa_budget_versions.budget_version_id%type) is
16: select bv.budget_version_id,bv.project_id,bv.resource_list_id
17: from pa_budget_versions bv
18: where bv.fin_plan_type_id is not null
19: and bv.budget_version_id = c_budget_version_id
13: -- Removed columns project_structure_version_id and wp_version_flag
14:
15: cursor get_budget_ver_csr(c_budget_version_id pa_budget_versions.budget_version_id%type) is
16: select bv.budget_version_id,bv.project_id,bv.resource_list_id
17: from pa_budget_versions bv
18: where bv.fin_plan_type_id is not null
19: and bv.budget_version_id = c_budget_version_id
20: and exists (select 'X' from pa_resource_assignments ra
21: where bv.budget_version_id = ra.budget_version_id);
22:
23: -- End Bug 3787658, 06-AUG-2004, jwhite ----------------------------------------------
24:
25:
26: cursor get_res_assign_id_csr(c_budget_version_id pa_budget_versions.budget_version_id%type, c_project_id pa_projects_all.project_id%type) is
27: select ra.resource_assignment_id,ra.resource_list_member_id,
28: rlm.migrated_rbs_element_id,
29: min(bl.start_date) min_date,max(bl.end_date) max_date
30: from pa_resource_assignments ra,pa_resource_list_members rlm,pa_budget_lines bl
93: l_msg_data VARCHAR2(2000);
94: l_msg_count NUMBER;
95: l_return_status VARCHAR2(1):= NULL;
96:
97: l_budget_version_id pa_budget_versions.budget_version_id%type;
98:
99:
100: l_debug_mode varchar2(30);
101: l_module_name VARCHAR2(100):= 'pa.plsql.PA_RATE_ATTR_PKG';