eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_TIMESLOTS dependencies on IGS_PS_TYPE

Line 1921: igs_ps_type pt

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
1925: pt.course_type_group_cd = p_prg_type_gr_cd AND

Line 1958: igs_ps_type_all pt,

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
1962: WHERE pv.course_cd = sca.course_cd AND

Line 1989: igs_ps_type_all pt2,

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