JG changes without real salary changes

Hi All,

 

When we do the Job Grade changes we need to update salary with the same date of the JG changes to see the right JG with the following part of the script.

 

“,to_number(substr((select pg.name

                       from hr.per_grades pg,

                       apps.per_assignments_f paf

                      WHERE pg.grade_id = paf.grade_id),1,(INSTR((SELECT pg.Name

                                                                    FROM hr.per_grades pg

                                                                   where pg.grade_id = paf.grade_id),'.'))-1))

                                                          GRADE”

 

    

If we don’t have the real salary changes we need to update the salary at least with a 0% of the salary increase to see the right pay lines of the salary by report.