APPS.IGS_CO_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 10: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

6: RETURN VARCHAR2 AS
7: BEGIN
8: DECLARE
9: CURSOR c_student_course_attempt(
10: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
11: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
12: SELECT CORRESPONDENCE_CAT
13: FROM IGS_EN_STDNT_PS_ATT
14: WHERE person_id = cp_person_id

Line 11: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

7: BEGIN
8: DECLARE
9: CURSOR c_student_course_attempt(
10: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
11: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
12: SELECT CORRESPONDENCE_CAT
13: FROM IGS_EN_STDNT_PS_ATT
14: WHERE person_id = cp_person_id
15: AND course_cd = cp_course_cd;

Line 13: FROM IGS_EN_STDNT_PS_ATT

9: CURSOR c_student_course_attempt(
10: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
11: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
12: SELECT CORRESPONDENCE_CAT
13: FROM IGS_EN_STDNT_PS_ATT
14: WHERE person_id = cp_person_id
15: AND course_cd = cp_course_cd;
16: v_correspondence_cat IGS_EN_STDNT_PS_ATT.CORRESPONDENCE_CAT%TYPE;
17: BEGIN

Line 16: v_correspondence_cat IGS_EN_STDNT_PS_ATT.CORRESPONDENCE_CAT%TYPE;

12: SELECT CORRESPONDENCE_CAT
13: FROM IGS_EN_STDNT_PS_ATT
14: WHERE person_id = cp_person_id
15: AND course_cd = cp_course_cd;
16: v_correspondence_cat IGS_EN_STDNT_PS_ATT.CORRESPONDENCE_CAT%TYPE;
17: BEGIN
18: IF NVL(p_course_cd, ' ') = ' ' THEN
19: RETURN NULL;
20: END IF;