--1. те, кто указан в employees в стороне договора явно
SELECT DISTINCT A.ID AS AGREEMENT_ID FROM AGREEMENT.AGREEMENT A
JOIN AGREEMENT.AGREEMENT_PARTY AP ON A.ID = AP.AGREEMENT_ID
JOIN AGR_PARTY_EMPLOYEE APE ON AP.ID = APE.AGREEMENT_PARTY_ID AND APE.EMPLOYEE_ID = ?;

--3. те, кто находится в листе согласования
SELECT ASE.AGR_SHEET_ID AS AGREEMENT_ID FROM AGREEMENT.AGR_SHEET_EMPLOYEE ASE
WHERE ASE.EMPLOYEE_ID = ?;