ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719F51A9E05362FB09050512 select papf.employee_number, papf.full_name EMP_NAME, PER_PERSAACK_XMLP_PKG.get_position(:P_PERSON_ID,:P_ISSUED_ON_DATE) POSITION, PER_PERSAACK_XMLP_PKG.get_grade(:P_PERSON_ID,:P_ISSUED_ON_DATE) GRADE, hr_sa_hijrah_functions.gregorian_to_hijrah(papf.effective_start_date) EMP_HIRE_DATE, hr_general.decode_lookup ('NATIONALITY',papf.nationality) NATIONALITY, hr_general.decode_lookup('CONTRACT_TYPE',PER_PERSAACK_XMLP_PKG.get_contract_type(:P_PERSON_ID,:P_ISSUED_ON_DATE)) CONTRACT_TYPE, PER_PERSAACK_XMLP_PKG.get_iqama_number(papf.person_id) IQAMA_NUMBER, :P_BASIC_SALARY BASIC_SAL, :P_TRANSPORTATION_ALLOWANCE TRANS_ALL, :P_WORK_NATURE_ALLOWANCE WORK_ALL, :P_SAFETY_ALLOWANCE SAFETY_ALL, :P_MOUNT_AREAS_ALLOWANCE MOUNT_ALL, :P_OTHER_ALLOWANCES OTHER_ALL, :P_LIVING_ALLOWANCE LIVING_ALL, PER_PERSAACK_XMLP_PKG.spell_number(:P_BASIC_SALARY) BASIC_SAL_WORDS, PER_PERSAACK_XMLP_PKG.spell_number(:P_TRANSPORTATION_ALLOWANCE) TRANS_ALLOWANCE_WORDS, PER_PERSAACK_XMLP_PKG.spell_number(:P_WORK_NATURE_ALLOWANCE) WORK_ALLOWANCE_WORDS, PER_PERSAACK_XMLP_PKG.spell_number(:P_SAFETY_ALLOWANCE) SAFETY_ALLOWANCE_WORDS, PER_PERSAACK_XMLP_PKG.spell_number(:P_MOUNT_AREAS_ALLOWANCE) MOUNT_ALLOWANCE_WORDS, PER_PERSAACK_XMLP_PKG.spell_number(:P_OTHER_ALLOWANCES) OTHER_ALLOWANCE_WORDS, hr_sa_hijrah_functions.gregorian_to_hijrah(:P_ISSUED_ON_DATE) ISSUED_ON_DATE from per_all_people_f papf where papf.person_id = :P_PERSON_ID and :P_ISSUED_ON_DATE between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE Y PER PERSAACK_XML AR PER خطاب إشعار الاستلام في المملكة العربية السعودية بتنسيق Imported from BI Publisher Description: خطاب إشعار الاستلام في المملكة العربية السعودية Application: الموارد البشرية Source: خطاب إشعار الاستلام في المملكة العربية السعودية بتنسيق (XML) Short Name: PERSAACK_XML DB package: PER_PERSAACK_XMLP_PKG US PER Saudi Acknowledgement Letter Imported from BI Publisher Description: Saudi Acknowledgement Letter Application: Human Resources Source: Saudi Acknowledgement Letter (XML) Short Name: PERSAACK_XML DB package: PER_PERSAACK_XMLP_PKG BI Publisher :lp_date :p_basic_salary :p_business_group_id :p_emp_issuing_letter :p_issued_on_date :p_letter_type :p_living_allowance :p_mount_areas_allowance :p_other_allowances :p_person_id :p_safety_allowance :p_transportation_allowance :p_work_nature_allowance 1 -10 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال US Business Group Id 2 10 :p_letter_type LOV Oracle SA_ACKNOWLEDGEMENT_TYPE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1027625 order by ffvv.flex_value AR نوع إشعار الاستلام US Acknowledgement Type 3 20 :p_issued_on_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id=USERENV('SESSIONID') US PY_SRS_EFFECTIVE_DATE 4 30 :p_person_id LOV Oracle SA_EMPLOYEE_LIST Y select papf.person_id id, papf.full_name value, null description from per_all_people_f papf where business_group_id=fnd_global.per_business_group_id and fnd_date.canonical_to_date(:$flex$.py_srs_effective_date) between papf.effective_start_date and papf.effective_end_date order by value,description Y AR الاسم بالكامل US Full Name 5 40 :p_basic_salary Number AR الراتب الأساسي US Basic Salary 6 50 :p_transportation_allowance Number AR بدل الانتقال US Transportation Allowance 7 60 :p_work_nature_allowance Number AR بدل طبيعة العمل US Work nature Allowance 8 70 :p_safety_allowance Number AR بدل السلامة US Safety Allowance 9 80 :p_mount_areas_allowance Number AR بدل المناطق الجبلية US Mountainous Areas Allowance 10 90 :p_living_allowance Number AR بدل المعيشة US Living Allowance 11 100 :p_other_allowances Number AR بدلات أخرى US Other Allowances 12 110 :p_emp_issuing_letter Char AR تم إصدار الخطاب بواسطة US Issued Letter by :$flex$.py_srs_effective_date PY_SRS_EFFECTIVE_DATE Y Full Name