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_FI_PRC_REFUNDS dependencies on IGS_EN_STDNT_PS_ATT

Line 738: cp_crs_stat igs_en_stdnt_ps_att.course_attempt_status%TYPE) IS

734:
735: -- Cursor for validating if any program attempt of the person is in INTERMIT state and the
736: -- intermission type has the study at another institution flag set
737: CURSOR cur_inst(cp_person_id igs_fi_parties_v.person_id%TYPE,
738: cp_crs_stat igs_en_stdnt_ps_att.course_attempt_status%TYPE) IS
739: SELECT 'x'
740: FROM igs_en_stdnt_ps_att spa,
741: igs_en_intm_types intm,
742: igs_en_stdnt_ps_intm spi

Line 740: FROM igs_en_stdnt_ps_att spa,

736: -- intermission type has the study at another institution flag set
737: CURSOR cur_inst(cp_person_id igs_fi_parties_v.person_id%TYPE,
738: cp_crs_stat igs_en_stdnt_ps_att.course_attempt_status%TYPE) IS
739: SELECT 'x'
740: FROM igs_en_stdnt_ps_att spa,
741: igs_en_intm_types intm,
742: igs_en_stdnt_ps_intm spi
743: WHERE spa.person_id = cp_person_id
744: AND spa.person_id = spi.person_id

Line 756: FROM igs_en_stdnt_ps_att

752: -- status INACTIVE or ENROLLED. This validation is required to validate if the Person
753: -- is active in the system
754: CURSOR cur_crs(cp_person_id igs_fi_parties_v.person_id%TYPE) IS
755: SELECT 'x'
756: FROM igs_en_stdnt_ps_att
757: WHERE person_id = cp_person_id
758: AND course_attempt_status IN ('INACTIVE','ENROLLED');
759:
760: -- Cursor for getting the Fee Calendar Instance details.