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.IGF_AP_GEN_001 dependencies on IGS_AD_APPL

Line 72: CURSOR adm_appl_cur(cp_person_id igs_ad_appl.person_id%TYPE,

68:
69: l_key_program key_program_dtl_cur%ROWTYPE;
70:
71: -- Get the calendar details passing the values obtained from above query
72: CURSOR adm_appl_cur(cp_person_id igs_ad_appl.person_id%TYPE,
73: cp_course_cd igs_ad_ps_appl_inst.course_cd%TYPE,
74: cp_crv_version_number igs_ad_ps_appl_inst.crv_version_number%TYPE ,
75: cp_location_cd igs_ad_ps_appl_inst.location_cd%TYPE,
76: cp_attendance_mode igs_ad_ps_appl_inst.attendance_mode%TYPE,

Line 81: FROM igs_ad_appl adm, igs_ad_ps_appl_inst acai

77: cp_attendance_type igs_ad_ps_appl_inst.attendance_type%TYPE )
78: IS
79: SELECT adm.acad_cal_type, adm.adm_cal_type adm_cal_type, adm.adm_ci_sequence_number adm_ci_sequence_number,
80: acai.expected_completion_yr,acai.expected_completion_perd
81: FROM igs_ad_appl adm, igs_ad_ps_appl_inst acai
82: WHERE adm.person_id = acai.person_id
83: AND adm.admission_appl_number = acai.admission_appl_number
84: AND adm.person_id = cp_PERSON_ID
85: AND acai.course_cd = cp_COURSE_CD