[Home] [Help]
3642: IS
3643:
3644: Cursor C_Periodic_dates1 IS
3645: select least(min(start_date), p_start_date), greatest(max(end_date), p_end_date)
3646: from pa_budget_lines a, pa_resource_assignments b
3647: where a.resource_assignment_id = b.resource_assignment_id
3648: and b.project_assignment_id = p_project_assignment_id
3649: and b.project_id = p_project_id
3650: and b.budget_version_id = p_budget_version_id
3663: Cursor C_task_assignment_date(p_proj_start_date IN DATE, p_proj_end_date IN DATE) IS
3664: --Use commented if considering when project assgt. start date is lesser and end date greater than periods.
3665: select least(min(start_date), p_proj_start_date), greatest(max(end_date), p_proj_end_date) from
3666: --select min(start_date, p_proj_start_date), max(end_date, p_proj_end_date) from
3667: pa_budget_lines a, pa_tmp_task_assign_ids b where
3668: (a.start_date between (p_proj_start_date) and (p_proj_end_date)) OR
3669: (a.end_date between (p_proj_start_date) and (p_proj_end_date)) OR
3670: ((p_proj_start_date) between a.start_date and a.end_date) OR
3671: ((p_proj_end_date) between a.start_date and a.end_date)
7791:
7792: CURSOR C1 IS
7793: SELECT a.start_date, a.end_date, NVL(a.quantity,0),
7794: c.planning_start_date, c.planning_end_date -- 4367912
7795: FROM pa_budget_lines a,
7796: -- pa_projects_all b, -- Bug 5086869
7797: pa_resource_assignments c
7798: WHERE a.resource_assignment_id = c.resource_assignment_id
7799: AND c.resource_assignment_id = l_task_assignment_id;