PER Saudi Acknowledgement Letter

➜ Back to Library
Description
Categories: BI Publisher
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
 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
Parameter NameSQL textValidation
Acknowledgement Type
 
LOV Oracle
PY_SRS_EFFECTIVE_DATE
 
Date
Full Name
 
LOV Oracle
Basic Salary
 
Number
Transportation Allowance
 
Number
Work nature Allowance
 
Number
Safety Allowance
 
Number
Mountainous Areas Allowance
 
Number
Living Allowance
 
Number
Other Allowances
 
Number
Issued Letter by
 
Char
Download
Related Blitz Reports
PQH IPEDS Report - Employees By Assigned Position (EAP) - Part A(obsoleted) PER COBRA Expiration Letter MAD1 PA Missing Timecards PQH Annual Status PO Closeout Checklist Template TB GL Account Analysis (Drilldown)v2 PAY Payroll Reconciliation Detail AP Employee Update Program- Not Supported: Reserved For Future Use PAY IE Cheque Listing
Blitz Report™