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_PS_APPL_INST_PKG dependencies on IGS_AD_PRD_AD_PRC_CA

Line 415: FROM igs_ad_prd_ad_prc_ca admprd,

411: -- Following cursors added as part of Single Response build Bug:3132406
412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst
418: WHERE appl.person_id = new_references.person_id
419: AND appl.admission_appl_number = new_references.admission_appl_number

Line 431: igs_ad_prd_ad_prc_ca admprd

427: CURSOR get_aplinst_response_accepted IS
428: SELECT distinct appl.application_id, aplinst.nominated_course_cd
429: FROM igs_ad_appl_all appl,
430: igs_ad_ps_appl_inst aplinst,
431: igs_ad_prd_ad_prc_ca admprd
432: WHERE appl.person_id = aplinst.person_id
433: AND appl.admission_appl_number = aplinst.admission_appl_number
434: AND appl.person_id = new_references.person_id
435: AND igs_ad_gen_009.admp_get_sys_aors(aplinst.adm_offer_resp_status) = 'ACCEPTED'

Line 451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;

447: AND sequence_number = p_sequence_number;
448:
449:
450: l_appl_dt igs_ad_appl.appl_dt%TYPE;
451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
452: l_application_id igs_ad_appl_all.application_id%TYPE;
453: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
454: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;