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_FI_HECS_PAY_OPTN

Line 133: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

129: BEGIN -- stap_get_rptbl_benc
130: -- Routine to determine if a unit of study should be reported to
131: -- the Benefits Control branch.
132: DECLARE
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,

Line 138: IGS_FI_HECS_PAY_OPTN hpo

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
142: scho.start_dt <= p_submission_cutoff_dt AND

Line 252: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;
250: v_crs_req_cmplt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
251: v_comm_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
252: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
253: v_sua_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
254: v_charged_tuition_fees BOOLEAN DEFAULT FALSE;
255: CURSOR c_uc IS
256: SELECT uc.unit_cat

Line 293: IGS_FI_HECS_PAY_OPTN hpo

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
297: sca.course_cd = scho.course_cd (+) AND

Line 786: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%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
789: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
790: v_hecs_amount_pd NUMBER;

Line 860: IGS_FI_HECS_PAY_OPTN hpo,

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
864: scho.start_dt <= p_effective_dt AND