PER Saudi Acknowledgement Letter

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

 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