APPS.HR_DTY_SHD SQL Statements

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

Line: 48

    select
       document_type_id
      ,system_document_type
      ,category_code
      ,sub_category_code
      ,active_inactive_flag
      ,multiple_occurences_flag
      ,legislation_code
      ,authorization_required
      ,warning_period
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        hr_document_types
    where       document_type_id = p_document_type_id;

Line: 127

    select
       document_type_id
      ,system_document_type
      ,category_code
      ,sub_category_code
      ,active_inactive_flag
      ,multiple_occurences_flag
      ,legislation_code
      ,authorization_required
      ,warning_period
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
    from        hr_document_types
    where       document_type_id = p_document_type_id
    for update nowait;

Line: 211

  ,p_program_update_date            in date
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 234

  l_rec.program_update_date              := p_program_update_date;