APPS.HR_FCT_SHD SQL Statements

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

Line: 52

    select
       form_canvas_id
      ,language
      ,source_lang
      ,user_canvas_name
      ,description
    from  hr_form_canvases_tl
    where form_canvas_id = p_form_canvas_id
    and   language = p_language;

Line: 119

    select
       form_canvas_id
      ,language
      ,source_lang
      ,user_canvas_name
      ,description
    from	hr_form_canvases_tl
    where	form_canvas_id = p_form_canvas_id
    and   language = p_language
    for	update nowait;

Line: 181

    select fct.form_canvas_id
          ,fct.user_canvas_name
          ,fct.description
          ,fct.source_lang
      from hr_form_canvases_tl fct
     where fct.language = userenv('LANG');

Line: 190

   delete from hr_form_canvases_tl t
     where not exists
     (  select null
           from hr_form_canvases b
           where b.form_canvas_id = t.form_canvas_id
     );

Line: 197

   update hr_form_canvases_tl t
      set ( user_canvas_name,
            description ) =
             ( select b.user_canvas_name,
                      b.description
                  from hr_form_canvases_tl b
                  where b.form_canvas_id = t.form_canvas_id
                  and   b.language = t.source_lang       )
     where ( t.form_canvas_id,
             t.language
	   ) in
        ( select subt.form_canvas_id,
                 subt.language
             from hr_form_canvases_tl subb, hr_form_canvases_tl subt
             where subb.form_canvas_id = subt.form_canvas_id
             and subb.language = subt.source_lang
             and ( subb.user_canvas_name <> subt.user_canvas_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)
		  )
	);