APPS.PAROUTINGX SQL Statements

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

Line: 27

    SELECT
           a.supervisor_id
      INTO
           X_route_to_person_id
      FROM
           per_all_assignments_f a -- Bug 4525947
     WHERE
           a.person_id = nvl(X_previous_approver_person_id, X_incurred_by_person_id)
       AND a.assignment_type IN ('E','C')
       AND a.primary_flag = 'Y'
       AND trunc(SYSDATE) BETWEEN a.effective_start_date  /* Added trunc on sysdate for Bug2886344 */
                       AND a.effective_end_date;

Line: 43

      SELECT 1  INTO dummy
      FROM   per_all_assignments_f b -- Bug 4525947
      WHERE  b.person_id=  X_Route_to_person_id
      AND    b.assignment_type IN ('E','C')
      AND    b.primary_flag = 'Y'
      AND    trunc(SYSDATE) BETWEEN b.effective_start_date  /* Added trunc on sysdate for Bug2886344 */
                       AND b.effective_end_date;