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

Line 119: FROM IGS_PS_FLD_OF_STUDY PFS

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:
122: l_subject igs_uc_qual_dets.subject_code%TYPE ;
123:

Line 740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;

736: l_inst_id igs_or_institution.govt_institution_cd%TYPE;
737: l_index NUMBER;
738: l_dummy VARCHAR2(50);
739: l_prop_not_taught NUMBER ;
740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;

Line 741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;

737: l_index NUMBER;
738: l_dummy VARCHAR2(50);
739: l_prop_not_taught NUMBER ;
740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;

Line 742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;

738: l_dummy VARCHAR2(50);
739: l_prop_not_taught NUMBER ;
740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;

Line 751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)

747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
750:
751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
752: IS
753: SELECT govt_field_of_study
754: FROM igs_ps_fld_of_study
755: WHERE field_of_study = cp_field_of_study;

Line 754: FROM igs_ps_fld_of_study

750:
751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
752: IS
753: SELECT govt_field_of_study
754: FROM igs_ps_fld_of_study
755: WHERE field_of_study = cp_field_of_study;
756:
757:
758: BEGIN

Line 4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;

4660: ***************************************************************/
4661: l_inst_id igs_or_institution.govt_institution_cd%TYPE;
4662: l_index NUMBER;
4663: l_dummy VARCHAR2(50);
4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;

Line 4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;

4661: l_inst_id igs_or_institution.govt_institution_cd%TYPE;
4662: l_index NUMBER;
4663: l_dummy VARCHAR2(50);
4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;

Line 4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;

4662: l_index NUMBER;
4663: l_dummy VARCHAR2(50);
4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;

Line 4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)

4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
4674:
4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
4676: IS
4677: SELECT govt_field_of_study
4678: FROM igs_ps_fld_of_study
4679: WHERE field_of_study = cp_field_of_study;

Line 4678: FROM igs_ps_fld_of_study

4674:
4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
4676: IS
4677: SELECT govt_field_of_study
4678: FROM igs_ps_fld_of_study
4679: WHERE field_of_study = cp_field_of_study;
4680:
4681:
4682: