APPS.PA_PROJECT_DATES_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

   SELECT target_start_date, scheduled_start_date, actual_start_date, start_date -- Fix for Bug # 4506308.
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 83

   SELECT target_finish_date, scheduled_finish_date, actual_finish_date, completion_date
										-- Fix for Bug # 4506308.
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 138

   SELECT 'Y'
   FROM PA_TASKS
   WHERE task_id = p_proj_element_id;

Line: 179

  SELECT a.scheduled_start_date, a.last_update_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND   b.project_id = a.project_id;

Line: 190

  SELECT a.actual_start_date, a.last_update_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND   b.project_id = a.project_id;

Line: 201

  l_scheduled_update_date    DATE;

Line: 202

  l_actual_update_date       DATE;

Line: 209

  FETCH get_task_sch_dates_csr INTO l_scheduled_start_date, l_scheduled_update_date;

Line: 213

  FETCH get_task_act_dates_csr INTO l_actual_start_date, l_actual_update_date;

Line: 221

      x_start_as_of_date := l_scheduled_update_date;

Line: 225

    x_start_as_of_date := l_actual_update_date;

Line: 255

  SELECT a.scheduled_finish_date, a.last_update_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND   b.project_id = a.project_id;

Line: 266

  SELECT a.actual_finish_date, a.last_update_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND   b.project_id = a.project_id;

Line: 277

  l_scheduled_update_date     DATE;

Line: 278

  l_actual_update_date        DATE;

Line: 279

  l_finish_update_date        DATE;

Line: 286

  FETCH get_task_sch_dates_csr INTO l_scheduled_finish_date, l_scheduled_update_date;

Line: 290

  FETCH get_task_act_dates_csr INTO l_actual_finish_date, l_actual_update_date;

Line: 298

      x_finish_as_of_date := l_scheduled_update_date;

Line: 302

    x_finish_as_of_date := l_actual_update_date;

Line: 391

  SELECT a.scheduled_start_date, a.scheduled_finish_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id;

Line: 401

  SELECT a.actual_start_date, a.actual_finish_date
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = p_proj_element_id
  AND   b.element_version_id = a.element_version_id;

Line: 413

 	   SELECT a.actual_start_date, a.actual_finish_date,a.scheduled_start_date, a.scheduled_finish_date
 	   FROM PA_PROJ_ELEM_VER_SCHEDULE a,
 	        PA_PROJ_ELEMENT_VERSIONS b
 	   WHERE b.parent_structure_version_id = p_parent_structure_version_id
 	   AND   b.project_id = p_project_id
 	   AND   b.proj_element_id = p_proj_element_id
 	   AND   b.element_version_id = a.element_version_id
 	   AND   A.PROJECT_ID = B.PROJECT_ID; -- Also added a new condition for 5258713

Line: 485

   SELECT target_start_date, scheduled_start_date, actual_start_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 537

   SELECT target_start_date, scheduled_start_date, actual_start_date,start_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 637

  SELECT scheduled_start_date,
         scheduled_finish_date,
         last_update_date,
         pa_proj_elements_utils.convert_hr_to_days(duration)
  FROM PA_PROJ_ELEM_VER_SCHEDULE
  WHERE element_version_id = p_structure_version_id;

Line: 695

   SELECT target_start_date, scheduled_start_date, actual_start_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 738

   SELECT target_finish_date, scheduled_finish_date, actual_finish_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 777

  SELECT 'x'
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = a.proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND a.actual_finish_date IS NULL
  ;

Line: 816

  SELECT 'x'
  FROM PA_PROJ_ELEM_VER_SCHEDULE a,
       PA_PROJ_ELEMENT_VERSIONS b
  WHERE b.parent_structure_version_id = p_parent_structure_version_id
  AND   b.project_id = p_project_id
  AND   b.proj_element_id = a.proj_element_id
  AND   b.element_version_id = a.element_version_id
  AND a.actual_start_date IS NOT NULL
  ;

Line: 866

	SELECT min(start_date), max(end_date)
	FROM   pa_project_assignments
	WHERE  project_id = l_proj_id
	AND    assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');

Line: 873

	SELECT min(start_date), max(completion_date)
	FROM   pa_tasks
	WHERE  project_id = l_proj_id;

Line: 959

	SELECT min(start_date), max(end_date)
	FROM   pa_project_assignments
	WHERE  project_id = l_proj_id
	AND    assignment_type IN ('OPEN_ASSIGNMENT', 'STAFFED_ASSIGNMENT');

Line: 966

   SELECT a.proj_element_id
   FROM pa_proj_elements a,
        pa_proj_structure_types b,
        pa_structure_types c
   WHERE a.proj_element_id = b.proj_element_id
   AND a.object_type = 'PA_STRUCTURES'
   AND a.project_id = p_project_id
   AND b.structure_type_id = c.structure_type_id
   AND c.structure_type = 'WORKPLAN';

Line: 978

   select element_version_id
   from pa_proj_elem_ver_structure
   where project_id = p_project_id
   and proj_element_id = c_structure_id
   and status_code = 'STRUCTURE_PUBLISHED'
   and latest_eff_published_flag = 'Y';

Line: 987

   SELECT element_version_id
   from pa_proj_elem_ver_structure
   where project_id = p_project_id
   and proj_element_id = c_structure_id
   and status_code <> 'STRUCTURE_PUBLISHED';

Line: 994

     SELECT NVL(TXN_DATE_SYNC_BUF_DAYS,0)
     FROM PA_PROJ_WORKPLAN_ATTR
     WHERE PROJ_ELEMENT_ID = c_structure_id;

Line: 1091

	SELECT start_date, completion_date
	FROM   pa_projects_all
	WHERE  project_id = l_proj_id ;

Line: 1161

	SELECT start_date, completion_date
	FROM   pa_projects_all
	WHERE  project_id = l_proj_id ;

Line: 1168

	SELECT min(start_date), max(end_date)
	FROM   pa_project_assignments
	WHERE  assignment_template_id = l_template_id ;

Line: 1174

	SELECT team_start_date
	FROM pa_team_templates
	WHERE team_template_id = l_template_id;