select distinct
papf.employee_number "Employee Number",
papf.full_name "Emp. Name",
paat.name "Leave Name",
paa.date_start "Start Date",
paa.date_end "End Date"
from per_all_people_f papf,
per_all_assignments_f paaf,
per_absence_attendance_types paat,
per_absence_attendances paa,
per_business_groups pbg
where papf.person_id = paaf.person_id
and paat.absence_attendance_type_id = paa.absence_attendance_id
and paa.person_id = papf.person_id
and pbg.business_group_id = paaf.business_group_id
order by 1 asc, date_start desc;
papf.employee_number "Employee Number",
papf.full_name "Emp. Name",
paat.name "Leave Name",
paa.date_start "Start Date",
paa.date_end "End Date"
from per_all_people_f papf,
per_all_assignments_f paaf,
per_absence_attendance_types paat,
per_absence_attendances paa,
per_business_groups pbg
where papf.person_id = paaf.person_id
and paat.absence_attendance_type_id = paa.absence_attendance_id
and paa.person_id = papf.person_id
and pbg.business_group_id = paaf.business_group_id
order by 1 asc, date_start desc;
No comments:
Post a Comment