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_AV_ADV_STANDING

Line 771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;

767: DECLARE
768: v_adm_admission_appl_number
769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;
770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;
771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%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;

Line 772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;

768: v_adm_admission_appl_number
769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;
770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;
771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%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;

Line 773: v_exemption_institution_cd IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE;

769: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE;
770: v_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE;
771: v_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
772: v_temp_prior_studies_exemption IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%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;

Line 844: FROM IGS_AV_ADV_STANDING ast

840: atgsm.institution_score = cp_institution_score;
841: CURSOR c_adv_stnd IS
842: SELECT TRUNC(ast.total_exmptn_perc_grntd),
843: ast.exemption_institution_cd
844: FROM IGS_AV_ADV_STANDING ast
845: WHERE ast.person_id = p_person_id AND
846: ast.course_cd = p_course_cd AND
847: ast.version_number = p_crv_version_number;
848: CURSOR c_inst_code (

Line 850: IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS

846: ast.course_cd = p_course_cd AND
847: ast.version_number = p_crv_version_number;
848: CURSOR c_inst_code (
849: cp_exemption_institution_cd
850: IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS
851: SELECT ins.govt_institution_cd
852: FROM IGS_OR_INSTITUTION ins
853: WHERE ins.institution_cd = cp_exemption_institution_cd;
854: CURSOR c_get_hpo IS