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_004 dependencies on IGS_FI_GOV_HEC_PA_OP

Line 2870: IGS_FI_GOV_HEC_PA_OP ghpo

2866: ghpo.s_hecs_payment_type
2867: FROM IGS_ST_GVT_STDNT_LBL gsli,
2868: IGS_ST_GVTSEMLOAD_CA gslc,
2869: IGS_FI_HECS_PAY_OPTN hpo,
2870: IGS_FI_GOV_HEC_PA_OP ghpo
2871: WHERE gsli.submission_yr = p_submission_yr AND
2872: gsli.submission_number = p_submission_number AND
2873: gslc.submission_yr = gsli.submission_yr AND
2874: gslc.submission_number = gsli.submission_number AND

Line 2891: IGS_FI_GOV_HEC_PA_OP ghpo

2887: hpo.govt_hecs_payment_option,
2888: ghpo.s_hecs_payment_type
2889: FROM IGS_EN_STDNTPSHECSOP scho,
2890: IGS_FI_HECS_PAY_OPTN hpo,
2891: IGS_FI_GOV_HEC_PA_OP ghpo
2892: WHERE scho.person_id = cp_person_id AND
2893: scho.course_cd = cp_course_cd AND
2894: scho.start_dt <= cp_effective_dt AND
2895: (scho.end_dt IS NULL OR

Line 3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;

3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%TYPE;
3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%TYPE;
3169: v_differential_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
3170: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;

Line 3172: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;

3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%TYPE;
3169: v_differential_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
3170: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
3171: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
3172: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3173: v_hecs_prexmt_exie NUMBER;
3174: v_fee_cat IGS_AS_SCAH_EFFECTIVE_H_V.fee_cat%TYPE;
3175: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
3176: v_message_name VARCHAR2(30);