PER UAE Wage Protection System (Private Sector)

Description
Categories: BI Publisher, Human Resources
Application: Human Resources
Source: UAE Wage Protection System (Private Sector)
Short Name: PERAEWPS_XML
DB package: per_ae_wage_protection_pkg
    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'
Parameter Name SQL text Validation
Business Group Id
 
Number
Total Amount Paid to Employees
 
Number
Total No. of Emplyees not paid
 
Number
Total No. of Employees Paid
 
Number
Total Employees acc to Payroll
 
Number
Total Emplyees acc to Ministry
 
Number
Title
 
Name
 
Year
 
Month
 
Employer
 
LOV Oracle