“(SELECT e.siebleloginid, e.lastname || ', ’ || e.firstname AS employee,”+
“AS tierlevel FROM emadministration.tblemployeeinfo m, emadministration.tblemployeeinfo e,”+
“z.usernameman = m.username AND e.section = z.section AND e.employmentstatus = ‘Active’)”+
"DECODE (e.siebleloginid, m.siebleloginid, 1, 0 ) AS tierlevel FROM "+
“emadministration.tblzlistsectsup z WHERE m.siebleloginid =‘OLEMSUP’”+
“AND z.tempsupenddate >= TRUNC (SYSDATE - 0.25)))”+
“UNION (SELECT e.siebleloginid, e.lastname || ', ’ || e.firstname AS employee,”+
“FROM emadministration.tblemployeeinfo e, emadministration.tblzlistsectsup zm,”+
“e.employmentstatus = 'Active’AND e.username = zm.usernameman(+) AND”+
“ORDER BY tier DESC, employee”;
string str3 = “SELECT a.siebleloginid, a.employee, MAX (a.tierlevel) AS tier FROM”+ “DECODE (e.siebleloginid, m.siebleloginid, 2, DECODE (e.username, z.usernamesup, 1, 0) )”+“emadministration.tblzlistsectsup z WHERE m.siebleloginid =‘OLEMSUP’ AND”+"UNION (SELECT e.siebleloginid, e.lastname || ', ’ || e.firstname AS employee, "+“emadministration.tblemployeeinfo m, emadministration.tblemployeeinfo e,”+"AND (z.usernamesup = m.username OR (z.usernametempsup = m.username "+"AND e.section = z.section AND e.employmentstatus = ‘Active’) "+“DECODE (zm.usernameman, NULL, DECODE (zs.usernamesup, NULL, 0, 1),2) AS tierlevel”+ “emadministration.tblzlistsectsup zs WHERE e.siebleloginid =‘OLEMSUP’ AND”+“e.username = zs.usernamesup(+)) a GROUP BY a.siebleloginid, a.employee”+
