[Home] [Help]
3928: IS
3929:
3930: Cursor C_Periodic_dates1 IS
3931: select least(min(start_date), p_start_date), greatest(max(end_date), p_end_date)
3932: from pa_budget_lines a, pa_resource_assignments b
3933: where a.resource_assignment_id = b.resource_assignment_id
3934: and b.project_assignment_id = p_project_assignment_id
3935: and b.project_id = p_project_id
3936: and b.budget_version_id = p_budget_version_id
3949: Cursor C_task_assignment_date(p_proj_start_date IN DATE, p_proj_end_date IN DATE) IS
3950: --Use commented if considering when project assgt. start date is lesser and end date greater than periods.
3951: select least(min(start_date), p_proj_start_date), greatest(max(end_date), p_proj_end_date) from
3952: --select min(start_date, p_proj_start_date), max(end_date, p_proj_end_date) from
3953: pa_budget_lines a, pa_tmp_task_assign_ids b where
3954: (a.start_date between (p_proj_start_date) and (p_proj_end_date)) OR
3955: (a.end_date between (p_proj_start_date) and (p_proj_end_date)) OR
3956: ((p_proj_start_date) between a.start_date and a.end_date) OR
3957: ((p_proj_end_date) between a.start_date and a.end_date)
8084:
8085: CURSOR C1 IS
8086: SELECT a.start_date, a.end_date, NVL(a.quantity,0),
8087: c.planning_start_date, c.planning_end_date -- 4367912
8088: FROM pa_budget_lines a,
8089: -- pa_projects_all b, -- Bug 5086869
8090: pa_resource_assignments c
8091: WHERE a.resource_assignment_id = c.resource_assignment_id
8092: AND c.resource_assignment_id = l_task_assignment_id;