ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN DCB158084DFC6BF8E05362FB0905ED4EY select 1 from dual US PER EEO 2000 Headquarters Imported from Concurrent Program Application: Human Resources Source: EEO 2000 Headquarters Report Short Name: PEREE2K1_HQ Concurrent Program 1 -20 :p_business_group_id LOV Oracle HR_US_BUSINESS_GROUP_NAME Y select hou.business_group_id id, hou.name value, null description from hr_organization_units hou where hou.business_group_id= fnd_global.per_business_group_id and hou.organization_id=fnd_global.per_business_group_id order by hou.name Select hou.name from hr_organization_units hou where hou.business_group_id = fnd_global.per_business_group_id and hou.organization_id = fnd_global.per_business_group_id Y US Business Group Name Used in SRS Reporting 2 -10 :p_eeo1_report_type LOV Oracle HR_US_EEO1_REPORT_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='US_EEO1_REPORT_TYPE' and lookup_code in ('EST','US_CRP','SGL') order by meaning Select meaning from hr_lookups where lookup_type='US_EEO1_REPORT_TYPE' and lookup_code = 'US_CRP' Y US Report_Type Used in SRS Reporting 3 10 :p_payroll_period_date_start Date Y US Payroll_Period_Date_Start Used in SRS Reporting 4 20 :p_payroll_period_date_end Date Y US Payroll_Period_Date_End Used in SRS Reporting 5 30 :p_org_structure_version_id LOV Oracle HR_US_ORG_HIERARCHY Y select posv.org_structure_version_id id, pos.name value, null description from per_org_structure_versions posv,per_organization_structures pos where fnd_global.per_business_group_id= pos.business_group_id and pos.organization_structure_id= posv.organization_structure_id and posv.date_from<= to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') and (posv.date_to is null or (posv.date_to is not null and posv.date_to>= to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') )) order by value,description US Organization Hierarchy Organization Structure Versions 6 40 :p_eeo1_organization_id LOV Oracle HR_US_ORG_UNITS_HQ Y select hou.organization_id id, hou.name value, hou.name description from hr_organization_units hou where hou.business_group_id=fnd_global.per_business_group_id and to_date(:$flex$.payroll_period_date_start,'YYYY/MM/DD HH24:MI:SS')<= nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY')) and to_date(:$flex$.payroll_period_date_end,'YYYY/MM/DD HH24:MI:SS')>=hou.date_from and (:$flex$.report_type='US_CRP' and exists (select 1 from hr_organization_information hoi where hou.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='US_CRP' and hoi.org_information2='Y')) order by hou.name Y US Organization 7 50 :p_previous_audit_date_start Date US Previous Audit Start Date Used in SRS Reporting 8 60 :p_previous_audit_date_end Date US Previous Audit End Date Used in SRS Reporting