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_EXTRACT_FIELDS_PKG dependencies on IGS_PS_FLD_OF_STUDY

Line 2627: igs_ps_fld_of_study b

2623: CURSOR c_sbj1 IS
2624: SELECT b.govt_field_of_study,
2625: a.percentage
2626: FROM igs_ps_field_study a,
2627: igs_ps_fld_of_study b
2628: WHERE a.course_cd = p_course_cd
2629: AND a.version_number = p_version_number
2630: AND a.major_field_ind = 'Y'
2631: AND a.field_of_study = b.field_of_study;

Line 2637: igs_ps_fld_of_study b

2633: CURSOR c_sbj23 IS
2634: SELECT b.govt_field_of_study,
2635: a.percentage
2636: FROM igs_ps_field_study a,
2637: igs_ps_fld_of_study b
2638: WHERE a.course_cd = p_course_cd
2639: AND a.version_number = p_version_number
2640: AND a.major_field_ind = 'N'
2641: AND a.field_of_study = b.field_of_study

Line 4557: FROM IGS_PS_FLD_OF_STUDY PFS

4553:
4554: --smaddali added this cursor for bug 2417454 to get the govt code for oss field of study
4555: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS
4556: SELECT govt_field_of_study
4557: FROM IGS_PS_FLD_OF_STUDY PFS
4558: WHERE field_of_study = p_subject;
4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,