SELECT A.SP_TYPE_CD, B.DESCR FROM CI_SA_SP_TYPE A, CI_SP_TYPE_L B WHERE A.SA_TYPE_CD = 'INSERT_SA_TYPE_CD' AND A.CIS_DIVISION = 'INSERT_CIS_DIVISION' AND A.SP_TYPE_CD = B.SP_TYPE_CD AND B.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'uploaded by Nuno Rodrigues