Tip: SQL Query to check existence of HCM Enterprise

Summary

Tip: SQL Query to check existence of HCM Enterprise

Content

Tip: SQL Query to check existence of HCM Enterprise ,which can be used in data model.

select  name,organization_id,effective_start_date,effective_end_date
from fusion.hr_all_organization_units_x  
where organization_id  IN (select organization_id
from hr_org_unit_classifications_f 
where classification_code ='ENTERPRISE' 
and sysdate between effective_start_date and effective_end_date)

 

Regards,

Abhishek