APPS.PQH_AME_UTILS SQL Statements

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

Line: 16

  select item_type ,item_key, process_name, selected_person_id, creator_person_id
  from   hr_api_transactions
  where  transaction_id  =  p_transaction_id;

Line: 141

   select supervisor_id
   from   per_all_assignments_f
   where  person_id = c_person_id
   and    sysdate between effective_start_date and effective_end_date;