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_GEN_010 dependencies on IGS_CA_INST

Line 591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */

587: acaiuv.location_cd,
588: acaiuv.unit_class,
589: acaiuv.unit_mode;
590: CURSOR c_aav IS
591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */
592: FROM igs_ad_appl aav,
593: igs_ca_inst ca
594: WHERE aav.person_id = p_person_id AND
595: aav.admission_appl_number = p_admission_appl_number AND

Line 593: igs_ca_inst ca

589: acaiuv.unit_mode;
590: CURSOR c_aav IS
591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */
592: FROM igs_ad_appl aav,
593: igs_ca_inst ca
594: WHERE aav.person_id = p_person_id AND
595: aav.admission_appl_number = p_admission_appl_number AND
596: aav.acad_cal_type = ca.cal_type AND
597: aav.acad_ci_sequence_number = ca.sequence_number;