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

Line 718: FROM igs_en_stdnt_ps_att

714: --
715: CURSOR c_adm_sts IS
716: SELECT adm_admission_appl_number,
717: adm_sequence_number
718: FROM igs_en_stdnt_ps_att
719: WHERE person_id = p_person_id
720: AND course_cd = p_program_cd
721: AND version_number = p_program_version;
722: rec_adm_sts c_adm_sts%ROWTYPE;

Line 727: CURSOR c_padm_tr_req (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

723:
724: --
725: -- cursor to check whether the student has completed some post admission tracking requirements
726: -- As part of Bug 2343417 modified 'POST-ADM' to 'POST_ADMISSION'
727: CURSOR c_padm_tr_req (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,
730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS
731: SELECT 'TRUE'

Line 728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

724: --
725: -- cursor to check whether the student has completed some post admission tracking requirements
726: -- As part of Bug 2343417 modified 'POST-ADM' to 'POST_ADMISSION'
727: CURSOR c_padm_tr_req (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,
730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS
731: SELECT 'TRUE'
732: FROM igs_tr_item ti,

Line 729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,

725: -- cursor to check whether the student has completed some post admission tracking requirements
726: -- As part of Bug 2343417 modified 'POST-ADM' to 'POST_ADMISSION'
727: CURSOR c_padm_tr_req (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,
730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS
731: SELECT 'TRUE'
732: FROM igs_tr_item ti,
733: igs_tr_status ts

Line 730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS

726: -- As part of Bug 2343417 modified 'POST-ADM' to 'POST_ADMISSION'
727: CURSOR c_padm_tr_req (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
728: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
729: cp_adm_appl_number igs_en_stdnt_ps_att.adm_admission_appl_number%TYPE,
730: cp_adm_seq_number igs_en_stdnt_ps_att.adm_sequence_number%TYPE) IS
731: SELECT 'TRUE'
732: FROM igs_tr_item ti,
733: igs_tr_status ts
734: WHERE ts.tracking_status = ti.tracking_status

Line 757: igs_en_stdnt_ps_att spa

753: SELECT sci.intermission_type,
754: sci.start_dt
755: FROM igs_en_stdnt_ps_intm sci,
756: IGS_EN_INTM_TYPES eit,
757: igs_en_stdnt_ps_att spa
758: WHERE sci.person_id = p_person_id
759: AND sci.course_cd = p_program_cd
760: AND sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
761: AND sci.approved = eit.appr_reqd_ind