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_EN_STDNTPSHECSOP

Line 137: IGS_EN_STDNTPSHECSOP scho,

133: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
134: CURSOR c_scho_hpo IS
135: SELECT hpo.govt_hecs_payment_option
136: FROM
137: IGS_EN_STDNTPSHECSOP scho,
138: IGS_FI_HECS_PAY_OPTN hpo
139: WHERE
140: scho.person_id = p_person_id AND
141: scho.course_cd = p_course_cd AND

Line 292: IGS_EN_STDNTPSHECSOP scho,

288: sca.course_rqrmnt_complete_ind,
289: sca.commencement_dt,
290: hpo.govt_hecs_payment_option
291: FROM IGS_EN_STDNT_PS_ATT sca,
292: IGS_EN_STDNTPSHECSOP scho,
293: IGS_FI_HECS_PAY_OPTN hpo
294: WHERE sca.person_id = p_person_id AND
295: sca.course_cd = p_course_cd AND
296: sca.person_id = scho.person_id (+) AND

Line 783: v_diff_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%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;
787: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

Line 784: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%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;
787: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
788: v_acad_ci_sequence_number

Line 859: FROM IGS_EN_STDNTPSHECSOP scho,

855: SELECT scho.differential_hecs_ind,
856: scho.hecs_payment_option,
857: hpo.govt_hecs_payment_option,
858: ghpo.s_hecs_payment_type
859: FROM IGS_EN_STDNTPSHECSOP scho,
860: IGS_FI_HECS_PAY_OPTN hpo,
861: IGS_FI_GOV_HEC_PA_OP ghpo
862: WHERE scho.person_id = p_person_id AND
863: scho.course_cd = p_course_cd AND