APPS.HR_ORT_SHD SQL Statements

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

Line: 47

    select
       organization_id
      ,language
      ,source_lang
      ,name
    from  hr_all_organization_units_tl
    where organization_id = p_organization_id
    and   language = p_language;

Line: 113

    select
       organization_id
      ,language
      ,source_lang
      ,name
    from	hr_all_organization_units_tl
    where	organization_id = p_organization_id
    and   language = p_language
    for	update nowait;