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_UC_EXPORT_TO_OSS dependencies on IGS_PE_PERSON

Line 1129: cp_person_id igs_pe_person.person_id%TYPE,

1125: CURSOR change_in_adm_appl_cur (
1126: cp_app_no igs_uc_app_choices.app_no%TYPE,
1127: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
1128: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
1129: cp_person_id igs_pe_person.person_id%TYPE,
1130: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS
1131: SELECT
1132: 'X'
1133: FROM

Line 2302: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS

2298: WHERE a.oss_person_id = b.party_id
2299: AND app_no = cp_app_no;
2300: l_app_dtls cur_app_dtls%ROWTYPE;
2301:
2302: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
2303: SELECT admission_appl_number,
2304: nominated_course_cd,
2305: sequence_number
2306: FROM igs_ad_ps_appl_inst_all

Line 2309: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS

2305: sequence_number
2306: FROM igs_ad_ps_appl_inst_all
2307: WHERE person_id = p_per_id;
2308:
2309: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
2310: SELECT COUNT(*)
2311: FROM igs_he_ad_dtl_all
2312: WHERE person_id = p_per_id;
2313:

Line 2314: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS

2310: SELECT COUNT(*)
2311: FROM igs_he_ad_dtl_all
2312: WHERE person_id = p_per_id;
2313:
2314: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
2315: SELECT had.ROWID ,had.*
2316: FROM igs_he_ad_dtl_all had
2317: WHERE person_id = l_per_id;
2318: