PER Saudi Acknowledgement Letter

Description
Categories: BI Publisher
Columns: Employee Number, Emp Name, Position, Grade, Emp Hire Date, Nationality, Contract Type, Iqama Number, Basic Sal, Trans All ...
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 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
 
Business Group Id
 
Number