2 queries found for "SP Type Language"

Retrieve SA Types SP Types

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

Retrieve SP/premises linked to account's active SAs

SELECT C.PREM_ID, C.SP_ID, D.SP_TYPE_CD, D.DESCR, E.ADDRESS1, E.CITY, E.STATE, E.POSTAL 
  FROM CI_SA A, CI_SA_SP B, CI_SP C, CI_SP_TYPE_L D, CI_PREM E
 WHERE A.ACCT_ID = 'INSERT_ACCOUNT_ID'  
   AND A.SA_STATUS_FLG < '60'
   AND A.SA_ID = B.SA_ID
   AND B.START_DTTM <= 'INSERT_EXPECTED_START_DATE'
   AND (B.STOP_DTTM >= 'INSERT_EXPECTED_STOP_DATE' OR B.STOP_DTTM IS NULL) 
   AND B.SP_ID = C.SP_ID
   AND C.SP_TYPE_CD = D.SP_TYPE_CD
   AND D.LANGUAGE_CD = :LANGUAGE
   and C.PREM_ID = E.PREM_ID
GROUP BY C.PREM_ID, C.SP_ID, D.SP_TYPE_CD, D.DESCR, E.ADDRESS1, E.CITY, E.STATE, E.POSTAL

uploaded by Nuno Rodrigues