APPS.IGS_CO_VAL_CCI dependencies on IGS_EN_STDNT_PS_ATT

Line 25: v_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;

21: BEGIN
22: DECLARE
23: e_required_parameters EXCEPTION;
24: e_both_must_be_set EXCEPTION;
25: v_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
26: v_correspondence_type IGS_CO_TYPE_JO.correspondence_type%TYPE;
27: CURSOR c_sca IS
28: SELECT sca.correspondence_cat
29: FROM IGS_EN_STDNT_PS_ATT sca

Line 29: FROM IGS_EN_STDNT_PS_ATT sca

25: v_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
26: v_correspondence_type IGS_CO_TYPE_JO.correspondence_type%TYPE;
27: CURSOR c_sca IS
28: SELECT sca.correspondence_cat
29: FROM IGS_EN_STDNT_PS_ATT sca
30: WHERE sca.person_id = p_person_id AND
31: sca.course_cd = p_course_cd AND
32: sca.correspondence_cat = p_correspondence_cat;
33: CURSOR c_cortjo IS

Line 40: FROM IGS_EN_STDNT_PS_ATT sca

36: WHERE cortjo.s_job_name = p_job_name AND
37: cortjo.output_num = p_output_num;
38: CURSOR c_sca2 IS
39: SELECT sca.correspondence_cat
40: FROM IGS_EN_STDNT_PS_ATT sca
41: WHERE sca.person_id = p_person_id AND
42: sca.course_cd = p_course_cd;
43: FUNCTION corpl_val_cci (
44: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,