APPS.HRI_OLTP_PTL_PARAM SQL Statements

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

Line: 9

         SELECT per.full_name INTO employee_name
         FROM   per_all_people_f per
         WHERE  per.person_id = employee_id
         AND    TRUNC(SYSDATE) BETWEEN per.effective_start_date
                               AND     per.effective_end_date;