APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_PS_OFR_OPT

Line 57: FROM igs_ps_ofr_opt

53: -- Check if the program offering option with the values specified
54: -- in term record exists
55: cursor c_coo_valid IS
56: SELECT 'x'
57: FROM igs_ps_ofr_opt
58: WHERE coo_id = p_term_rec.coo_id
59: AND location_cd = p_term_rec.location_cd
60: AND version_number = p_term_rec.program_version
61: AND attendance_type = p_term_rec.attendance_type

Line 312: FROM igs_ps_ofr_opt

308: location_cd,
309: attendance_type,
310: attendance_mode,
311: cal_type
312: FROM igs_ps_ofr_opt
313: WHERE coo_id = p_coo_id;
314: BEGIN
315:
316: p_new_term_rec := p_old_term_rec;