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

Summary

=IF((Base Salary

Content

SELECT 
DISTINCT(b.person_number) "EMPLOYEE No.",
b.person_id as "Unique_id",

(select salary_amount from 
cmp_salary
where 
assignment_id=a.assignment_id
and trunc(sysdate) between date_from and date_to) AS "SALARY",
NVL((select peevf.screen_entry_value 
from pay_element_entries_f peef, pay_element_entry_values_f peevf, pay_element_types_f petf
where peef.element_entry_id=peevf.element_entry_id
and peef.element_type_id=petf.element_type_id
and petf.base_element_name='Bonus Pay'
and peef.person_id=b.person_id
and trunc(sysdate) between peef.EFFECTIVE_START_DATE and peef.effective_end_date