ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717F51A9E05362FB09050512 select full_name||decode(:P_SESSION_DATE,NULL,' (' || to_char(per.effective_start_date, 'DD-MON-YYYY')||')',NULL) FULL_NAME, decode(per.region_of_birth,null,'X',null) region_of_birth, decode(per.country_of_birth,null,'X',null) country_of_birth, decode(per.date_of_birth,null,'X',null) DOB, decode(asg.establishment_id,null,'X',null) estab, decode(asg.contract_id,null,'X',null) Contract, decode(scl.segment2,null,'X',null) Emp_cat from per_all_people_f per ,per_person_types pt ,per_assignments_f asg ,hr_soft_coding_keyflex scl where per.business_group_id = :p_business_group_id and nvl(:P_SESSION_DATE,per.effective_start_date) between per.effective_start_date and per.effective_end_date and asg.person_id = per.person_id and per.effective_start_date between asg.effective_start_date and asg.effective_end_date and scl.soft_coding_keyflex_id(+) = asg.soft_coding_keyflex_id and per.person_type_id = pt.person_type_id and pt.business_group_id = :p_business_group_id and pt.system_person_type = 'EMP' and (per.region_of_birth is NULL or per.country_of_birth is NULL or per.date_of_birth is NULL or per.sex is NULL or asg.establishment_id is NULL or asg.contract_id is NULL or scl.segment2 is NULL) order by per.order_name, per.effective_start_date Y PER PERFREMD_XML F PER Etat des informations manquantes d'employé Imported from BI Publisher Description: Etat des informations manquantes d'employé (Oracle HRMS France) Application: Human Resources Source: Etat des informations manquantes d'employé (XML) Short Name: PERFREMD_XML DB package: PER_PERFREMD_XMLP_PKG US PER Employee Missing Details Imported from BI Publisher Description: French HRMS employee missing details report Application: Human Resources Source: Employee Missing Details Report (XML) Short Name: PERFREMD_XML DB package: PER_PERFREMD_XMLP_PKG BI Publisher :cp_business_group_name :p_business_group_id :p_conc_request_id :p_session_date 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') F ID entité professionnelle Entité professionnelle actuelle US Business Group ID The current business group 2 10 :p_session_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id=userenv('sessionid') F Date de validité (vierge pour toutes dates) Date à laquelle valider les détails de l'employé. A laisser vierge pour obtenir un état pour toutes les dates. US Effective Date (Blank for All) The date to validate employee details on. Leave Blank to report on all dates