APPS.PA_TASK_APPROVAL_PKG SQL Statements

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

Line: 24

    SELECT  'Y'
      FROM  PA_PROJ_ELEMENT_VERSIONS
      WHERE proj_element_id = p_proj_element
      AND   parent_structure_version_id = p_parent_struc_ver
      AND   financial_task_flag = 'Y'
      AND   EXISTS (SELECT 1
                    FROM   PA_OBJECT_RELATIONSHIPS
                    WHERE  object_type_from = 'PA_TASKS'
                    AND    object_id_to1 = element_version_id
                    AND    object_type_to = 'PA_TASKS'
                    AND    relationship_type = 'S');

Line: 73

      SELECT 'Y'
        FROM  PA_TASKS
        WHERE project_id = p_project_id
        AND   task_id = p_parent_task_id
        AND   EXISTS (
                       SELECT 1
                       FROM   PA_PROJ_ELEMENTS
                       WHERE  proj_element_id = p_parent_task_id
                       AND    link_task_flag = 'N');

Line: 85

      SELECT  'Y'
      FROM  PA_PROJ_ELEMENT_VERSIONS
      WHERE proj_element_id = p_parent_task_id
      AND   parent_structure_version_id = p_parent_struc_ver
      AND   financial_task_flag = 'Y'
      AND   EXISTS (SELECT 1
                    FROM   PA_OBJECT_RELATIONSHIPS
                    WHERE  object_type_from = 'PA_STRUCTURES'
                    AND    object_id_to1 = element_version_id
                    AND    object_type_to = 'PA_TASKS'
                    AND    relationship_type = 'S');

Line: 157

update pa_proj_elements
set task_approver_id = p_approver_user_id
where proj_element_id = p_task_id;

Line: 189

   Select count(distinct task_id) from
        pa_resource_assignments pra where
          budget_version_id in (
           select budget_version_id from pa_budget_versions where ci_id = p_ci_id )
        and exists (select 1
                  from pa_proj_elements ppe,
                       pa_proj_element_versions ppev,
                       pa_object_relationships por
                  where ppe.proj_element_id = pra.task_id
                  and ppe.project_id = pra.project_id
                  and ppe.link_task_flag = 'Y'
                  and ppe.type_id = 1
                  and ppev.proj_element_id = ppe.proj_element_id
                  and por.object_id_to1 = ppev.element_version_id
                  and por.object_type_to = 'PA_TASKS'
                  and por.relationship_type = 'S'
                  and ppev.financial_task_flag = 'Y')
        and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id);

Line: 231

       UPDATE pa_control_items SET status_code = 'CI_SUBMITTED' WHERE ci_id = p_ci_id;