APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_EN_SU_ATTEMPT

Line 1193: FROM igs_en_su_attempt,

1189: p_course_cd VARCHAR2
1190: ) RETURN VARCHAR2 AS
1191: CURSOR c_sua_cmnt IS
1192: SELECT load_description
1193: FROM igs_en_su_attempt,
1194: igs_ca_teach_to_load_v
1195: WHERE person_id = p_person_id
1196: AND course_cd = p_course_cd
1197: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DUPLICATE', 'DISCONTIN')

Line 1204: FROM igs_en_su_attempt,

1200: ORDER BY load_start_dt ASC;
1201: --
1202: CURSOR c_sua_end IS
1203: SELECT load_description
1204: FROM igs_en_su_attempt,
1205: igs_ca_teach_to_load_v
1206: WHERE person_id = p_person_id
1207: AND course_cd = p_course_cd
1208: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DUPLICATE', 'DISCONTIN')