APPS.IGS_EN_GEN_012 dependencies on IGS_AS_SU_STMPTOUT

Line 894: FROM IGS_AS_SU_STMPTOUT suao

890: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
891: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
892: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
893: SELECT suao.person_id
894: FROM IGS_AS_SU_STMPTOUT suao
895: WHERE suao.person_id = cp_person_id AND
896: suao.course_cd = cp_course_cd AND
897: suao.uoo_id = cp_uoo_id;
898:

Line 1000: -- IGS_AS_SU_STMPTOUT records

996: p_discontinued_dt, v_sua.uoo_id) = 'Y'
997: OR v_sua.unit_attempt_status = 'WAITLISTED'
998: OR p_transf_course_cd IS NOT NULL) THEN
999: -- check to see whether child
1000: -- IGS_AS_SU_STMPTOUT records
1001: -- exist, otherwise a delete can not
1002: -- be performed on the IGS_EN_SU_ATTEMPT
1003: -- table
1004: OPEN c_suao_check(