[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
4083: BEGIN
4084: IF p_task_assignment_id_tbl.COUNT > 0 THEN
4085: SELECT ALIAS INTO l_alias_name FROM
4086: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID
4087: FROM pa_resource_assignments WHERE resource_assignment_id = p_task_assignment_id_tbl(1));
4088: ELSE
4089: l_alias_name := NULL;
4090: END IF;
4091:
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;
8093: -- Bug 5086869 - In WP, there is only one currency
8094: -- so no need for currency join.