Query to get Absence Detail Employee wise
Query to get Absence Detail Employee wise. Approved Absence details.
SELECT papf.EMPLOYEE_NUMBER,papf.FULL_NAME,pat.NAME absence_type, paa.date_start leave_start_date,
paa.date_end leave_end_date, paa.absence_days, paa.abs_information_category,
paa.abs_information2, paa.abs_information3,paa.abs_information4
FROM per_absence_attendances paa,
per_absence_attendance_types pat,
per_all_people_f papf
WHERE paa.absence_attendance_type_id = pat.absence_attendance_type_id
AND papf.person_id = paa.person_id
AND TRUNC (paa.date_start) BETWEEN TRUNC(papf.effective_start_date)
AND TRUNC (papf.effective_end_date)
AND papf.EMPLOYEE_NUMBER=nvl(:p_employee_number,papf.EMPLOYEE_NUMBER)
order by papf.EMPLOYEE_NUMBER,paa.date_start
how to get the assignment details of employee who is sending the notification to manager in manager page we should have view button click on this button we should get details
when an employee apply for a transfer. the manager gets the notification.. When the manager clicks on the notification he gets the page for Approval. In the this page we have to keep a button on clicking it the details of the employee who applied for transfer we have get in oracle apps