ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4728851A9E05362FB09050512 Select distinct rtrim(ppef.Full_name) Emp_Name, rtrim(ppef.Employee_number) Emp_number , pabs.Sickness_start_date Start_date , pabs.sickness_start_date order_date, paat.Name Sickness_type , nvl(ppay.Payroll_name,Null) Payroll from Per_absence_attendances pabs , Per_absence_attendance_types paat, Per_people_f ppef, Per_assignments_f pass , Pay_payrolls_f ppay where pass.payroll_id = ppay.payroll_id (+) and ppef.person_id = pass.person_id and pabs.sickness_start_date between pass.effective_start_date and pass.effective_end_date and pass.primary_flag = 'Y' and ppef.business_group_id = :P_bus_grp and pabs.person_id = ppef.person_id and pabs.sickness_start_date between ppef.effective_start_date and ppef.effective_end_date and pabs.absence_attendance_type_id = paat.absence_attendance_type_id and paat.Absence_category = 'S' and pabs.sickness_start_date is not null and pabs.sickness_end_date is null and ( (nvl(:P_payroll,-1) = -1 or pass.payroll_id = :P_payroll) or pass.payroll_id is null ) Order by 5, pabs.Sickness_start_date, rtrim(ppef.full_name) Y SSP SSPRPOAR_XML US SSP Open Sickness Absences Imported from BI Publisher Description: Open Sickness Absences Report Application: SSP Source: Open Sickness Absences Report (XML) Short Name: SSPRPOAR_XML DB package: SSP_SSPRPOAR_XMLP_PKG BI Publisher :c_business_group_name :c_payroll_name :p_bus_grp :p_conc_request_id :p_payroll :p_session_date 1 -20 :p_bus_grp Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Business Group 2 10 :p_payroll LOV Oracle PAY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name US Payroll Name Payroll Name 3 20 :p_session_date Date select effective_date from fnd_sessions where session_id = userenv('SESSIONID') Y US Session Date Session Date