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_AS_GEN_006 dependencies on IGS_AS_ASSESSMNT_ITM

Line 1155: igs_as_assessmnt_itm ai,

1151: sua.uoo_id
1152: FROM
1153: igs_as_su_atmpt_itm suaai,
1154: igs_en_su_attempt sua,
1155: igs_as_assessmnt_itm ai,
1156: igs_as_unit_class uc
1157: WHERE
1158: (cp_person_id IS NULL OR suaai.person_id = cp_person_id)
1159: AND

Line 1371: FROM IGS_AS_ASSESSMNT_ITM

1367:
1368: CURSOR c_ai(
1369: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS
1370: SELECT description
1371: FROM IGS_AS_ASSESSMNT_ITM
1372: WHERE ass_id = cp_ass_id;
1373:
1374: v_last_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE := 0;
1375: v_last_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE := NULL;

Line 1763: IGS_AS_ASSESSMNT_ITM ai,

1759: IGS_GE_GEN_001.genp_clc_week_end_dt(uai.due_dt) uai_week_ending_dt
1760: FROM IGS_PS_UNIT_OFR_OPT uoo,
1761: -- IGS_AS_UNIT_CLASS uc,
1762: IGS_AS_UNITASS_ITEM uai,
1763: IGS_AS_ASSESSMNT_ITM ai,
1764: IGS_AS_ASSESSMNT_TYP atyp
1765: WHERE uoo.uoo_id = cp_uoo_id AND
1766: -- uoo.UNIT_CLASS = uc.UNIT_CLASS AND
1767: uoo.unit_cd = uai.unit_cd AND