APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_UNIT_OFR_OPT

Line 172: igs_ps_unit_ofr_opt uoo ,

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
176: usoi.unit_section_occurrence_id = uso.unit_section_occurrence_id AND

Line 368: igs_ps_unit_ofr_opt uoo ,

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
372: uso.uoo_id = uoo.uoo_id AND

Line 396: igs_ps_unit_ofr_opt uoo ,

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
400: uso.uoo_id = uoo.uoo_id AND