[Home] [Help]
923: AND ppe.proj_element_id = p_task_id
924: AND ppev.proj_element_id = ppe.proj_element_id
925: AND ppev.element_version_id = ppevsh.element_version_id
926: AND ppev.project_id = ppevsh.project_id
927: AND ppev.parent_structure_version_id = PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(ppe.project_id, 'WORKPLAN');
928:
929: CURSOR cur_pa_task_prg2
930: IS
931: SELECT nvl(ppe.WQ_ACTUAL_ENTRY_CODE,ptt.ACTUAL_WQ_ENTRY_CODE)
2360: l_rollup_date date;
2361: begin
2362:
2363: /* -- FPM Dev CR 4 : Added condition for PA_TASKS and structure_version_id
2364: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then
2365:
2366: select max(as_of_date)
2367: into l_rollup_date
2368: from pa_progress_rollup
3609: l_time_phase_code VARCHAR2(30);
3610: l_structure_version_id NUMBER;
3611: BEGIN
3612: if p_structure_version_id is null then
3613: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
3614: else
3615: l_structure_version_id := p_structure_version_id;
3616: end if;
3617: BEGIN
10012: if l_return_date is NULL then
10013:
10014: -- Get latest published structure version id.
10015:
10016: l_lp_str_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id,'WORKPLAN');
10017:
10018: if p_start_end_flag = 'S' then
10019:
10020: open cur_lp_sch_start_date(l_lp_str_ver_id);