APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_PS_OFR_OPT

Line 917: FROM IGS_PS_OFR_OPT coo

913: CURSOR c_coo IS
914: SELECT coo.location_cd,
915: coo.attendance_mode,
916: coo.attendance_type
917: FROM IGS_PS_OFR_OPT coo
918: WHERE coo.course_cd = p_course_cd AND
919: coo.version_number = p_crv_version_number AND
920: coo.cal_type = p_acad_cal_type AND
921: coo.delete_flag = 'N';