Salary History As of Year End

Summary

Salary History As of Year End

Content

I have a requirement to display salary as of 31-Dec-YYYY (YYYY is the Year end date) .

Am able to get the value based on Calendar Year End .

I need to find the salary wherein Calendar Year End is between the Salary Start date and Salary End Date.

Could you throw some pointers on how to achieve it.

Code Snippet

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Payroll - Element Entries History Real Time"."Element"."Element Name" s_1,
   "Payroll - Element Entries History Real Time"."Element"."Employee Input Currency" s_2,
   "Payroll - Element Entries History Real Time"."Time"."Calendar Year End Date" s_3,
   "Payroll - Element Entries History Real Time"."Worker"."Assignment Status Type" s_4,
   "Payroll - Element Entries History Real Time"."Worker"."Person Number" s_5,
   CASE WHEN "Payroll - Element Entries History Real Time"."Input Value"."Input Value Name" ='Award Amount' AND "Payroll - Element Entries History Real Time"."Element"."Element Name" ='Global AIP Plan Earnings' THEN 'AIP