APPS.HR_FTT_SHD SQL Statements

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

Line: 52

    select
       form_tab_page_id
      ,language
      ,source_lang
      ,user_tab_page_name
      ,description
    from  hr_form_tab_pages_tl
    where form_tab_page_id = p_form_tab_page_id
    and   language = p_language;

Line: 119

    select
       form_tab_page_id
      ,language
      ,source_lang
      ,user_tab_page_name
      ,description
    from	hr_form_tab_pages_tl
    where	form_tab_page_id = p_form_tab_page_id
    and   language = p_language
    for	update nowait;

Line: 181

    select ftt.form_tab_page_id
          ,ftt.user_tab_page_name
          ,ftt.description
          ,ftt.source_lang
      from hr_form_tab_pages_tl ftt
     where ftt.language = userenv('LANG');

Line: 190

   delete from hr_form_tab_pages_tl t
     where not exists
     (  select null
           from hr_form_tab_pages_b b
           where b.form_tab_page_id = t.form_tab_page_id
     );

Line: 197

   update hr_form_tab_pages_tl t
      set ( user_tab_page_name,
            description ) =
             ( select b.user_tab_page_name,
                      b.description
                  from hr_form_tab_pages_tl b
                  where b.form_tab_page_id = t.form_tab_page_id
                  and   b.language = t.source_lang       )
     where ( t.form_tab_page_id,
             t.language
	   ) in
        ( select subt.form_tab_page_id,
                 subt.language
             from hr_form_tab_pages_tl subb, hr_form_tab_pages_tl subt
             where subb.form_tab_page_id = subt.form_tab_page_id
             and subb.language = subt.source_lang
             and ( subb.user_tab_page_name <> subt.user_tab_page_name
             or    subb.description <> subt.description
             or    (subb.description is null and subt.description is not null)
             or    (subb.description is not null and subt.description is null)
		  )
	);