APPS.IGS_ST_GEN_003 dependencies on IGS_AD_AUS_SEC_EDU

Line 780: v_result_obtained_yr IGS_AD_AUS_SEC_EDU.result_obtained_yr%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;
783: v_diff_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
784: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;

Line 825: FROM IGS_AD_AUS_SEC_EDU ase,

821: CURSOR c_ase IS
822: SELECT ase.score,
823: ase.result_obtained_yr,
824: aseat.aus_scndry_edu_ass_type
825: FROM IGS_AD_AUS_SEC_EDU ase,
826: IGS_AD_AUSE_ED_AS_TY aseat
827: WHERE ase.person_id = p_person_id AND
828: aseat.aus_scndry_edu_ass_type = ase.aus_scndry_edu_ass_type AND
829: aseat.govt_reported_ind = 'Y'