APPS.IGS_EN_TIMESLOTS dependencies on HZ_PARTIES

Line 1955: SELECT sca.person_id person_id ,(select person_last_name from hz_parties where party_id = sca.person_id) last_name

1951: --2. Entered through Student Enrollments, having program attempt of status INACTIVE and is not
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,

Line 1987: SELECT sca2.person_id person_id ,(select person_last_name from hz_parties where party_id = sca2.person_id) last_name

1983: )
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