APPS.IGS_RE_WORKFLOW dependencies on IGS_EN_STDNT_PS_ATT

Line 1688: FROM igs_en_stdnt_ps_att

1684: --
1685: CURSOR cur_prog_ver ( p_person_id igs_pe_person.person_id%TYPE,
1686: p_course_cd igs_ps_ver.course_cd%TYPE)IS
1687: SELECT course_cd , version_number, attendance_type
1688: FROM igs_en_stdnt_ps_att
1689: WHERE person_id = p_person_id
1690: AND course_cd = p_course_cd ;
1691:
1692: CURSOR cur_def_milestone ( p_course_cd igs_re_dflt_ms_set.course_cd%TYPE,

Line 1865: FROM igs_en_stdnt_ps_att

1861: --
1862: CURSOR cur_prog_stat ( p_person_id igs_pe_person.person_id%TYPE,
1863: p_course_cd igs_ps_ver.course_cd%TYPE)IS
1864: SELECT course_attempt_status
1865: FROM igs_en_stdnt_ps_att
1866: WHERE person_id = p_person_id
1867: AND course_cd = p_course_cd ;
1868:
1869:

Line 2300: FROM igs_en_stdnt_ps_att spa, igs_re_candidature re

2296: -- and have a research record.
2297:
2298: CURSOR cur_prog_atmpt IS
2299: SELECT spa.person_id, spa.course_cd, re.sequence_number, spa.attendance_type, re.research_topic
2300: FROM igs_en_stdnt_ps_att spa, igs_re_candidature re
2301: WHERE spa.person_id = re.person_id
2302: AND spa.course_cd = re.sca_course_cd
2303: AND spa.course_attempt_status NOT IN ('LAPSED','DISCONTIN');
2304: