APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_SU_ATTEMPT

Line 311: FROM igs_en_su_attempt sua,

307: CURSOR cur_load_teach_prd (p_person_id NUMBER,
308: p_cal_type VARCHAR2,
309: p_sequence_number NUMBER) IS
310: SELECT sua.unit_cd,sua.version_number,sua.override_enrolled_cp,sua.uoo_id
311: FROM igs_en_su_attempt sua,
312: igs_ca_inst_rel carel
313: WHERE sua.person_id = p_person_id and
314: sua.unit_attempt_status = 'ENROLLED' and
315: ((sua.cal_type = p_cal_type and

Line 1940: FROM IGS_EN_SU_ATTEMPT

1936: )
1937: OR
1938: ( sca.course_attempt_status = 'INACTIVE'
1939: AND EXISTS ( SELECT 'X'
1940: FROM IGS_EN_SU_ATTEMPT
1941: WHERE person_id = sca.person_id
1942: AND course_cd = sca.course_cd
1943: )
1944: )

Line 1997: (SELECT 'x' FROM igs_en_su_attempt_all sua

1993: pv2.course_cd = sca2.course_cd AND
1994: pv2.version_number = sca2.version_number AND
1995: sca2.course_attempt_status = 'INACTIVE' AND
1996: NOT EXISTS
1997: (SELECT 'x' FROM igs_en_su_attempt_all sua
1998: WHERE sua.person_id = sca2.person_id AND
1999: sua.course_cd = sca2.course_cd AND
2000: sua.course_cd = pv2.course_cd) AND
2001: igs_en_timeslots.acad_teach_rel_exist(sca2.cal_type,cp_cal_type,cp_seq_num) = 'TRUE' ;