Need the list of RC_TO which do not have an AP BU Peoplesoft

Need the list of RC_TO which do not have an AP BU and Active one's

enter image description here

enter image description here

Table Names:

PSOWNER.PS_CF_ATTRIB_TBL,

PSOWNER.PS_DEPT_TBL.

I have written below SQL to find the which do not have AP BU

SELECT DISTINCT A.DEPTID
FROM PSOWNER.PS_DEPT_TBL A, PSOWNER.PS_CF_ATTRIB_TBL B
WHERE A.DEPTID = B.CHARTFIELD_VALUE AND A.EFF_STATUS = 'A' AND B.CF_ATTRIBUTE 开发者_高级运维NOT IN ('AP_BUSN_UNIT','GL_BUSN_UNIT');

enter image description here

After writing that SQL also I was getting Attributes AP_BUSN_UNIT Values in Attributes.

The requirement is to find the RC_TO that does not have an AP BU(which is showing blank in attributes or does not have an AP_BUSN_UNIT field).

Refer to Images for clarification