PER UAE Wage Protection System (Private Sector)
Description
- Categories
- BI Publisher
- Application
- Human Resources
- Source
- UAE Wage Protection System (Private Sector)
- Short Name
- PERAEWPS_XML
- DB package
- per_ae_wage_protection_pkg
Imported from BI Publisher
Monthly report for Wage protection system for UAE Private sector employers
Monthly report for Wage protection system for UAE Private sector employers
SQL 25 lines
SELECT hoi1.org_information2 legal_employer_number, hoi2.ORG_INFORMATION1 Employer_Reg_No, hoi2.ORG_INFORMATION2 Employer_Tele_No, hoi2.ORG_INFORMATION3 Employer_Fax_No, hoi2.ORG_INFORMATION4 Employer_Mobile_No FROM HR_ALL_ORGANIZATION_UNITS haou, HR_ORGANIZATION_INFORMATION hoi , HR_ORGANIZATION_INFORMATION hoi1, HR_ORGANIZATION_INFORMATION hoi2, HR_ALL_ORGANIZATION_UNITS_TL haout WHERE haou.business_group_id = :P_BUSINESS_GROUP_ID AND haou.organization_id = nvl(:P_EMPLOYER_ID,haou.organization_id) AND haou.organization_id = hoi.organization_id AND haou.organization_id = haout.organization_id AND hoi.org_information_context = 'CLASS' AND hoi.org_information1 = 'HR_LEGAL_EMPLOYER' AND hoi.org_information2 = 'Y' AND hoi.organization_id = hoi1.organization_id AND hoi1.org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS' AND hoi1.org_information6 = 'P' AND haout.language = userenv('LANG') AND hoi.organization_id = hoi2.organization_id AND hoi2.org_information_context = 'AE_LEGAL_EMPLOYER_CONTACT_DET' |
Parameters 10
| Parameter | Type | List of values SQL |
|---|---|---|
| Employer | LOV Oracle | |
| Month | Char | |
| Year | Char | |
| Name | Char | |
| Title | Char | |
| Total Emplyees acc to Ministry | Number | |
| Total Employees acc to Payroll | Number | |
| Total No. of Employees Paid | Number | |
| Total No. of Emplyees not paid | Number | |
| Total Amount Paid to Employees | Number |