APPS.IGS_EN_PLAN_UTILS dependencies on IGS_AS_SU_STMPTOUT

Line 2296: FROM igs_as_su_stmptout susv

2292: RETURN NUMBER IS
2293:
2294: CURSOR c_suao IS
2295: SELECT susv.mark
2296: FROM igs_as_su_stmptout susv
2297: WHERE
2298: susv.PERSON_ID = p_person_id AND
2299: susv.course_cd =p_course_cd AND
2300: susv.uoo_id = p_uoo_id AND

Line 2305: l_mark igs_as_su_stmptout.mark%TYPE;

2301: susv.finalised_outcome_ind = 'Y' and
2302: susv.grading_period_cd <> 'MIDTERM'
2303: ORDER BY susv.outcome_dt DESC ;
2304:
2305: l_mark igs_as_su_stmptout.mark%TYPE;
2306:
2307: BEGIN
2308: OPEN c_suao;
2309: FETCH c_suao INTO l_mark;

Line 2321: FROM igs_as_su_stmptout susv

2317: RETURN VARCHAR2 IS
2318:
2319: CURSOR c_suao IS
2320: SELECT susv.grade
2321: FROM igs_as_su_stmptout susv
2322: WHERE
2323: susv.PERSON_ID = p_person_id AND
2324: susv.course_cd =p_course_cd AND
2325: susv.uoo_id = p_uoo_id AND

Line 2330: l_grade igs_as_su_stmptout.grade%TYPE;

2326: susv.finalised_outcome_ind = 'Y' and
2327: susv.grading_period_cd <> 'MIDTERM'
2328: ORDER BY susv.outcome_dt DESC ;
2329:
2330: l_grade igs_as_su_stmptout.grade%TYPE;
2331:
2332: BEGIN
2333: OPEN c_suao;
2334: FETCH c_suao INTO l_grade;