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_ST_GEN_004 dependencies on IGS_EN_SU_ATTEMPT_H

Line 3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3032: ess.sua_ci_sequence_number = uoo.ci_sequence_number AND
3033: ess.sua_location_cd = uoo.location_cd AND
3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date

Line 3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3033: ess.sua_location_cd = uoo.location_cd AND
3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah
3042: WHERE suah.person_id = cp_person_id AND

Line 3041: FROM IGS_EN_SU_ATTEMPT_H suah

3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah
3042: WHERE suah.person_id = cp_person_id AND
3043: suah.course_cd = cp_course_cd AND
3044: suah.uoo_id = cp_uoo_id AND
3045: (suah.enrolled_dt IS NOT NULL OR

Line 3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3045: (suah.enrolled_dt IS NOT NULL OR
3046: suah.discontinued_dt IS NOT NULL)
3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date

Line 3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3046: suah.discontinued_dt IS NOT NULL)
3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah
3055: WHERE suah.person_id = cp_person_id AND

Line 3054: FROM IGS_EN_SU_ATTEMPT_H suah

3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah
3055: WHERE suah.person_id = cp_person_id AND
3056: suah.course_cd = cp_course_cd AND
3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;

Line 3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3056: suah.course_cd = cp_course_cd AND
3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date

Line 3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah
3066: WHERE suah.person_id = cp_person_id AND

Line 3065: FROM IGS_EN_SU_ATTEMPT_H suah

3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah
3066: WHERE suah.person_id = cp_person_id AND
3067: suah.course_cd = cp_course_cd AND
3068: suah.uoo_id = cp_uoo_id AND
3069: (suah.enrolled_dt IS NOT NULL OR