APPS.IGS_EN_VAL_SUSA dependencies on IGS_AD_PS_APPL_INST

Line 443: FROM IGS_AD_PS_APPL_INST acai,

439: susa.parent_sequence_number = p_sequence_number;
440: CURSOR c_acai_sca IS
441: SELECT acai.unit_set_cd,
442: acai.us_version_number
443: FROM IGS_AD_PS_APPL_INST acai,
444: IGS_EN_STDNT_PS_ATT sca
445: WHERE sca.person_id = p_person_id AND
446: sca.course_cd = p_course_cd AND
447: acai.person_id = sca.person_id AND

Line 635: FROM IGS_AD_PS_APPL_INST acai,

631: susa.end_dt IS NOT NULL;
632: CURSOR c_chk_us IS
633: SELECT acai.unit_set_cd,
634: acai.us_version_number
635: FROM IGS_AD_PS_APPL_INST acai,
636: IGS_EN_STDNT_PS_ATT sca
637: WHERE sca.person_id = p_person_id AND
638: sca.course_cd = p_course_cd AND
639: sca.person_id = acai.person_id AND