APPS.HR_FWT_SHD SQL Statements

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

Line: 52

    select
       form_window_id
      ,language
      ,source_lang
      ,user_window_name
      ,description
    from  hr_form_windows_tl
    where form_window_id = p_form_window_id
    and   language = p_language;

Line: 119

    select
       form_window_id
      ,language
      ,source_lang
      ,user_window_name
      ,description
    from	hr_form_windows_tl
    where	form_window_id = p_form_window_id
    and   language = p_language
    for	update nowait;

Line: 181

    select fwt.form_window_id
          ,fwt.user_window_name
          ,fwt.description
          ,fwt.source_lang
      from hr_form_windows_tl fwt
     where fwt.language = userenv('LANG');

Line: 190

   delete from hr_form_windows_tl t
     where not exists
     (  select null
           from hr_form_windows_b b
           where b.form_window_id = t.form_window_id
     );

Line: 197

   update hr_form_windows_tl t
      set ( user_window_name,
            description ) =
             ( select b.user_window_name,
                      b.description
                  from hr_form_windows_tl b
                  where b.form_window_id = t.form_window_id
                  and   b.language = t.source_lang       )
     where ( t.form_window_id,
             t.language
	   ) in
        ( select subt.form_window_id,
                 subt.language
             from hr_form_windows_tl subb, hr_form_windows_tl subt
             where subb.form_window_id = subt.form_window_id
             and subb.language = subt.source_lang
             and ( subb.user_window_name <> subt.user_window_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)
		  )
	);