APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_CA_TYPE

Line 222: CURSOR cur_get_cal_cat (cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS

218: WHERE lkv.lookup_type = p_lookup_type AND
219: LKV.lookup_code = p_step;
220:
221:
222: CURSOR cur_get_cal_cat (cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS
223: SELECT s_cal_cat
224: FROM igs_ca_type
225: WHERE cal_type = cp_cal_type;
226:

Line 224: FROM igs_ca_type

220:
221:
222: CURSOR cur_get_cal_cat (cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS
223: SELECT s_cal_cat
224: FROM igs_ca_type
225: WHERE cal_type = cp_cal_type;
226:
227: CURSOR cur_load_cal (cp_teach_cal_type VARCHAR2, cp_teach_ci_sequence_number NUMBER) IS
228: SELECT load_cal_type,load_ci_sequence_number

Line 252: l_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;

248: l_person_id VARCHAR2(20);
249: l_step IGS_Lookups_view.meaning%TYPE;
250: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;
251: l_load_cal_seq_num igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;
252: l_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
253:
254: l_is_teach_cal BOOLEAN;
255:
256: --