APPS.IGS_AD_GEN_010 dependencies on IGS_AD_APPL_ADMAPPL_V

Line 565: v_acad_alternate_code IGS_AD_APPL_ADMAPPL_V.acad_alternate_code%TYPE;

561: -- for use on letters.
562: DECLARE
563: v_out_string VARCHAR2(200) DEFAULT NULL;
564: v_comm_period VARCHAR2(21) DEFAULT NULL;
565: v_acad_alternate_code IGS_AD_APPL_ADMAPPL_V.acad_alternate_code%TYPE;
566: CURSOR c_uv_acaiuv IS
567: SELECT acaiuv.unit_cd,
568: acaiuv.uv_version_number,
569: acaiuv.location_cd,

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