APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_USO_INSTRCTRS

Line 171: igs_ps_uso_instrctrs usoi ,

167: CURSOR cur_time_conflct(cp_start_time DATE , cp_end_time DATE) IS
168: SELECT uso.row_id , uso.unit_section_occurrence_id , uso.monday,uso.tuesday,uso.wednesday,
169: uso.thursday,uso.friday,uso.saturday , uso.sunday,uso.start_date,uso.end_date
170: FROM igs_ps_usec_occurs uso ,
171: igs_ps_uso_instrctrs usoi ,
172: igs_ps_unit_ofr_opt uoo ,
173: igs_ca_inst ci
174: WHERE usoi.instructor_id = p_person_id AND
175: usoi.unit_section_occurrence_id <> p_unit_section_occurrence_id AND

Line 367: igs_ps_uso_instrctrs usoi ,

363: uso.end_time,
364: uoo.cal_type,
365: uoo.ci_sequence_number
366: FROM igs_ps_usec_occurs uso,
367: igs_ps_uso_instrctrs usoi ,
368: igs_ps_unit_ofr_opt uoo ,
369: igs_ca_inst ci
370: WHERE usoi.instructor_id = p_person_id AND
371: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND

Line 395: igs_ps_uso_instrctrs usoi ,

391: uso.end_time,
392: uoo.cal_type,
393: uoo.ci_sequence_number
394: FROM igs_ps_usec_occurs uso,
395: igs_ps_uso_instrctrs usoi ,
396: igs_ps_unit_ofr_opt uoo ,
397: igs_ca_inst ci
398: WHERE usoi.instructor_id > -1 AND
399: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND