APPS.IGR_PER_INFO_001 SQL Statements

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

Line: 19

  SELECT eus.TITLE
    FROM IGS_AD_UNIT_SETS aus,
         IGS_EN_UNIT_SET eus
   WHERE aus.UNIT_SET_CD = eus.UNIT_SET_CD
     AND aus.VERSION_NUMBER = eus.VERSION_NUMBER
     AND aus.PERSON_ID = x_person_id
     AND aus.ADMISSION_APPL_NUMBER = x_adm_appl_number
     AND aus.NOMINATED_COURSE_CD = x_course_cd
     AND aus.SEQUENCE_NUMBER = x_seq_number;

Line: 54

SELECT CODE.DESCRIPTION
  FROM IGS_AD_I_PRG_PRF_UST PREF,
       IGS_AD_I_PRG_U_SET USET,
       IGS_AD_INQ_UNIT_SETS CODE
 WHERE PREF.INQ_PROG_UNIT_SET_ID = USET.INQ_PROG_UNIT_SET_ID
   AND USET.INQ_UNIT_SET_CODE_ID = CODE.INQ_UNIT_SET_CODE_ID
   AND PREF.INQ_PROG_PREF_ID =x_prog_pref_id;

Line: 86

  select SCORES.TEST_SEGMENT||' : '||SCORES.SEGMENT_SCORE SCORE
    from IGS_AD_TEST_SCORES_V SCORES
   where SCORES.TEST_RESULTS_ID = x_test_result_id;