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 996E156AC68FED50E053B46B6358F508 select papf.employee_number, papf.first_name, papf.last_name, papf.full_name, papf.email_address, pbg.name business_group, paaf_new.effective_start_date change_date, pg_old.name old_grade, pg_new.name new_grade, pj_old.name old_job, pj_new.name new_job, (select pap.name from per_all_positions pap where pap.position_id=paaf_old.position_id) old_position, (select pap.name from per_all_positions pap where pap.position_id=paaf_new.position_id) new_position, papf.person_id, papf.effective_start_date person_start_date, papf.effective_end_date person_end_date from per_all_people_f papf, per_business_groups pbg, per_all_assignments_f paaf_old, per_all_assignments_f paaf_new, per_grades pg_old, per_grades pg_new, per_jobs pj_old, per_jobs pj_new where 1=1 and papf.person_id=paaf_old.person_id and papf.person_id=paaf_new.person_id and papf.business_group_id=pbg.business_group_id and paaf_old.person_id=paaf_new.person_id and paaf_old.assignment_type='E' and paaf_old.primary_flag='Y' and paaf_new.assignment_type='E' and paaf_new.primary_flag='Y' and paaf_old.grade_id=pg_old.grade_id and paaf_new.grade_id=pg_new.grade_id and paaf_old.grade_id<>paaf_new.grade_id and paaf_old.job_id=pj_old.job_id(+) and paaf_new.job_id=pj_new.job_id(+) and paaf_old.effective_end_date+1=paaf_new.effective_start_date Y AR PER Employee Grade Changes قائمة الموظفين مع تغييرات درجاتهم. D PER Employee Grade Changes Liste der Mitarbeiter mit ihren Besoldungsänderungen. E PER Employee Grade Changes Lista de empleados con sus cambios de grado. F PER Employee Grade Changes Liste des employés avec leurs changements de grade. I PER Employee Grade Changes Elenco dei dipendenti con i loro cambiamenti di grado. JA PER Employee Grade Changes グレードの変更があった社員の一覧です。 KO PER Employee Grade Changes 등급이 변경된 직원 목록입니다. PTB PER Employee Grade Changes Lista de funcionários com suas alterações de notas. RU PER Employee Grade Changes Список сотрудников со сменой классов. S PER Employee Grade Changes Lista över anställda med deras betygsändringar. TR PER Employee Grade Changes Not değişiklikleri ile çalışanların listesi. US PER Employee Grade Changes List of employees with their grade changes. ZHS PER Employee Grade Changes 职级变动的员工名单。 Enginatics 1=1 1 10 1=1 :effective_date between papf.effective_start_date and papf.effective_end_date and :effective_date between paaf_new.effective_start_date and paaf_new.effective_end_date Date sysdate F Date d'entrée en vigueur US Effective Date 2 200 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 F Groupe d'entreprises US Business Group