ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471A351A9E05362FB09050512Y SELECT org.name ,people.employee_number ,people.full_name ,pei.pei_information1 ip_number ,pei.pei_information2 profession ,pei.pei_information5 place_of_issue /*, fnd_date.canonical_to_date(pei.pei_information4) expiry_date,*/ , fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pei.pei_information4), calendar_aware=>1) expiry_date, PER_PERSAIPE_XMLP_PKG.cf_1formula() CF_1 FROM per_all_assignments_f assg ,per_all_people_f people ,per_people_extra_info pei ,hr_all_organization_units org WHERE assg.person_id = people.person_id AND assg.ASSIGNMENT_TYPE='E' AND NVL(:P_R_DATE,sysdate) BETWEEN assg.effective_start_date AND assg.effective_end_date AND NVL(:P_R_DATE,sysdate) between people.effective_start_date AND people.effective_end_date AND pei.person_id = people.person_id AND pei.information_type = :p_type and pei.pei_information_category =:p_type AND assg.organization_id = org.organization_id &l_org_condition AND org.business_group_id = :p_business_group_id AND pei.pei_information4 is not null AND (fnd_date.canonical_to_date(pei_information4)) BETWEEN NVL(:p_r_date,sysdate) AND DECODE(:P_EXP_UNITS,'D',(nvl(:P_DATE,sysdate)+:P_EXP), 'W',(nvl(:P_DATE,sysdate)+(:P_EXP*7)), 'M',(add_months(nvl(:P_DATE,sysdate),:P_EXP)), 'Y',(add_months(nvl(:P_DATE,sysdate),(:P_EXP*12)))) ORDER BY org.name, expiry_date, full_name PER PERSAPAS_XML AR PER تقرير انتهاء صلاحية جواز السفر في السعودية (بتنسيق XML) Imported from BI Publisher Description: تقرير انتهاء صلاحية جواز السفر في السعودية Application: الموارد البشرية Source: تقرير انتهاء صلاحية جواز السفر في السعودية (بتنسيق XML) Short Name: PERSAPAS_XML DB package: PER_PERSAIPE_XMLP_PKG US PER Saudi Passport Expiry Imported from BI Publisher Description: Saudi Passport Expiry Report Application: Human Resources Source: Saudi Passport Expiry Report (XML) Short Name: PERSAPAS_XML DB package: PER_PERSAIPE_XMLP_PKG BI Publisher &l_org_condition :cp_1 :l_org_condition :l_type_condition :p_business_group_id :p_conc_request_id :p_date :p_date_disp :p_exp :p_exp_units :p_org_id :p_org_structure_id :p_org_structure_version_id :p_r_date :p_type 1 -30 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال US Business Group Id 2 -20 :p_type Char SA_PASSPORT Y AR النوع US Type 3 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 4 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 5 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 6 40 :p_exp Number Y AR انتهاء الصلاحية في US Expires In 7 50 :p_exp_units LOV Oracle HR_SA_DURATION_UNITS Y select lookup_code id, meaning value, null description from hr_lookups h,fnd_sessions s where lookup_type='QUALIFYING_UNITS' 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 Y AR وحدات انتهاء الصلاحية في US Expires In Units 8 60 :p_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('SESSIONID') AR التاريخ US Date