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_WRKFLOW_PKG dependencies on IGS_TR_STATUS

Line 1161: and t.tracking_status in (select tracking_status from igs_tr_status where s_tracking_status = 'ACTIVE')

1157: and i.nominated_course_cd = r.course_cd
1158: and i.admission_appl_number = r.admission_appl_number
1159: and i.sequence_number = r.sequence_number
1160: and r.tracking_id = t.tracking_id
1161: and t.tracking_status in (select tracking_status from igs_tr_status where s_tracking_status = 'ACTIVE')
1162: AND ((a.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
1163: AND ((a.ACAD_CAL_TYPE= l_acad_cal) AND (a.ACAD_CI_SEQUENCE_NUMBER= l_acad_cal_seq_num))
1164: AND ((a.ADM_CAL_TYPE= l_adm_cal) AND (a.ADM_CI_SEQUENCE_NUMBER= l_adm_cal_seq_num))
1165: AND (((a.ADMISSION_CAT = l_adm_cat) AND (a.S_ADMISSION_PROCESS_TYPE = l_adm_proc_type)

Line 1198: and t.tracking_status in (select tracking_status from igs_tr_status where s_tracking_status = 'ACTIVE')

1194: and i.nominated_course_cd = r.course_cd
1195: and i.admission_appl_number = r.admission_appl_number
1196: and i.sequence_number = r.sequence_number
1197: and r.tracking_id = t.tracking_id
1198: and t.tracking_status in (select tracking_status from igs_tr_status where s_tracking_status = 'ACTIVE')
1199: AND ((a.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
1200: AND ((a.ACAD_CAL_TYPE = l_acad_cal) AND (a.ACAD_CI_SEQUENCE_NUMBER = l_acad_cal_seq_num))
1201: AND ((a.ADM_CAL_TYPE = l_adm_cal) AND (a.ADM_CI_SEQUENCE_NUMBER = l_adm_cal_seq_num))
1202: AND (((a.ADMISSION_CAT = l_adm_cat) AND (a.S_ADMISSION_PROCESS_TYPE = l_adm_proc_type)