PER UAE Wage Protection System (Private Sector)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Monthly report for Wage protection system for UAE Private sector employers
Application: Human Resources
Source: UAE Wage Protection System (Private Sector)
Short Name: PERAEWPS_XML
DB package: per_ae_wage_protection_pkg
Run PER UAE Wage Protection System (Private Sector) and other Oracle EBS reports with Blitz Report™ on our demo environment
    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
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
Download
Related Blitz Reports
CAC Internal Order Shipment Margin CAC Margin Analysis Summary CAC Material Overhead Setup ECC Project Manufacturing, On-Hand Values CAC Shipping Networks Missing Interco OU Relationships CAC Intransit Value (Real-Time) CAC Order Type Setup CAC WIP Jobs With Complete Status Which Are Ready for Close CAC WIP Account Value
Blitz Report™

Blitz Report™ provides multiple benefits: