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_SCA dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 2800: from igs_en_stdnt_ps_att_all spa

2796: IS
2797: --cursor to fetch the program attempts for the admission application in context
2798: Cursor cur_spa(cp_rowid ROWID) IS
2799: Select spa.rowid,spa.*
2800: from igs_en_stdnt_ps_att_all spa
2801: where spa.rowid = cp_rowid;
2802:
2803: --cursor to check if any unit attempts other than unconfirmed unit attempts
2804: --exist for a program attempt

Line 3215: from igs_en_stdnt_ps_att_all spa

3211: cp_adm_appl_number NUMBER,
3212: cp_adm_nom_course_cd VARCHAR2,
3213: cp_adm_sequence_num NUMBER) IS
3214: Select spa.rowid
3215: from igs_en_stdnt_ps_att_all spa
3216: where spa.person_id=cp_person_id
3217: and spa.adm_admission_appl_number=cp_adm_appl_number
3218: and spa.adm_nominated_course_cd=cp_adm_nom_course_cd
3219: and spa.adm_sequence_number = cp_adm_sequence_num;

Line 3224: FROM igs_en_stdnt_ps_att_all spa

3220:
3221: -- Get the details of
3222: CURSOR cur_spa_en IS
3223: SELECT spa.rowid
3224: FROM igs_en_stdnt_ps_att_all spa
3225: WHERE spa.person_id = p_person_id
3226: AND spa.course_cd = p_nominated_course_cd;
3227:
3228: l_message VARCHAR2(200);