Lets say all the data resides in a table PS_TABLE_A.

Lets say AS_OF_DATE is held by a variable as_of_date.

Here goes the query:-

Select PROFESSOR, ASST_PROFFESSOR FROM PS_TABLE_A WHERE EFFDT< as_of_date OR EFFDT= as_of_date