APPS.HR_IPT_SHD SQL Statements

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

Line: 52

    select
       item_property_id
      ,language
      ,source_lang
      ,default_value
      ,information_prompt
      ,label
      ,prompt_text
      ,tooltip_text
    from  hr_item_properties_tl
    where item_property_id = p_item_property_id
    and   language = p_language;

Line: 122

    select
       item_property_id
      ,language
      ,source_lang
      ,default_value
      ,information_prompt
      ,label
      ,prompt_text
      ,tooltip_text
    from	hr_item_properties_tl
    where	item_property_id = p_item_property_id
    and   language = p_language
    for	update nowait;

Line: 187

    select ipt.item_property_id
          ,ipt.default_value
          ,ipt.information_prompt
          ,ipt.label
          ,ipt.prompt_text
          ,ipt.tooltip_text
          ,ipt.source_lang
      from hr_item_properties_tl ipt
     where ipt.language = userenv('LANG');