Usually, you want to repeat header information as part of the key for each row. That way, the front end will consume the data and present it in the correct...

Wild guess:
Use aggregate functions.

SELECT DISTINCT     RTRIM(MAS.ID)    AS "EMPLOYEE ID"
          --,RTRIM(MAS.SSN)   AS "SSN"
          ,RTRIM(MAS.BDT)   AS "DATE OF BIRTH"
          ,MAX(CASE WHEN PXD.PYX_NO = 2111 THEN...

The best option is to use a tally table. Then you can work around that to keep only a certain range and use a certain interval.
Here's an example, but...

Your function has a problem when it's used against negative numbers. I wrote an article some time ago about this options which simulate CEILING and FLOOR. You can read it...