DBA Data[Home] [Help]

APPS.HR_NMF_SHD SQL Statements

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

Line: 54

    select
       name_format_id
      ,format_name
      ,legislation_code
      ,user_format_choice
      ,format_mask
      ,object_version_number
    from        hr_name_formats
    where       name_format_id = p_name_format_id;
Line: 125

    select
       name_format_id
      ,format_name
      ,legislation_code
      ,user_format_choice
      ,format_mask
      ,object_version_number
    from        hr_name_formats
    where       name_format_id = p_name_format_id
    for update nowait;