select * from CI_ALGuploaded by Nuno Rodrigues
select * from CI_ALG where ALG_CD = 'XXXX'uploaded by Nuno Rodrigues
SELECT ALG.ALG_CD, ALGP.* FROM CI_ALG ALG, CI_ALG_PARM ALGP WHERE ALG.ALG_CD = 'INSERT_ALGORITHM_CODE' AND ALGP.ALG_CD = ALG.ALG_CDuploaded by Nuno Rodrigues