Here is the below query need to put some manual calculation formula. Can any one please help me in d — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Here is the below query need to put some manual calculation formula. Can any one please help me in d

edited Mar 25, 2020 11:31AM in Reporting and Analytics for HCM 2 comments

Summary

round(base_salary * 4.81%)

Content

SELECT 
DISTINCT(b.person_number) "EMPLOYEE No.",
b.person_id as "Unique_id",
(case when C.MIDDLE_NAMES is null then C.FIRST_NAME||' '||C.LAST_NAME
else
C.FIRST_NAME||' '||C.MIDDLE_NAMES||' '||C.LAST_NAME end) As "Full_Name",
c.TITLE "Personal Title",
(SELECT DISTINCT(L.NAME) FROM HR_ORGANIZATION_UNITS_F_TL L WHERE L.ORGANIZATION_ID = A.LEGAL_ENTITY_ID AND L.EFFECTIVE_START_DATE = (SELECT MAX(L1.EFFECTIVE_START_DATE) FROM HR_ORGANIZATION_UNITS_F_TL L1 WHERE L1.ORGANIZATION_ID = L.ORGANIZATION_ID)) AS "Legal_Employer",

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!