APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 1956: FROM IGS_EN_STDNT_PS_ATT_ALL sca,

1952: -- having any unit attempts.
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,

Line 1990: IGS_EN_STDNT_PS_ATT_ALL sca2

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
1993: pv2.course_cd = sca2.course_cd AND
1994: pv2.version_number = sca2.version_number AND