[Home] [Help]
73: FROM igs_en_stdnt_ps_att_all sca,
74: igs_ca_inst_all ci,
75: igs_ca_type ca,
76: igs_ca_stat cs,
77: igs_ca_inst_rel car,
78: igs_ps_ver_all pv
79: WHERE sca.person_id = cp_n_person_id
80: AND sca.course_cd = pv.course_cd
81: AND sca.version_number = pv.version_number
103: cai.start_dt start_dt,
104: cai.planning_flag planning_flag,
105: cai.schedule_flag schedule_flag
106: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
107: IGS_CA_INST_REL car,
108: IGS_CA_INST_ALL cai,
109: IGS_CA_TYPE ca,
110: IGS_CA_STAT cs
111: WHERE sca.person_id = cp_n_person_id