APPS.HXC_APPROVAL_HELPER SQL Statements

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

Line: 28

       select p1.last_name,
              p1.full_name
         from per_all_people_f p1
        where p1.person_id = p_person_id
          and p1.effective_end_date =
              (select max(p2.effective_end_date)
                 from per_all_people_f p2
                where p2.person_id = p1.person_id);

Line: 63

       select 'Y'
         from wf_users
        where name = p_name;