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_ST_GEN_003 dependencies on IGS_AD_BASIS_FOR_AD

Line 777: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;

773: v_exemption_institution_cd IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE;
774: v_govt_exemption_inst_cd
775: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
776: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
777: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;
778: v_govt_basis_for_adm_type IGS_AD_BASIS_FOR_AD.govt_basis_for_adm_type%TYPE;
779: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
780: v_result_obtained_yr IGS_AD_AUS_SEC_EDU.result_obtained_yr%TYPE;
781: v_aus_scndry_edu_ass_type IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type%TYPE;

Line 778: v_govt_basis_for_adm_type IGS_AD_BASIS_FOR_AD.govt_basis_for_adm_type%TYPE;

774: v_govt_exemption_inst_cd
775: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
776: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
777: v_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE;
778: v_govt_basis_for_adm_type IGS_AD_BASIS_FOR_AD.govt_basis_for_adm_type%TYPE;
779: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
780: v_result_obtained_yr IGS_AD_AUS_SEC_EDU.result_obtained_yr%TYPE;
781: v_aus_scndry_edu_ass_type IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type%TYPE;
782: v_override_govt_score IGS_AS_TYPGOV_SCORMP.govt_score%TYPE;

Line 817: cp_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE) IS

813: WHERE aca.person_id = p_person_id AND
814: aca.admission_appl_number = cp_admission_appl_number AND
815: aca.nominated_course_cd = cp_nominated_course_cd;
816: CURSOR c_bfa (
817: cp_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE) IS
818: SELECT bfa.govt_basis_for_adm_type
819: FROM IGS_AD_BASIS_FOR_AD bfa
820: WHERE bfa.basis_for_admission_type = cp_basis_for_adm_type;
821: CURSOR c_ase IS

Line 819: FROM IGS_AD_BASIS_FOR_AD bfa

815: aca.nominated_course_cd = cp_nominated_course_cd;
816: CURSOR c_bfa (
817: cp_basis_for_adm_type IGS_AD_BASIS_FOR_AD.basis_for_admission_type%TYPE) IS
818: SELECT bfa.govt_basis_for_adm_type
819: FROM IGS_AD_BASIS_FOR_AD bfa
820: WHERE bfa.basis_for_admission_type = cp_basis_for_adm_type;
821: CURSOR c_ase IS
822: SELECT ase.score,
823: ase.result_obtained_yr,