DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_AS_UAI_SUA_V

Line 9882: FROM igs_as_uai_sua_v suv_dest ,

9878: cp_source_unit_ass_item_id NUMBER,
9879: cp_dest_course_cd VARCHAR2,
9880: cp_dest_uoo_id NUMBER) IS
9881: SELECT suv_dest.unit_ass_item_id
9882: FROM igs_as_uai_sua_v suv_dest ,
9883: igs_as_assessmnt_itm ai_dest,
9884: igs_as_uai_sua_v suv_source
9885: WHERE suv_dest.uai_logical_delete_dt is null
9886: and ai_dest.ass_id = suv_dest.ass_id

Line 9884: igs_as_uai_sua_v suv_source

9880: cp_dest_uoo_id NUMBER) IS
9881: SELECT suv_dest.unit_ass_item_id
9882: FROM igs_as_uai_sua_v suv_dest ,
9883: igs_as_assessmnt_itm ai_dest,
9884: igs_as_uai_sua_v suv_source
9885: WHERE suv_dest.uai_logical_delete_dt is null
9886: and ai_dest.ass_id = suv_dest.ass_id
9887: and suv_dest.person_id = cp_person_id
9888: and suv_dest.course_cd = cp_dest_course_cd