APPS.PQH_FR_WF_NTF SQL Statements

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

Line: 7

    SELECT full_name
    FROM   per_all_people_f
    WHERE  person_id = p_person_id
    ORDER BY effective_start_date DESC;

Line: 31

     SELECT event_code
     FROM   pqh_fr_validation_events
     WHERE  validation_id = p_valid_id
     ORDER BY creation_date DESC;

Line: 36

     SELECT user_name
     FROM   fnd_user
     WHERE  employee_id = p_person_id;

Line: 107

     select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;

Line: 329

     SELECT event_code
     FROM   pqh_fr_validation_events
     WHERE  validation_id = p_valid_id
     ORDER BY creation_date DESC;