Finds terms that are elegible to register, yet not after primary term end.

term_register.sql

SELECT
    sobterm_term_code
FROM
         sobterm
    JOIN sorrtrm ON sorrtrm_term_code = sobterm_term_code
    JOIN stvterm ON stvterm_code = sobterm_term_code
WHERE
    trunc(sysdate) BETWEEN sorrtrm_start_date AND sorrtrm_end_date
    AND sobterm_dynamic_sched_term_ind = 'Y'
    AND sobterm_reg_allowed = 'Y'
    AND trunc(stvterm_end_date) > trunc(sysdate);