ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471A151A9E05362FB09050512Y SELECT org.name ,people.employee_number ,people.full_name ,hr3.meaning disability_status ,job.name job_name ,pos.name position_name ,emp.name employment_office ,hr1.meaning disability_type ,hr2.meaning reason ,null pay_rate, PER_PERSADIS_XMLP_PKG.cf_1formula() CF_1 FROM per_all_assignments_f assg ,per_all_people_f people ,per_disabilities_f disb ,per_jobs job ,per_all_positions pos ,hr_lookups hr1 ,hr_lookups hr2 ,hr_lookups hr3 ,hr_all_organization_units org ,hr_all_organization_units emp WHERE assg.person_id = people.person_id AND assg.assignment_type = 'E' --AND NVL(:p_date,sysdate) BETWEEN assg.effective_start_date AND NVL(:p_date_t,sysdate) BETWEEN assg.effective_start_date AND assg.effective_end_date --AND NVL(:p_date,sysdate) between people.effective_start_date AND NVL(:p_date_t,sysdate) between people.effective_start_date AND people.effective_end_date --AND NVL(:p_date,sysdate) between disb.effective_start_date AND NVL(:p_date_t,sysdate) between disb.effective_start_date AND disb.effective_end_date AND assg.job_id = job.job_id(+) AND assg.position_id = pos.position_id(+) AND hr1.lookup_type = 'DISABILITY_CATEGORY' AND hr1.lookup_code = disb.category AND assg.organization_id = org.organization_id AND disb.person_id = people.person_id AND disb.dis_information_category = 'SA' AND disb.reason = hr2.lookup_code(+) AND hr2.lookup_type(+) = 'DISABILITY_REASON' AND disb.status = hr3.lookup_code AND hr3.lookup_type = 'DISABILITY_STATUS' &l_org_condition &l_type_condition &l_emp_office_condition &l_status_condition AND org.business_group_id = :p_business_group_id AND emp.organization_id = disb.dis_information1 ORDER BY org.name, disability_type, full_name PER PERSADIS_XML AR PER تقرير الموظف المعاق في السعودية (بتنسيق XML) Imported from BI Publisher Description: تقرير الموظف المعاق في السعودية Application: الموارد البشرية Source: تقرير الموظف المعاق في السعودية (بتنسيق XML) Short Name: PERSADIS_XML DB package: PER_PERSADIS_XMLP_PKG US PER Saudi Disabled Employee Imported from BI Publisher Description: Saudi Disabled Employee Report Application: Human Resources Source: Saudi Disabled Employee Report (XML) Short Name: PERSADIS_XML DB package: PER_PERSADIS_XMLP_PKG BI Publisher &l_emp_office_condition &l_org_condition &l_status_condition &l_type_condition :cp_1 :l_emp_office_condition :l_org_condition :l_status_condition :l_type_condition :p_business_group_id :p_conc_request_id :p_date :p_date_disp :p_date_t :p_disability_status :p_disability_type :p_emp_office :p_org_id :p_org_structure_id :p_org_structure_version_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال US Business Group Id 2 10 :p_org_structure_id LOV Oracle HR_SA_ORG_STRUCTURES Y select organization_structure_id id, name||decode(business_group_id,null,' (*)',null) value, null description from per_organization_structures where business_group_id=fnd_global.per_business_group_id or (business_group_id is null and (select p.business_group_id from per_security_profiles p where p.security_profile_id=fnd_global.per_security_profile_id) is null) order by name AR التدرج الوظيفي للمنشأة US Organization Hierarchy 3 20 :p_org_structure_version_id LOV Oracle HR_SA_ORG_STRUCT_VERSIONS Y select org_structure_version_id id, to_char(version_number) value, fnd_date.date_to_displaydate(date_to,calendar_aware=>2) description from per_org_structure_versions where organization_structure_id=:$flex$.hr_sa_org_structures order by date_from desc Y AR النسخة US Version 4 30 :p_org_id LOV Oracle HR_SA_ORG_STRUCT_ELEMENTS Y select organization_id id, name value, null description from hr_organization_units where (:$flex$.hr_sa_org_structures:null is not null and exists (select 1 from per_org_structure_elements e where e.org_structure_version_id=:$flex$.hr_sa_org_struct_versions:null and (e.organization_id_parent=organization_id or e.organization_id_child=organization_id))) or (:$flex$.hr_sa_org_structures:null is null) and business_group_id=fnd_global.per_business_group_id order by name AR المنشأة US Organization 5 40 :p_disability_type LOV Oracle HR_SA_DISABILITY_TYPE Y select lookup_code id, meaning value, null description from hr_lookups h,fnd_sessions s where lookup_type='DISABILITY_CATEGORY' and enabled_flag='Y' and session_id=userenv('SESSIONID') and s.effective_date between nvl(h.start_date_active,s.effective_date) and nvl(end_date_active,s.effective_date) order by meaning AR نوع الإعاقة US Disability Type 6 50 :p_emp_office LOV Oracle HR_SA_EMPLOYMENT_OFFICE Y select organization_id id, name value, null description from hr_all_organization_units hou,fnd_sessions fs where hou.business_group_id=fnd_global.per_business_group_id and fs.session_id=userenv('sessionid') and fs.effective_date between hou.date_from and nvl(hou.date_to,to_date('4712/12/31','YYYY/MM/DD')) and hou.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information_context='CLASS' and hoi.org_information1='SA_EMPLOYMENT_OFFICE' and hoi.org_information2='Y') order by hou.name AR مكتب التوظيف US Employment Office 7 60 :p_disability_status LOV Oracle HR_SA_DISABILITY_STATUS Y select lookup_code id, meaning value, null description from hr_lookups h,fnd_sessions s where lookup_type='DISABILITY_STATUS' and enabled_flag='Y' and session_id=userenv('SESSIONID') and s.effective_date between nvl(h.start_date_active,s.effective_date) and nvl(end_date_active,s.effective_date) order by meaning AR حالة الإعاقة US Disability Status 8 70 :p_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('SESSIONID') AR التاريخ US Date