APPS.HR_TPT_SHD SQL Statements

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

Line: 52

    select
       tab_page_property_id
      ,language
      ,source_lang
      ,label
    from  hr_tab_page_properties_tl
    where tab_page_property_id = p_tab_page_property_id
    and   language = p_language;

Line: 118

    select
       tab_page_property_id
      ,language
      ,source_lang
      ,label
    from	hr_tab_page_properties_tl
    where	tab_page_property_id = p_tab_page_property_id
    and   language = p_language
    for	update nowait;

Line: 179

    select tpt.tab_page_property_id
          ,tpt.label
          ,tpt.source_lang
      from hr_tab_page_properties_tl tpt
     where tpt.language = userenv('LANG');

Line: 187

   delete from hr_tab_page_properties_tl t
     where not exists
     (  select null
           from hr_tab_page_properties_b b
           where b.tab_page_property_id = t.tab_page_property_id
     );

Line: 194

   update hr_tab_page_properties_tl t
      set ( label
          ) =
             ( select b.label
                  from hr_tab_page_properties_tl b
                  where b.tab_page_property_id = t.tab_page_property_id
                  and   b.language = t.source_lang       )
     where ( t.tab_page_property_id,
             t.language
	   ) in
        ( select subt.tab_page_property_id,
                 subt.language
             from hr_tab_page_properties_tl subb, hr_tab_page_properties_tl subt
             where subb.tab_page_property_id = subt.tab_page_property_id
             and subb.language = subt.source_lang
             and (  subb.label <> subt.label
             or    (subb.label is null and subt.label is not null)
             or    (subb.label is not null and subt.label is null)
		  )
	);