( SELECT HRS_SCREENING_ID ,DESCR ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D WHERE D.HRS_SCR_AFT_SUB <> 'Y' AND D.HRS_PRE_APP_SCR <> 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999998 ,COALESCE(E.MESSAGE_TEXT ,'Online Screening') ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1333 WHERE D.HRS_SCR_AFT_SUB = 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999997 ,COALESCE(E.MESSAGE_TEXT ,'Pre Screening') ,'N' ,'N' FROM PS_HRS_SCREEN_TBL D LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1332 WHERE D.HRS_PRE_APP_SCR = 'Y' AND D.STATUS='A') UNION ( SELECT 999999999999999 ,COALESCE(E.MESSAGE_TEXT ,'Additional Questions') ,'N' ,'N' FROM PS_INSTALLATION LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1334 )
|