APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_EN_TIMESLOT_PARA

Line 1445: CURSOR c_stud_timeslot (cp_cal_type igs_en_timeslot_para.cal_type%TYPE,

1441:
1442: --
1443: -- cursor to fetch the timeslot associated with the student
1444: --
1445: CURSOR c_stud_timeslot (cp_cal_type igs_en_timeslot_para.cal_type%TYPE,
1446: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
1447: SELECT tr.start_dt_time,
1448: tr.end_dt_time
1449: FROM igs_en_timeslot_rslt tr,

Line 1446: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS

1442: --
1443: -- cursor to fetch the timeslot associated with the student
1444: --
1445: CURSOR c_stud_timeslot (cp_cal_type igs_en_timeslot_para.cal_type%TYPE,
1446: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
1447: SELECT tr.start_dt_time,
1448: tr.end_dt_time
1449: FROM igs_en_timeslot_rslt tr,
1450: igs_en_timeslot_para tp

Line 1450: igs_en_timeslot_para tp

1446: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
1447: SELECT tr.start_dt_time,
1448: tr.end_dt_time
1449: FROM igs_en_timeslot_rslt tr,
1450: igs_en_timeslot_para tp
1451: WHERE tr.person_id = p_person_id
1452: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
1453: AND tp.cal_type = cp_cal_type
1454: AND tp.sequence_number = cp_sequence_number;

Line 1452: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id

1448: tr.end_dt_time
1449: FROM igs_en_timeslot_rslt tr,
1450: igs_en_timeslot_para tp
1451: WHERE tr.person_id = p_person_id
1452: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
1453: AND tp.cal_type = cp_cal_type
1454: AND tp.sequence_number = cp_sequence_number;
1455: rec_stud_timeslot c_stud_timeslot%ROWTYPE;
1456: