APPS.PA_PROJECT_DATES_UTILS SQL Statements

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

Line: 32

   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: 39

		  select ppwa.AUTO_SYNC_TXN_DATE_FLAG, ppwa.wp_enable_version_flag
          from pa_proj_workplan_attr ppwa, pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst
          WHERE ppe.project_id = p_project_id
          AND ppe.project_id = ppwa.project_id
          AND ppe.proj_element_id = ppwa.proj_element_id
          AND ppe.proj_element_id = ppst.proj_element_id
          AND ppst.structure_type_id = pst.structure_type_id
          AND pst.structure_type_class_code = 'WORKPLAN';

Line: 50

		select STRUCTURE_SHARING_CODE
		from PA_PROJECTS_ALL
		where project_id = p_project_id;

Line: 123

   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: 178

   SELECT 'Y'
   FROM PA_TASKS
   WHERE task_id = p_proj_element_id;

Line: 219

  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: 230

  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: 241

  l_scheduled_update_date    DATE;

Line: 242

  l_actual_update_date       DATE;

Line: 249

  FETCH get_task_sch_dates_csr INTO l_scheduled_start_date, l_scheduled_update_date;

Line: 253

  FETCH get_task_act_dates_csr INTO l_actual_start_date, l_actual_update_date;

Line: 261

      x_start_as_of_date := l_scheduled_update_date;

Line: 265

    x_start_as_of_date := l_actual_update_date;

Line: 295

  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: 306

  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: 317

  l_scheduled_update_date     DATE;

Line: 318

  l_actual_update_date        DATE;

Line: 319

  l_finish_update_date        DATE;

Line: 326

  FETCH get_task_sch_dates_csr INTO l_scheduled_finish_date, l_scheduled_update_date;

Line: 330

  FETCH get_task_act_dates_csr INTO l_actual_finish_date, l_actual_update_date;

Line: 338

      x_finish_as_of_date := l_scheduled_update_date;

Line: 342

    x_finish_as_of_date := l_actual_update_date;

Line: 431

  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: 441

  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: 453

 	   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: 525

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

Line: 577

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

Line: 677

  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: 735

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

Line: 778

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

Line: 817

  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: 856

  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: 906

	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: 913

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

Line: 999

	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: 1006

   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: 1018

   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: 1027

   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: 1034

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

Line: 1131

	SELECT start_date, completion_date
	FROM   pa_projects_all
	WHERE  project_id = l_proj_id ;

Line: 1174

Description : This procedure is used to validate the dates of Assignments when updated from the Updatable Scheduled People Page
*/

PROCEDURE VALIDATE_ASSIGNMENT_DATES_BULK
                                 (p_project_id_tbl        IN                   SYSTEM.PA_NUM_TBL_TYPE,
                                  p_start_date_tbl        IN OUT NOCOPY        SYSTEM.PA_DATE_TBL_TYPE,
				  p_end_date_tbl          IN OUT NOCOPY        SYSTEM.PA_DATE_TBL_TYPE,
				  x_validate_tbl          IN OUT NOCOPY        SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
				  x_start_date_status_tbl OUT NOCOPY           SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
				  x_end_date_status_tbl   OUT NOCOPY           SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
				  x_msg_data_tbl          OUT NOCOPY           SYSTEM.PA_VARCHAR2_2000_TBL_TYPE)

IS
         	l_prj_min_date          DATE;

Line: 1194

	        SELECT start_date, completion_date
	        FROM   pa_projects_all
	        WHERE  project_id = l_proj_id ;

Line: 1274

	                 SELECT  start_date, completion_date
	                 INTO  l_start_date, l_completion_date
	                 FROM   pa_projects_prm_v proj
	                 WHERE  project_id = p_project_id_tbl(i);

Line: 1348

	SELECT start_date, completion_date
	FROM   pa_projects_all
	WHERE  project_id = l_proj_id ;

Line: 1412

	     select start_date, completion_date
	     into l_start_date, l_completion_date
	     from pa_projects_prm_v proj
	     where project_id = p_project_id_tbl(i);

Line: 1503

	SELECT start_date, completion_date
	FROM   pa_projects_all
	WHERE  project_id = l_proj_id ;

Line: 1510

	SELECT min(start_date), max(end_date)
	FROM   pa_project_assignments
	WHERE  assignment_template_id = l_template_id
        AND project_id IS NULL ; -- added this for bug 7638712

Line: 1517

	SELECT team_start_date
	FROM pa_team_templates
	WHERE team_template_id = l_template_id;