ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9B79D2E0530100007F1FF2 PER Business Group Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US 998388D7D5AF8DCFE053B46B63584C20 select papf.employee_number, papf.full_name requester_name, pbg.name business_group, paat.name leave_type, paa.date_start Leave_Start, paa.date_end Leave_end, paa.date_notification, paa.creation_date approval_date, psth.last_update_date , papf1.full_name approver_name from per_all_people_f papf, per_business_groups pbg, per_absence_attendances paa, per_absence_attendance_types paat, pqh_ss_transaction_history psth, per_all_people_f papf1, fnd_user fu, pqh_ss_step_history pssh where 1=1 and sysdate between papf.effective_start_date and papf.effective_end_date and papf.business_group_id=pbg.business_group_id and papf.person_id=paa.person_id and paa.absence_attendance_type_id=paat.absence_attendance_type_id and paat.date_end is null and paa.absence_attendance_id=pssh.pk1 and pssh.transaction_history_id=psth.transaction_history_id and psth.process_name='HR_GENERIC_APPROVAL_PRC' and fu.user_id=paa.created_by and fu.employee_id=papf1.person_id and trunc(sysdate) between papf1.effective_start_date and papf1.effective_end_date order by 1,2,3,5 Y US PER Employee Approved Leave History Draft 1=1 1 10 1=1 pbg.name=:business_group LOV PER Business Group 8E2FF36EDE9B79D2E0530100007F1FF2 Y select pbg.name value, hla.location_code description from per_business_groups pbg, hr_locations_all hla where pbg.location_id=hla.location_id(+) order by pbg.name US Business Group