APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_POOUS_OU_CC

Line 117: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS

113: AND NVL(b.closed_ind,'N') = 'N' )
114: ORDER BY a.year DESC;
115:
116: -- get the govt field of study for the subject
117: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS
118: SELECT govt_field_of_study
119: FROM IGS_PS_FLD_OF_STUDY PFS
120: WHERE field_of_study = p_subject;
121: