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_IN_GEN_001 dependencies on IGS_EN_STDNTPSHECSOP

Line 857: v_scho_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;

853: AS
854: gv_other_detail VARCHAR2(255);
855: BEGIN -- inqp_get_scho
856: DECLARE
857: v_scho_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
858: v_scho_tax_file_number VARCHAR2(10);
859: v_scho_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
860: v_scho_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
861: CURSOR c_scho IS

Line 859: v_scho_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;

855: BEGIN -- inqp_get_scho
856: DECLARE
857: v_scho_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
858: v_scho_tax_file_number VARCHAR2(10);
859: v_scho_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
860: v_scho_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
861: CURSOR c_scho IS
862: SELECT scho.hecs_payment_option,
863: scho.tax_file_number,

Line 860: v_scho_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;

856: DECLARE
857: v_scho_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
858: v_scho_tax_file_number VARCHAR2(10);
859: v_scho_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
860: v_scho_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
861: CURSOR c_scho IS
862: SELECT scho.hecs_payment_option,
863: scho.tax_file_number,
864: scho.start_dt,

Line 866: FROM IGS_EN_STDNTPSHECSOP scho

862: SELECT scho.hecs_payment_option,
863: scho.tax_file_number,
864: scho.start_dt,
865: scho.end_dt
866: FROM IGS_EN_STDNTPSHECSOP scho
867: WHERE scho.person_id = p_person_id AND
868: scho.course_cd = p_course_cd AND
869: scho.start_dt <= SYSDATE AND
870: (scho.end_dt IS NULL OR