APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_TIMESLOT_PARA

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

3068: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
3069: l_step_override BOOLEAN := FALSE;
3070: lv_timeslot_rec_found BOOLEAN := FALSE;
3071:
3072: CURSOR c_stud_timeslot (cp_cal_type igs_en_timeslot_para.cal_type%TYPE,
3073: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
3074: SELECT tr.start_dt_time,
3075: tr.end_dt_time
3076: FROM igs_en_timeslot_rslt tr,

Line 3073: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS

3069: l_step_override BOOLEAN := FALSE;
3070: lv_timeslot_rec_found BOOLEAN := FALSE;
3071:
3072: CURSOR c_stud_timeslot (cp_cal_type igs_en_timeslot_para.cal_type%TYPE,
3073: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
3074: SELECT tr.start_dt_time,
3075: tr.end_dt_time
3076: FROM igs_en_timeslot_rslt tr,
3077: igs_en_timeslot_para tp

Line 3077: igs_en_timeslot_para tp

3073: cp_sequence_number igs_en_timeslot_para.sequence_number%TYPE) IS
3074: SELECT tr.start_dt_time,
3075: tr.end_dt_time
3076: FROM igs_en_timeslot_rslt tr,
3077: igs_en_timeslot_para tp
3078: WHERE tr.person_id = p_n_person_id
3079: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
3080: AND tp.cal_type = cp_cal_type
3081: AND tp.sequence_number = cp_sequence_number;

Line 3079: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id

3075: tr.end_dt_time
3076: FROM igs_en_timeslot_rslt tr,
3077: igs_en_timeslot_para tp
3078: WHERE tr.person_id = p_n_person_id
3079: AND tr.igs_en_timeslot_para_id = tp.igs_en_timeslot_para_id
3080: AND tp.cal_type = cp_cal_type
3081: AND tp.sequence_number = cp_sequence_number;
3082: rec_stud_timeslot c_stud_timeslot%ROWTYPE;
3083: