DBA Data[Home] [Help]

APPS.IGS_PR_GEN_005 dependencies on IGS_EN_SU_ATTEMPT

Line 1309: FROM igs_en_su_attempt sua,

1305: AND scpc1.stream_num = scpc2.stream_num)
1306: )
1307: AND EXISTS ( -- Units must exist within the progression calendar.
1308: SELECT 'X'
1309: FROM igs_en_su_attempt sua,
1310: igs_ca_inst_rel cir
1311: WHERE sua.person_id = p_person_id
1312: AND sua.course_cd = p_course_cd
1313: AND cir.sup_cal_type = ci1.cal_type

Line 1548: FROM igs_en_su_attempt sua,

1544: sua.ci_sequence_number,
1545: sua.unit_attempt_status,
1546: sua.discontinued_dt,
1547: sua.uoo_id
1548: FROM igs_en_su_attempt sua,
1549: igs_ca_inst_rel cir
1550: WHERE sua.person_id = p_person_id
1551: AND sua.course_cd = p_course_cd
1552: AND sua.unit_attempt_status IN (cst_enrolled, cst_discontin, cst_completed)