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_EN_STDNTPSHECSOP

Line 2882: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,

2878: ORDER BY gsli.person_id,
2879: gsli.course_cd,
2880: gsli.govt_semester;
2881: CURSOR c_scho_hpo_ghpo (
2882: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2883: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2884: cp_effective_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
2885: SELECT scho.differential_hecs_ind,
2886: scho.hecs_payment_option,

Line 2883: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,

2879: gsli.course_cd,
2880: gsli.govt_semester;
2881: CURSOR c_scho_hpo_ghpo (
2882: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2883: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2884: cp_effective_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
2885: SELECT scho.differential_hecs_ind,
2886: scho.hecs_payment_option,
2887: hpo.govt_hecs_payment_option,

Line 2884: cp_effective_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS

2880: gsli.govt_semester;
2881: CURSOR c_scho_hpo_ghpo (
2882: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2883: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2884: cp_effective_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE) IS
2885: SELECT scho.differential_hecs_ind,
2886: scho.hecs_payment_option,
2887: hpo.govt_hecs_payment_option,
2888: ghpo.s_hecs_payment_type

Line 2889: FROM IGS_EN_STDNTPSHECSOP scho,

2885: SELECT scho.differential_hecs_ind,
2886: scho.hecs_payment_option,
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

Line 2941: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,

2937: gsc.hecs_prexmt_exie = cp_hecs_prexmt_exie AND
2938: gsc.hecs_payment_option = cp_hecs_payment_option AND
2939: gsc.differential_hecs_ind = cp_differential_hecs_ind;
2940: CURSOR c_scho1 (
2941: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2942: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2943: cp_old_hecs_payment_option
2944: IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE,
2945: cp_old_differential_hecs_ind

Line 2942: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,

2938: gsc.hecs_payment_option = cp_hecs_payment_option AND
2939: gsc.differential_hecs_ind = cp_differential_hecs_ind;
2940: CURSOR c_scho1 (
2941: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2942: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2943: cp_old_hecs_payment_option
2944: IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE,
2945: cp_old_differential_hecs_ind
2946: IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE) IS

Line 2944: IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE,

2940: CURSOR c_scho1 (
2941: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2942: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2943: cp_old_hecs_payment_option
2944: IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE,
2945: cp_old_differential_hecs_ind
2946: IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE) IS
2947: SELECT scho.last_updated_by,
2948: scho.last_update_date

Line 2946: IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE) IS

2942: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2943: cp_old_hecs_payment_option
2944: IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE,
2945: cp_old_differential_hecs_ind
2946: IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE) IS
2947: SELECT scho.last_updated_by,
2948: scho.last_update_date
2949: FROM IGS_EN_STDNTPSHECSOP scho
2950: WHERE scho.person_id = cp_person_id AND

Line 2949: FROM IGS_EN_STDNTPSHECSOP scho

2945: cp_old_differential_hecs_ind
2946: IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE) IS
2947: SELECT scho.last_updated_by,
2948: scho.last_update_date
2949: FROM IGS_EN_STDNTPSHECSOP scho
2950: WHERE scho.person_id = cp_person_id AND
2951: scho.course_cd = cp_course_cd AND
2952: scho.end_dt IS NOT NULL AND
2953: scho.hecs_payment_option = cp_old_hecs_payment_option AND

Line 2957: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,

2953: scho.hecs_payment_option = cp_old_hecs_payment_option AND
2954: scho.differential_hecs_ind = cp_old_differential_hecs_ind
2955: ORDER BY scho.end_dt DESC;
2956: CURSOR c_scho2 (
2957: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2958: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2959: cp_effective_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE) IS
2960: SELECT scho.last_updated_by,
2961: scho.last_update_date

Line 2958: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,

2954: scho.differential_hecs_ind = cp_old_differential_hecs_ind
2955: ORDER BY scho.end_dt DESC;
2956: CURSOR c_scho2 (
2957: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2958: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2959: cp_effective_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE) IS
2960: SELECT scho.last_updated_by,
2961: scho.last_update_date
2962: FROM IGS_EN_STDNTPSHECSOP scho

Line 2959: cp_effective_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE) IS

2955: ORDER BY scho.end_dt DESC;
2956: CURSOR c_scho2 (
2957: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE,
2958: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2959: cp_effective_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE) IS
2960: SELECT scho.last_updated_by,
2961: scho.last_update_date
2962: FROM IGS_EN_STDNTPSHECSOP scho
2963: WHERE scho.person_id = cp_person_id AND

Line 2962: FROM IGS_EN_STDNTPSHECSOP scho

2958: cp_course_cd IGS_EN_STDNTPSHECSOP.course_cd%TYPE,
2959: cp_effective_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE) IS
2960: SELECT scho.last_updated_by,
2961: scho.last_update_date
2962: FROM IGS_EN_STDNTPSHECSOP scho
2963: WHERE scho.person_id = cp_person_id AND
2964: scho.course_cd = cp_course_cd AND
2965: scho.end_dt IS NOT NULL -- AND
2966: -- scho.end_dt > cp_effective_dt

Line 3169: v_differential_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%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;
3173: v_hecs_prexmt_exie NUMBER;

Line 3170: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%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;
3173: v_hecs_prexmt_exie NUMBER;
3174: v_fee_cat IGS_AS_SCAH_EFFECTIVE_H_V.fee_cat%TYPE;

Line 3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;

3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;
3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;
3194: v_old_units_rows NUMBER;
3195: v_new_units_rows NUMBER;
3196: v_record_found BOOLEAN DEFAULT FALSE;

Line 3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;

3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;
3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;
3194: v_old_units_rows NUMBER;
3195: v_new_units_rows NUMBER;
3196: v_record_found BOOLEAN DEFAULT FALSE;
3197: v_old_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE;