Issue with employee's line manager compensation plan approval status SQL query

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

we built the following query by filtering for an employee for testing purposes:

select ccpp.MGR_STATUS_CODE, ccpi.PERSON_ID, ccpi.WS_MGR_PERSON_ID
from CMP_PLANS_TL cpn, CMP_CWB_PERSON_INFO ccpi,CMP_CWB_POST_PERSON_SEL_V ccpp
where
cpn.PLAN_NAME='STMicroelectronics STI Multiplier Compensation Plan workshop 04102024'
AND cpn.LANGUAGE='US'
AND cpn.PLAN_ID=ccpi.PLAN_ID
AND ccpi.PLAN_ID=CCPP.PLAN_ID
AND CCPP.WS_MGR_PERSON_ID=ccpi.WS_MGR_PERSON_ID
AND CCPI.PERSON_ID='300000379848802'