SELECT parameter1 emp_code, agentname (parameter1) emp_name,
       DECODE (emp_status,
               'A', 'active',
               'R', 'resigned',
               'Active'
              ) emp_status,
       create_datetime,
       (CASE
           WHEN TRUNC (create_datetime) < '01-Apr-2009'
              THEN 'Emp was coded before 01-Apr-2009'
        END
       ) code_remarks,
       (CASE
           WHEN (SELECT emp_flag
                   FROM emp_to_ter
                  WHERE emp_code = parameter1) = 'Y'
              THEN 'emp is converted to manager'
        END
       ) conversion_remarks,
       (CASE
           WHEN SUBSTR (parameter1, 1, 3) <> '20P'
              --AND agent_status = 'T'
        THEN parameter1 || ' is not Emp'
        END
       ) lg_remarks
  FROM t_upload a, emp_db b
 WHERE a.parameter1 = b.emp_code AND process = 'BLKRI';

(CASE
           WHEN TRUNC (create_datetime) < '01-Apr-2009'
              THEN 'Emp was coded before 01-Apr-2009'
        END
       ) code_remarks,

(CASE
           WHEN TRUNC (create_datetime) < to_date('01-Apr-2009', 'DD-Mon-YYYY')
              THEN 'Emp was coded before 01-Apr-2009'
        END
       ) code_remarks,