eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_IMPORT_DATA dependencies on IGS_PS_FLD_OF_STUDY

Line 1246: CURSOR c_field_study( cp_subject igs_ps_fld_of_study.field_of_study%TYPE) IS

1242: AND OAI.ORG_ALTERNATE_ID_TYPE = OAIT.ORG_ALTERNATE_ID_TYPE
1243: AND OAIT.SYSTEM_ID_TYPE = 'HESA_INST';
1244:
1245: -- Get the oss field of study
1246: CURSOR c_field_study( cp_subject igs_ps_fld_of_study.field_of_study%TYPE) IS
1247: SELECT a.field_of_study
1248: FROM igs_ps_fld_of_study a
1249: WHERE a.govt_field_of_study = cp_subject AND
1250: a.closed_ind = 'N'

Line 1248: FROM igs_ps_fld_of_study a

1244:
1245: -- Get the oss field of study
1246: CURSOR c_field_study( cp_subject igs_ps_fld_of_study.field_of_study%TYPE) IS
1247: SELECT a.field_of_study
1248: FROM igs_ps_fld_of_study a
1249: WHERE a.govt_field_of_study = cp_subject AND
1250: a.closed_ind = 'N'
1251: ORDER BY a.field_of_study ;
1252: