Sql query issue

Hi All,

We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should show. And we have only one employee with Not NULL. But when I am adding the condition it is reducing around 200-300 counts.

Condition:

	and PAAM.ASSIGNMENT_ID = PAEIM.ASSIGNMENT_ID(+)

	and PAEIM.EFFECTIVE_LATEST_CHANGE='Y'

	and PAEIM.INFORMATION_TYPE = 'Mobility'

	and PAEIM.AEI_ATTRIBUTE4 is NULL

	and :As_Of_Date between TRUNC(PAEIM.effective_start_date) and TRUNC(PAEIM.effective_end_date)

Attached the report catalog.