APPS.IGR_VAL_EAP dependencies on IGS_CA_TYPE

Line 116: FROM IGS_CA_TYPE

112: DECLARE
113: CURSOR c_ct (
114: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE) IS
115: SELECT s_cal_cat
116: FROM IGS_CA_TYPE
117: WHERE cal_type = cp_acad_cal_type;
118: CURSOR c_ci_cs (
119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS

Line 183: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

179: BEGIN
180: DECLARE
181: cst_admission CONSTANT VARCHAR2(10) := 'ADMISSION';
182: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
183: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
184: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
185: v_dummy VARCHAR2(1);
186: CURSOR c_cal_type (
187: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

Line 187: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

183: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
184: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
185: v_dummy VARCHAR2(1);
186: CURSOR c_cal_type (
187: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
188: SELECT cat.s_cal_cat
189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (

Line 189: FROM IGS_CA_TYPE cat

185: v_dummy VARCHAR2(1);
186: CURSOR c_cal_type (
187: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
188: SELECT cat.s_cal_cat
189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS