APPS.IGS_RE_VAL_RSUP dependencies on IGS_EN_STDNT_PS_ATT

Line 38: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

34: -- are mandatory or where the IGS_PS_COURSE is defined as
35: -- a research supervisor.
36: DECLARE
37: v_commencement_dt DATE;
38: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
39: v_candidature_exists_ind VARCHAR2(1);
40: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
41: CURSOR c_ca IS
42: SELECT ca.sca_course_cd,

Line 67: FROM IGS_EN_STDNT_PS_ATT sca

63: v_acai_rec c_acai%ROWTYPE;
64: CURSOR c_sca(
65: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
66: SELECT sca.version_number
67: FROM IGS_EN_STDNT_PS_ATT sca
68: WHERE sca.person_id = p_ca_person_id AND
69: sca.course_cd = cp_course_cd;
70: BEGIN
71: p_message_name := null;