Want to send Employee creation Alert

Hi All,

Alert is generated at the time of when new employee is created. here requirement is to send alert including Job, Grade, Location field as well. Currently alert is generated when the employee is created but job, location and grade is shown blank in alert.

SELECT papf.employee_number                                          employee_number,

       REPLACE(InitCap(papf.Title)||' '||papf.First_Name||' '||papf.Middle_Names||' '||papf.Last_Name, '  ', ' ') employee_name,

       papf.email_address                                            employee_email,

       papf.National_Identifier                                      employee_CNIC,

       to_char(paaf.CREATION_DATE, 'dd-mm-yyyy hh')                  creation_date,

       LOC.DESCRIPTION                         LOCATION,

       GRD.NAME                                GRADE,