APPS.PA_PROJ_STRUCTURE_UTILS SQL Statements

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

Line: 31

		select 'Y'
	 	into l_looped
		from
                -- bug 7573061 : skkoppul - changed table from pa_object_relationships to the below
		(
                  SELECT * FROM pa_object_relationships
                  WHERE relationship_type IN ('LW','LF')
		 )
		where
-- Bug 5589038		object_id_to1 =
                        object_id_to2 =
			(
				select
					project_id
				from
					pa_tasks t
				where
					t.task_id = p_task_id
			)
		start with object_id_from2 = p_project_id
-- Bug 5589038		connect by object_id_from2 = PRIOR object_id_to1;

Line: 62

			select 'Y'
			into l_looped
			from
				pa_tasks t2
			where
				t2.task_id = p_task_id and
				t2.project_id = p_project_id;

Line: 115

  select 'Y'
  from
    pa_object_relationships r,
    pa_tasks t
  where
    r.object_id_to1 = l_project_id and
    r.object_type_to = 'PA_PROJECTS' and
    r.relationship_type = 'H' and
    r.object_id_from2 = t.project_id and
    t.task_id = l_task_id; */

Line: 131

  select 'Y'
  from
    pa_object_relationships r,
    pa_tasks t
  where
    r.object_id_to2 = l_project_id and
    r.object_type_to = 'PA_STRUCTURES' and
    (r.relationship_type = 'LF' or r.relationship_type = 'LW')  and
    r.object_id_from2 = t.project_id and
    t.task_id = l_task_id;

Line: 144

	select
		object_id_from2
	from
        -- bug 7573061 : skkoppul - changed table from pa_object_relationships to the below
        (
           select * from pa_object_relationships
           where relationship_type in ('LW','LF')
        )

	start with
-- Bug5589038		object_id_to1 =
                 object_id_to2 =
		(
			select
				project_id
			from
				pa_tasks t
			where
				t.task_id = l_task_id
		)
--Bug5589038	connect by PRIOR object_id_from2 = object_id_to1
	connect by PRIOR object_id_from2 = object_id_to2
  union
  select
    project_id
  from
    pa_tasks
  where
    task_id = l_task_id
  )
	intersect
	select
		object_id_from2
	from
        -- bug 7573061 : skkoppul - changed table from pa_object_relationships to the below
        (
           select * from pa_object_relationships
           where relationship_type in ('LW','LF')
        )
-- Bug5589038	start with object_id_to1 = l_project_id
 	start with object_id_to2 = l_project_id
-- Bug5589038	connect by PRIOR object_id_from2 = object_id_to1;

Line: 331

 SELECT ENABLE_WF_FLAG
   FROM PA_PROJ_ELEMENTS ppe,
        PA_PROJ_STRUCTURE_TYPES pps,
        PA_STRUCTURE_TYPES pst
  WHERE ppe.project_id = p_project_id
    AND ppe.object_type = 'PA_STRUCTURES'
    AND ppe.proj_element_id = pps.proj_element_id
    AND pps.structure_type_id = pst.structure_type_id
    AND pst.structure_type_class_code = p_structure_type ;

Line: 432

     SELECT 'x' FROM pa_structures_tasks_tmp
     WHERE parent_project_id=p_project_id
     and rownum < 2;

Line: 453

     SELECT 'x' FROM pji_fm_xbs_accum_tmp1
     WHERE project_id=p_project_id
     and rownum < 2;