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_AS_TYPGOV_SCORMP

Line 782: v_override_govt_score IGS_AS_TYPGOV_SCORMP.govt_score%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;
783: v_diff_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
784: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
785: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
786: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

Line 833: cp_result_obtained_yr IGS_AS_TYPGOV_SCORMP.result_obtained_yr%TYPE,

829: aseat.govt_reported_ind = 'Y'
830: ORDER BY NVL(ase.result_obtained_yr,0) DESC,
831: ase.last_update_date DESC;
832: CURSOR c_atgsm (
833: cp_result_obtained_yr IGS_AS_TYPGOV_SCORMP.result_obtained_yr%TYPE,
834: cp_scndry_edu_ass_type IGS_AS_TYPGOV_SCORMP.scndry_edu_ass_type%TYPE,
835: cp_institution_score IGS_AS_TYPGOV_SCORMP.institution_score%TYPE) IS
836: SELECT atgsm.govt_score
837: FROM IGS_AS_TYPGOV_SCORMP atgsm

Line 834: cp_scndry_edu_ass_type IGS_AS_TYPGOV_SCORMP.scndry_edu_ass_type%TYPE,

830: ORDER BY NVL(ase.result_obtained_yr,0) DESC,
831: ase.last_update_date DESC;
832: CURSOR c_atgsm (
833: cp_result_obtained_yr IGS_AS_TYPGOV_SCORMP.result_obtained_yr%TYPE,
834: cp_scndry_edu_ass_type IGS_AS_TYPGOV_SCORMP.scndry_edu_ass_type%TYPE,
835: cp_institution_score IGS_AS_TYPGOV_SCORMP.institution_score%TYPE) IS
836: SELECT atgsm.govt_score
837: FROM IGS_AS_TYPGOV_SCORMP atgsm
838: WHERE atgsm.result_obtained_yr = cp_result_obtained_yr AND

Line 835: cp_institution_score IGS_AS_TYPGOV_SCORMP.institution_score%TYPE) IS

831: ase.last_update_date DESC;
832: CURSOR c_atgsm (
833: cp_result_obtained_yr IGS_AS_TYPGOV_SCORMP.result_obtained_yr%TYPE,
834: cp_scndry_edu_ass_type IGS_AS_TYPGOV_SCORMP.scndry_edu_ass_type%TYPE,
835: cp_institution_score IGS_AS_TYPGOV_SCORMP.institution_score%TYPE) IS
836: SELECT atgsm.govt_score
837: FROM IGS_AS_TYPGOV_SCORMP atgsm
838: WHERE atgsm.result_obtained_yr = cp_result_obtained_yr AND
839: atgsm.scndry_edu_ass_type = cp_scndry_edu_ass_type AND

Line 837: FROM IGS_AS_TYPGOV_SCORMP atgsm

833: cp_result_obtained_yr IGS_AS_TYPGOV_SCORMP.result_obtained_yr%TYPE,
834: cp_scndry_edu_ass_type IGS_AS_TYPGOV_SCORMP.scndry_edu_ass_type%TYPE,
835: cp_institution_score IGS_AS_TYPGOV_SCORMP.institution_score%TYPE) IS
836: SELECT atgsm.govt_score
837: FROM IGS_AS_TYPGOV_SCORMP atgsm
838: WHERE atgsm.result_obtained_yr = cp_result_obtained_yr AND
839: atgsm.scndry_edu_ass_type = cp_scndry_edu_ass_type AND
840: atgsm.institution_score = cp_institution_score;
841: CURSOR c_adv_stnd IS