[Home] [Help]
256:
257: CURSOR cur_prog_type(p_person_id NUMBER , p_course_type VARCHAR2 ) IS
258: SELECT sca.person_id
259: FROM igs_en_stdnt_ps_att sca,
260: igs_ps_ver pv
261: WHERE sca.person_id = p_person_id AND
262: sca.course_cd = pv.course_cd AND
263: sca.version_number = pv.version_number AND
264: pv.course_type = p_course_type;
265:
266: CURSOR cur_org_unit (p_person_id NUMBER , p_org_unit_cd VARCHAR2 ) IS
267: SELECT sca.person_id
268: FROM igs_en_stdnt_ps_att sca,
269: igs_ps_ver pv
270: WHERE sca.person_id = p_person_id AND
271: sca.course_cd = pv.course_cd AND
272: sca.version_number = pv.version_number AND
273: pv.responsible_org_unit_cd = p_org_unit_cd;
1916: CURSOR cur_total_enrled_stdnts(p_start_dt DATE ) IS
1917: SELECT DISTINCT (pe.person_id) person_id ,pe.last_name
1918: FROM igs_en_stdnt_ps_att sca,
1919: igs_pe_person_base_v pe,
1920: igs_ps_ver pv,
1921: igs_ps_type pt
1922: WHERE pe.person_id = sca.person_id AND
1923: pv.course_cd = sca.course_cd AND
1924: pv.course_type = pt.course_type AND
1953: CURSOR cur_total_admted_stdnts(cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE, cp_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1954:
1955: SELECT sca.person_id person_id ,(select person_last_name from hz_parties where party_id = sca.person_id) last_name
1956: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1957: igs_ps_ver_all pv,
1958: igs_ps_type_all pt,
1959: IGS_AD_PS_APPL_INST_all acai,
1960: IGS_AD_APPL_all aav,
1961: IGS_CA_INST_REL cir
1984: )
1985:
1986: UNION
1987: SELECT sca2.person_id person_id ,(select person_last_name from hz_parties where party_id = sca2.person_id) last_name
1988: FROM igs_ps_ver_all pv2,
1989: igs_ps_type_all pt2,
1990: IGS_EN_STDNT_PS_ATT_ALL sca2
1991: WHERE pt2.course_type_group_cd = p_prg_type_gr_cd AND
1992: pv2.course_type = pt2.course_type AND