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 8E2FF36EDF0779D2E0530100007F1FF2 PER Employee Y Y select ppx.full_name value, (select fu.user_name from fnd_user fu where ppx.person_id=fu.employee_id and rownum=1) description from per_people_x ppx, per_assignments_x pax where ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' order by ppx.full_name US 9847A65C47978DC3E053B46B6358EA94 select distinct haouv.name business_group, papf.employee_number, papf.full_name, ppa.effective_date payroll_run_date, ptp.period_name, sum(decode(pec.classification_name,'Earnings',to_number(prrv.result_value))) earnings, sum(decode(pec.classification_name,'Involuntary Deductions',to_number(prrv.result_value))) involuntary_deductions, sum(decode(pec.classification_name,'Employer Charges',to_number(prrv.result_value))) employer_charges, sum(decode(pec.classification_name,'Information',to_number(prrv.result_value))) information, papf.employee_number||' - '||papf.full_name employee_number_and_name from hr_all_organization_units_vl haouv, (select papf.* from per_all_people_f papf where :effective_date between papf.effective_start_date and papf.effective_end_date) papf, (select paaf.* from per_all_assignments_f paaf where :effective_date between paaf.effective_start_date and paaf.effective_end_date) paaf, pay_assignment_actions pas, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv, (select petf.* from pay_element_types_f petf where :effective_date between petf.effective_start_date and petf.effective_end_date) petf, (select pivf.* from pay_input_values_f pivf where :effective_date between pivf.effective_start_date and pivf.effective_end_date) pivf, per_time_periods ptp, pay_element_classifications_vl pec where 1=1 and haouv.organization_id=paaf.business_group_id and papf.person_id=paaf.person_id and paaf.assignment_id=pas.assignment_id and pas.assignment_action_id=prr.assignment_action_id and ppa.payroll_action_id=pas.payroll_action_id and prr.element_type_id=petf.element_type_id and pivf.element_type_id=petf.element_type_id and prrv.run_result_id=prr.run_result_id and prrv.input_value_id=pivf.input_value_id and ptp.time_period_id=ppa.time_period_id and petf.classification_id=pec.classification_id and pivf.name='Pay Value' group by haouv.name, papf.employee_number, papf.person_id, papf.full_name, ppa.time_period_id, ppa.effective_date, ptp.period_name, paaf.organization_id order by papf.employee_number Y AR PAY Employee Payroll History تقرير البيانات الرئيسي بسطر واحد لكل موظف بما في ذلك رقم الموظف والاسم وفترة الرواتب والأرباح. D PAY Employee Payroll History Stammdatenbericht mit einer Zeile pro Mitarbeiter mit Mitarbeiternummer, Name, Abrechnungszeitraum und Verdienst. E PAY Employee Payroll History Informe de datos maestros con una línea por empleado que incluye el número de empleado, el nombre, el período de la nómina y los ingresos. F PAY Employee Payroll History Rapport des données de base avec une ligne par employé comprenant le numéro d'employé, le nom, la période de paie et les revenus. I PAY Employee Payroll History Rapporto dei dati anagrafici con una riga per dipendente che include il numero del dipendente, il nome, il periodo di paga e i guadagni. JA PAY Employee Payroll History 従業員番号、氏名、給与計算期間、収益など、従業員1人につき1行のマスターデータレポート。 KO PAY Employee Payroll History 직원 번호, 이름, 급여 기간 및 수입을 포함하여 직원당 한 줄의 마스터 데이터 보고서. PTB PAY Employee Payroll History Relatório de dados mestre com uma linha por funcionário, incluindo número do funcionário, nome, período de folha de pagamento e rendimentos. RU PAY Employee Payroll History Отчет об основных данных с одной строкой на сотрудника, включающей номер сотрудника, его имя, период выплаты заработной платы и заработную плату. S PAY Employee Payroll History Huvuddatarapport med en rad per anställd inklusive medarbetarnummer, namn, löneperiod och inkomst. TR PAY Employee Payroll History Çalışan numarası, adı, maaş bordrosu süresi ve kazançlar dahil olmak üzere çalışan başına bir satır içeren ana veri raporu. US PAY Employee Payroll History Master data report with one line per employee including employee number, name, payroll period and earnings. ZHS PAY Employee Payroll History 主数据报告，每个员工一行，包括员工编号、姓名、工资期和收入。 Enginatics 1=1 :effective_date 1 10 1=1 upper(papf.last_name) like upper(:last_name)||'%' LOV custom select distinct papf.last_name value, papf.full_name description from per_all_people_f papf order by papf.last_name F Le nom de famille commence par US Last Name starts with 2 20 1=1 papf.full_name=:full_name LOV PER Employee 8E2FF36EDF0779D2E0530100007F1FF2 Y Y select ppx.full_name value, (select fu.user_name from fnd_user fu where ppx.person_id=fu.employee_id and rownum=1) description from per_people_x ppx, per_assignments_x pax where ppx.employee_number is not null and ppx.current_employee_flag='Y' and ppx.person_id=pax.person_id and pax.primary_flag='Y' and pax.assignment_type='E' order by ppx.full_name US Full name 3 30 1=1 haouv.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 F Groupe d'entreprises US Business Group 4 40 1=1 ppa.effective_date>=:date_from Date F Date d'exécution de la paie du US Payroll Run Date From 5 50 1=1 ppa.effective_date<:date_to+1 Date F Date d'exécution de la paie au US Payroll Run Date To 6 60 :effective_date Date sysdate Y F Date d'entrée en vigueur US Effective Date