Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Salary History As of Year End
Summary
Salary History As of Year EndContent
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
Tagged:
1