APPS.IGS_PR_VAL_SCA dependencies on IGS_AS_SUAO_V

Line 360: v_max_outcome_dt IGS_AS_SUAO_V.outcome_dt%TYPE;

356: ------------------------------------------------------------------------------*/
357: gv_other_detail VARCHAR2(255);
358: BEGIN
359: DECLARE
360: v_max_outcome_dt IGS_AS_SUAO_V.outcome_dt%TYPE;
361: CURSOR c_suaov IS
362: SELECT MAX(suaov.outcome_dt)
363: FROM IGS_AS_SUAO_V suaov
364: WHERE suaov.person_id = p_person_id AND

Line 363: FROM IGS_AS_SUAO_V suaov

359: DECLARE
360: v_max_outcome_dt IGS_AS_SUAO_V.outcome_dt%TYPE;
361: CURSOR c_suaov IS
362: SELECT MAX(suaov.outcome_dt)
363: FROM IGS_AS_SUAO_V suaov
364: WHERE suaov.person_id = p_person_id AND
365: suaov.course_cd = p_course_cd AND
366: suaov.finalised_outcome_ind = 'Y';
367: BEGIN