[Home] [Help]
58:
59: --hsiu: bug 2663532
60: CURSOR c3(p_task_id NUMBER) IS
61: select a.project_id, a.proj_element_id
62: from pa_proj_element_versions a,
63: pa_proj_element_versions b
64: where b.proj_element_id = p_task_id
65: and b.parent_structure_version_id = a.element_version_id
66: and b.project_id = a.project_id;
59: --hsiu: bug 2663532
60: CURSOR c3(p_task_id NUMBER) IS
61: select a.project_id, a.proj_element_id
62: from pa_proj_element_versions a,
63: pa_proj_element_versions b
64: where b.proj_element_id = p_task_id
65: and b.parent_structure_version_id = a.element_version_id
66: and b.project_id = a.project_id;
67: v_c3 c3%ROWTYPE;