APPS.IGS_AS_GEN_005 dependencies on IGS_AS_SU_STMPTOUT

Line 71: -- This module is called when ever the IGS_AS_SU_STMPTOUT.grade is

67: p_uoo_id IN NUMBER
68: ) RETURN BOOLEAN IS
69: gv_other_detail VARCHAR2 (255);
70: BEGIN -- assp_set_suao_trans
71: -- This module is called when ever the IGS_AS_SU_STMPTOUT.grade is
72: -- altered. It will check to see if a grade has had a translation performed
73: -- (translated_dt set), if so, then determine the translation for the new
74: -- grade. Where a grading schema has been recorded against the course
75: -- offering pattern, this will be used to perform the translation.

Line 99: FROM igs_as_su_stmptout suao

95: v_acad_ci_end_dt DATE;
96: v_message_name VARCHAR2 (30);
97: CURSOR c_suao IS
98: SELECT 'x'
99: FROM igs_as_su_stmptout suao
100: WHERE suao.person_id = p_person_id
101: AND suao.course_cd = p_course_cd
102: AND suao.uoo_id = p_uoo_id
103: AND suao.outcome_dt < p_outcome_dt