Did the above query work out?

The logic i am using is as follows, find out the records of presidents whose tenure began after another president and who died after the current record president died.

I also think, it would need a recursive solution to since lead / lag values based solution looks at the values when the query was kicked off and doesnt get...

So what you are looking is to show exactly 1 record with a not null value for AccountingCode keeping all other fields intact.
You can try the following

The other utilizes the SSIS user parameter in the where clause. This one returns ORA-01745: invalid host/bind variable name. It looks like:
where a.term_code_key = :User::TermCode

How about you replace...