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
Run PER Saudi Acknowledgement Letter and other Oracle EBS reports with Blitz Report™ on our demo environment
 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 Name SQL text Validation
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 PA Task - Revenue, Cost, Budgets by Resources PO Closeout Checklist Template PAY Payroll Reconciliation Detail AP Employee Update Program- Not Supported: Reserved For Future Use PAY IE Cheque Listing
Blitz Report™

Blitz Report™ provides multiple benefits: