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_GEN_008 dependencies on IGS_EN_SU_ATTEMPT

Line 250: cp_person_id igs_en_su_attempt.person_id%TYPE,

246: v_version_number igs_as_su_stmptout.version_number%TYPE;
247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:
249: CURSOR c_suao (
250: cp_person_id igs_en_su_attempt.person_id%TYPE,
251: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
252: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
253: SELECT suao.grade,
254: suao.grading_schema_cd,

Line 251: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

247: v_s_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
248:
249: CURSOR c_suao (
250: cp_person_id igs_en_su_attempt.person_id%TYPE,
251: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
252: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
253: SELECT suao.grade,
254: suao.grading_schema_cd,
255: suao.version_number,

Line 252: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS

248:
249: CURSOR c_suao (
250: cp_person_id igs_en_su_attempt.person_id%TYPE,
251: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
252: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
253: SELECT suao.grade,
254: suao.grading_schema_cd,
255: suao.version_number,
256: suao.finalised_outcome_ind

Line 1254: FROM IGS_EN_SU_ATTEMPT sua,

1250: WHERE course_cd = sca.course_cd AND
1251: version_number = sca.version_number) AND
1252: NOT EXISTS (
1253: SELECT person_id
1254: FROM IGS_EN_SU_ATTEMPT sua,
1255: IGS_CA_INST_REL cr
1256: WHERE sua.person_id = sca.person_id AND
1257: sua.course_cd = sca.course_cd AND
1258: sua.cal_type = cr.sub_cal_type AND

Line 1371: FROM IGS_EN_SU_ATTEMPT sua,

1367: WHERE course_cd = acai.course_cd AND
1368: version_number = acai.crv_version_number ) AND
1369: NOT EXISTS (
1370: SELECT person_id
1371: FROM IGS_EN_SU_ATTEMPT sua,
1372: IGS_CA_INST_REL cr
1373: WHERE sua.person_id = acai.person_id AND
1374: sua.course_cd = acai.course_cd AND
1375: sua.cal_type = cr.sub_cal_type AND

Line 2557: FROM igs_en_su_attempt

2553: -- and Calendar Instance
2554: CURSOR cur_no_assessment_ind
2555: IS
2556: SELECT no_assessment_ind
2557: FROM igs_en_su_attempt
2558: WHERE person_id = p_person_id
2559: AND uoo_id = p_uoo_id
2560: AND cal_type = p_cal_type
2561: AND ci_sequence_number = p_ci_sequence_number;