APPS.JTF_IH_GETUSER_PVT SQL Statements

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

Line: 17

   )IS SELECT employee_id
       ,      person_party_id
       ,      supplier_id
       ,      user_name
       FROM fnd_user
       WHERE user_id = b_user_id;

Line: 29

   )IS SELECT full_name
       ,      employee_number
       FROM per_all_people_f
       WHERE person_id = b_employee_id;

Line: 41

   )IS SELECT party_name
       ,      party_number
       FROM hz_parties
       WHERE party_id = b_party_id;