APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 229: FROM igs_ca_teach_to_load_v

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
229: FROM igs_ca_teach_to_load_v
230: WHERE teach_cal_type= cp_teach_cal_type
231: AND teach_ci_sequence_number= cp_teach_ci_sequence_number;
232:
233:

Line 250: l_load_cal_type igs_ca_teach_to_load_v.load_cal_type%TYPE;

246: l_org_unit_start_dt igs_or_unit.start_dt%TYPE;
247: l_person_id_grp VARCHAR2(20);
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;

Line 251: l_load_cal_seq_num igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;

247: l_person_id_grp VARCHAR2(20);
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: