APPS.IGS_AD_GEN_002 dependencies on IGS_PS_FIELD_STUDY

Line 1403: IGS_PS_FIELD_STUDY cfos

1399: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1400: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1401: SELECT fos.govt_field_of_study
1402: FROM IGS_PS_FLD_OF_STUDY fos,
1403: IGS_PS_FIELD_STUDY cfos
1404: WHERE cfos.course_cd = cp_course_cd AND
1405: cfos.version_number = cp_version_number AND
1406: cfos.major_field_ind = 'Y' AND
1407: fos.field_of_study = cfos.field_of_study;