APPS.IGS_EN_TIMESLOTS dependencies on IGS_PS_VER_ALL

Line 1957: igs_ps_ver_all pv,

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

Line 1988: FROM igs_ps_ver_all pv2,

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