APPS.IGS_CO_VAL_CCI dependencies on IGS_CO_TYPE_JO

Line 26: v_correspondence_type IGS_CO_TYPE_JO.correspondence_type%TYPE;

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
30: WHERE sca.person_id = p_person_id AND

Line 35: FROM IGS_CO_TYPE_JO cortjo

31: sca.course_cd = p_course_cd AND
32: sca.correspondence_cat = p_correspondence_cat;
33: CURSOR c_cortjo IS
34: SELECT cortjo.correspondence_type
35: FROM IGS_CO_TYPE_JO cortjo
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

Line 63: FROM IGS_CO_TYPE_JO cortjo

59: cci.correspondence_type = p_correspondence_type AND
60: cci.logical_delete_dt IS NULL;
61: CURSOR c_cortjo IS
62: SELECT cortjo.correspondence_type
63: FROM IGS_CO_TYPE_JO cortjo
64: WHERE cortjo.s_job_name = p_job_name AND
65: cortjo.output_num = p_output_num AND
66: cortjo.correspondence_type IN (
67: SELECT cci.correspondence_type