APPS.PER_NAA_SHD SQL Statements

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

Line: 60

    select
       absence_action_id
      ,absence_attendance_id
      ,expected_date
      ,description
      ,actual_start_date
      ,actual_end_date
      ,holder
      ,comments
      ,document_file_name
      ,last_updated_by
      ,object_version_number
      ,enabled
    from        per_nl_absence_actions
    where       absence_action_id = p_absence_action_id;

Line: 140

    select
       absence_action_id
      ,absence_attendance_id
      ,expected_date
      ,description
      ,actual_start_date
      ,actual_end_date
      ,holder
      ,comments
      ,document_file_name
      ,last_updated_by
      ,object_version_number
      ,enabled
    from        per_nl_absence_actions
    where       absence_action_id = p_absence_action_id
    for update nowait;

Line: 219

  ,p_last_updated_by                 in number
  ,p_object_version_number          in number
  ,p_enabled                        in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 240

  l_rec.last_updated_by                   := p_last_updated_by;