APPS.HR_ITF_SHD SQL Statements

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

Line: 48

    select
       user_interface_id
      ,user_interface_key
      ,type
      ,form_name
      ,page_region_code
      ,region_code
      ,object_version_number
    from        hr_ki_user_interfaces
    where       user_interface_id = p_user_interface_id;

Line: 120

    select
       user_interface_id
      ,user_interface_key
      ,type
      ,form_name
      ,page_region_code
      ,region_code
      ,object_version_number
    from        hr_ki_user_interfaces
    where       user_interface_id = p_user_interface_id
    for update nowait;