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_AD_SS_GEN_001 dependencies on IGS_EN_UNIT_SET

Line 3394: FROM igs_ad_unit_sets us, igs_en_unit_set u

3390: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3391: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3392: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE, p_rank igs_ad_unit_sets.rank%TYPE) IS
3393: SELECT u.title
3394: FROM igs_ad_unit_sets us, igs_en_unit_set u
3395: WHERE us.person_id = p_person_id
3396: AND us.admission_appl_number = p_admission_appl_number
3397: AND us.nominated_course_cd = p_nominated_course_cd
3398: AND us.sequence_number = p_sequence_number

Line 3403: l_title igs_en_unit_set.title%TYPE;

3399: AND us.rank = p_rank
3400: AND us.unit_set_cd = u.unit_set_cd
3401: AND us.version_number = u.version_number;
3402:
3403: l_title igs_en_unit_set.title%TYPE;
3404:
3405: BEGIN
3406:
3407: OPEN cur_adm_unit_sets(p_person_id,