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.

[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on IGS_ST_GVTSEMLOAD_CA

Line 2868: IGS_ST_GVTSEMLOAD_CA gslc,

2864: gslc.cal_type,
2865: gslc.ci_sequence_number,
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

Line 2996: cp_govt_semester IGS_ST_GVTSEMLOAD_CA.govt_semester%TYPE,

2992: gslo.sua_location_cd = uoo.location_cd AND
2993: gslo.unit_class = uoo.unit_class;
2994: CURSOR c_ess_uv_gslc (
2995: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE,
2996: cp_govt_semester IGS_ST_GVTSEMLOAD_CA.govt_semester%TYPE,
2997: cp_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
2998: cp_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE) IS
2999: SELECT ess.unit_cd,
3000: ess.sua_cal_type,

Line 3016: IGS_ST_GVTSEMLOAD_CA gslc,

3012: ess.ci_sequence_number,
3013: uoo.uoo_id
3014: FROM IGS_EN_ST_SNAPSHOT ess,
3015: IGS_PS_UNIT_VER uv,
3016: IGS_ST_GVTSEMLOAD_CA gslc,
3017: igs_ps_unit_ofr_opt uoo
3018: WHERE ess.snapshot_dt_time = cp_snapshot_dt_time AND
3019: ess.ci_cal_type = gslc.cal_type AND
3020: ess.ci_sequence_number = gslc.ci_sequence_number AND

Line 3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%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;
3171: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

Line 3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%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;
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;