APPS.IGS_SESSION_VALIDITY dependencies on IGS_EN_SPA_TERMS

Line 288: UPDATE igs_en_spa_terms spa SET spa.plan_sht_status = 'PLAN'

284: c_stud_cart_rec.course_cd,
285: c_stud_cart_rec.uoo_id)
286: LOOP
287:
288: UPDATE igs_en_spa_terms spa SET spa.plan_sht_status = 'PLAN'
289: WHERE spa.plan_sht_status = 'SUB_PLAN'
290: AND spa.person_id = c_stud_cart_rec.person_id
291: AND spa.program_cd = c_stud_cart_rec.course_cd
292: AND spa.term_cal_type = c_cal_type_rec.term_cal_type