DBA Data[Home] [Help]

APPS.IGS_PS_GEN_002 dependencies on IGS_AD_APPL

Line 111: FROM igs_ad_appl aav,

107:
108: CURSOR c_stu_crs_atmpt_from_appl (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
109: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
110: SELECT aav.acad_cal_type, acai.crv_version_number , acai.location_cd,acai.attendance_mode,acai.attendance_type
111: FROM igs_ad_appl aav,
112: igs_ad_ps_appl_inst acai
113: WHERE acai.person_id=cp_person_id AND acai.course_cd=cp_course_cd AND
114: aav.person_id = acai.person_id AND aav.admission_appl_number = acai.admission_appl_number;
115: