Here is the below query need to put some manual calculation formula. Can any one please help me in d
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",