APPS.PER_HU_ASSIGN_EXTRA_INFO SQL Statements

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

Line: 25

  SELECT assignment_type
  FROM   per_all_assignments_f paaf,fnd_sessions fs
  WHERE  paaf.assignment_id=p_assignment_id
  AND    fs.session_id=userenv('sessionid')
  AND    fs.effective_date BETWEEN paaf.effective_start_date
         and paaf.effective_end_date;

Line: 56

PROCEDURE UPDATE_HU_ASSIGN_EXTRA_INFO
  (p_assignment_extra_info_id      number
  ,p_aei_information_category      varchar2
  ,p_aei_information2              varchar2
  ,p_aei_information3              varchar2
  ) IS
CURSOR get_assignment_type is
  SELECT  assignment_type
  FROM    per_all_assignments_f paaf, fnd_sessions fs
  WHERE   paaf.assignment_id=(select assignment_id from per_assignment_extra_info
  where assignment_extra_info_id=p_assignment_extra_info_id)
  AND    fs.session_id = userenv('sessionid')
  AND    fs.effective_date BETWEEN paaf.effective_start_date
         and paaf.effective_end_date;

Line: 93

END UPDATE_HU_ASSIGN_EXTRA_INFO;