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_EN_VAL_SCHO dependencies on IGS_CA_INST

Line 3432: v_end_dt IGS_CA_INST.end_dt%TYPE;

3428: BEGIN
3429: DECLARE
3430: v_expire_aftr_acdmc_perd_ind
3431: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
3432: v_end_dt IGS_CA_INST.end_dt%TYPE;
3433: v_cal_type IGS_CA_INST.cal_type%TYPE;
3434: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
3435: CURSOR c_hpo(
3436: cp_hpo IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE) IS

Line 3433: v_cal_type IGS_CA_INST.cal_type%TYPE;

3429: DECLARE
3430: v_expire_aftr_acdmc_perd_ind
3431: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
3432: v_end_dt IGS_CA_INST.end_dt%TYPE;
3433: v_cal_type IGS_CA_INST.cal_type%TYPE;
3434: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
3435: CURSOR c_hpo(
3436: cp_hpo IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE) IS
3437: SELECT expire_aftr_acdmc_perd_ind

Line 3434: v_sequence_number IGS_CA_INST.sequence_number%TYPE;

3430: v_expire_aftr_acdmc_perd_ind
3431: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
3432: v_end_dt IGS_CA_INST.end_dt%TYPE;
3433: v_cal_type IGS_CA_INST.cal_type%TYPE;
3434: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
3435: CURSOR c_hpo(
3436: cp_hpo IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE) IS
3437: SELECT expire_aftr_acdmc_perd_ind
3438: FROM IGS_FI_HECS_PAY_OPTN

Line 3441: cp_cal_type IGS_CA_INST.cal_type%TYPE,

3437: SELECT expire_aftr_acdmc_perd_ind
3438: FROM IGS_FI_HECS_PAY_OPTN
3439: WHERE hecs_payment_option= cp_hpo;
3440: CURSOR c_cal_instance (
3441: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3442: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
3443: SELECT end_dt
3444: FROM IGS_CA_INST
3445: WHERE cal_type = cp_cal_type AND

Line 3442: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

3438: FROM IGS_FI_HECS_PAY_OPTN
3439: WHERE hecs_payment_option= cp_hpo;
3440: CURSOR c_cal_instance (
3441: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3442: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
3443: SELECT end_dt
3444: FROM IGS_CA_INST
3445: WHERE cal_type = cp_cal_type AND
3446: sequence_number = cp_cal_sequence_number ;

Line 3444: FROM IGS_CA_INST

3440: CURSOR c_cal_instance (
3441: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3442: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
3443: SELECT end_dt
3444: FROM IGS_CA_INST
3445: WHERE cal_type = cp_cal_type AND
3446: sequence_number = cp_cal_sequence_number ;
3447: v_other_detail VARCHAR(255);
3448: v_message_name varchar2(30);