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

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!