DBA Data[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_AS_ASSESSMNT_TYP

Line 270: cp_assessable_type igs_as_assessmnt_typ.assessment_type%TYPE,

266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,
267: cp_location_cd igs_ad_location.location_cd%TYPE,
268: cp_unit_mode igs_as_unit_class.unit_mode%TYPE,
269: cp_unit_class igs_as_unit_class.unit_class%TYPE,
270: cp_assessable_type igs_as_assessmnt_typ.assessment_type%TYPE,
271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE
272: ) IS
273: SELECT sua.person_id,
274: sua.course_cd,

Line 1764: IGS_AS_ASSESSMNT_TYP atyp

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
1768: uoo.version_number = uai.version_number AND