DBA Data[Home] [Help]

APPS.HR_FIT_SHD SQL Statements

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

Line: 52

    select
       form_item_id
      ,language
      ,source_lang
      ,user_item_name
      ,description
    from  hr_form_items_tl
    where form_item_id = p_form_item_id
    and   language = p_language;
Line: 119

    select
       form_item_id
      ,language
      ,source_lang
      ,user_item_name
      ,description
    from	hr_form_items_tl
    where	form_item_id = p_form_item_id
    and   language = p_language
    for	update nowait;
Line: 181

    select fit.form_item_id
          ,fit.user_item_name
          ,fit.description
          ,fit.source_lang
      from hr_form_items_tl fit
     where fit.language = userenv('LANG');