52: into x_task_version_id
53: from pa_proj_element_versions ppev1,
54: pa_proj_element_versions ppev2,
55: pa_proj_elem_ver_structure ppevs,
56: pa_structure_types pst,
57: pa_proj_structure_types ppst
58: where ppevs.project_id = p_project_id
59: and ppevs.latest_eff_published_flag = 'Y'
60: and ppevs.element_version_id = ppev1.parent_structure_version_id
96: select ppevs.element_version_id
97: into x_structure_version_id
98: from pa_proj_elem_ver_structure ppevs,
99: pa_proj_element_versions ppev,
100: pa_structure_types pst,
101: pa_proj_structure_types ppst
102: where ppevs.project_id = p_project_id
103: and ppevs.latest_eff_published_flag = 'Y'
104: and ppevs.element_version_id = ppev.element_version_id
2613: -- This cursor obtains the task weight basis code for the project id.
2614: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2615: Is
2616: Select ppa.task_weight_basis_code
2617: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2618: Where ppa.project_id = c_project_id
2619: And ppa.object_type = 'PA_STRUCTURES'
2620: And ppa.structure_type = p_structure_type -- FPM Dev CR 3
2621: And ppa.object_id = pst.proj_element_id