APPS.IGS_AS_GEN_006 dependencies on IGS_AS_SU_STMPTOUT_ALL
Line 321: FROM igs_as_su_stmptout_all suao
317: AND sua.location_cd LIKE cp_location_cd
318: AND sua.unit_class LIKE cp_unit_class
319: AND NOT EXISTS (
320: SELECT 1 321: FROM igs_as_su_stmptout_all suao 322: WHERE suao.person_id = sua.person_id
323: AND suao.course_cd = sua.course_cd
324: AND suao.uoo_id = sua.uoo_id)
325: AND uv.unit_cd = sua.unit_cd