5 lines
457 B
SQL
5 lines
457 B
SQL
SELECT AP.USERID
|
|
FROM OSIBANK.AGREE AG /*[PK:AGREENBR]*/
|
|
INNER JOIN OSIBANK.AGREEPERS AP ON AP.AGREENBR=AG.AGREENBR AND AP.ACTIVEYN='Y' /*[PK:AGREENBR, PERSNBR] [NEEDS TO BE ACTIVE]*/
|
|
INNER JOIN OSIBANK.AGREEPERSACCESSTYP APAT ON APAT.AGREENBR=AP.AGREENBR AND APAT.PERSNBR=AP.PERSNBR AND APAT.ACCESSTYPCD='WWW' AND APAT.ACTIVEYN='Y' /*[PK:AGREENBR, PERSNBR, ACCESSTYPCD('WWW')] [NEEDS TO BE ACTIVE]*/
|
|
WHERE AG.BYORGNBR IS NULL AND AP.PERSNBR = :personNumber |