APPS.PA_PROJ_STRUC_MAPPING_UTILS SQL Statements

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

Line: 39

SELECT element_version_id
FROM   PA_PROJ_ELEMENT_VERSIONS elver
WHERE  elver.proj_element_id = p_proj_element_id
AND elver.object_type='PA_TASKS'
AND elver.project_id = p_project_id;

Line: 50

SELECT 'X'
FROM DUAL
WHERE EXISTS
(    SELECT NULL
     FROM PA_OBJECT_RELATIONSHIPS
     WHERE OBJECT_ID_TO1 = l_elem_version_id
     AND relationship_type = 'M'
);

Line: 161

SELECT object_id_to1 object_id
FROM pa_object_relationships
WHERE relationship_type ='S'
AND relationship_subtype ='TASK_TO_TASK'
START WITH object_id_from1 = p_task_version_id_WP
AND object_type_from = 'PA_TASKS'
AND relationship_type = 'S'
CONNECT BY object_id_from1 = PRIOR object_id_to1
AND object_type_from = PRIOR object_type_to
AND relationship_type = PRIOR relationship_type
UNION
SELECT object_id_from1 object_id
FROM pa_object_relationships
WHERE relationship_type  = 'S'
AND relationship_subtype = 'TASK_TO_TASK'
START WITH object_id_to1 = p_task_version_id_WP
AND object_type_to = 'PA_TASKS'
AND relationship_type = 'S'
CONNECT BY Object_id_to1 = PRIOR object_id_from1
AND object_type_to = PRIOR object_type_from
AND relationship_type = PRIOR relationship_type
UNION
SELECT p_task_version_id_WP
FROM DUAL;

Line: 189

SELECT 'X'
FROM dual
WHERE EXISTS
(
 SELECT NULL
 FROM PA_OBJECT_RELATIONSHIPS
 WHERE relationship_type ='M'
 AND object_id_from1 = l_from_task_id
);

Line: 389

SELECT projelem.name
FROM pa_proj_elements projelem
   , pa_proj_element_versions elemver
WHERE elemver.element_version_id = p_task_version_id
AND elemver.proj_element_id = projelem.proj_element_id
AND elemver.object_type = 'PA_TASKS'
AND projelem.object_type = 'PA_TASKS'
AND elemver.project_id = projelem.project_id;

Line: 434

   select object_id_from1,object_id_to1
   from pa_object_relationships
   where relationship_type='S'
   and object_type_to='PA_TASKS'
   connect by prior object_id_from1 = object_id_to1
   and prior relationship_type = relationship_type -- Bug # 4621730.
   start with object_id_to1 = C1.evid;

Line: 451

            select object_id_to1 into l_mapped_fin_task_version_id
            from pa_object_relationships
            where relationship_type='M'
            and object_type_from='PA_TASKS'
            and object_type_to='PA_TASKS'
            and object_id_from1 = l_c1rec.object_id_to1;

Line: 469

         select proj_element_id into l_proj_element_id
            from pa_proj_element_versions
         where element_version_id = l_c1rec.object_id_to1;

Line: 496

   select proj_element_id into l_mapped_fin_task_id
   from pa_proj_element_versions
   where element_version_id = l_mapped_fin_task_version_id;

Line: 531

   select parent_structure_version_id into l_mapped_structure_version_id
   from pa_proj_element_versions
   where element_version_id = l_mapped_fin_task_version_id;

Line: 549

select ppe.name
from
     pa_proj_elements ppe,
     pa_proj_element_versions ppev,
     pa_object_relationships por_mapping
where
     ppe.proj_element_id=ppev.proj_element_id
and
     ppe.project_id = ppev.project_id
and
     ppev.project_id = p_project_id
and
     ppev.element_version_id = por_mapping.object_id_from1
and
     por_mapping.object_id_to1 = p_mapped_fin_task_version_id
and
     por_mapping.relationship_type = 'M';

Line: 597

select ppe.proj_element_id
from
     pa_proj_elements ppe,
     pa_proj_element_versions ppev,
     pa_object_relationships por_mapping
where
     ppe.proj_element_id=ppev.proj_element_id
and
     ppe.project_id = ppev.project_id
and
     ppev.project_id = p_project_id
and
     ppev.element_version_id = por_mapping.object_id_from1
and
     por_mapping.object_id_to1 = p_mapped_fin_task_version_id
and
     por_mapping.relationship_type = 'M';

Line: 644

select ppe.proj_element_id
from
     pa_proj_elements ppe,
     pa_proj_element_versions ppev,
     pa_object_relationships por_mapping
where
     ppe.proj_element_id=ppev.proj_element_id
and
     ppe.project_id = ppev.project_id
and
     ppev.project_id = p_project_id
and
     ppev.element_version_id = por_mapping.object_id_to1
and
     por_mapping.object_id_from1 = p_mapped_wkp_task_version_id
and
     por_mapping.relationship_type = 'M';

Line: 687

select ppe.name
from
     pa_proj_elements ppe,
     pa_proj_element_versions ppev,
     pa_object_relationships por_mapping
where
     ppe.proj_element_id=ppev.proj_element_id
and
     ppe.project_id = ppev.project_id
and
     ppev.project_id = p_project_id
and
     ppev.element_version_id = por_mapping.object_id_to1
and
     por_mapping.object_id_from1 = p_mapped_wkp_task_version_id
and
     por_mapping.relationship_type = 'M';