ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718F51A9E05362FB09050512Y Select pghn.hierarchy_node_id "Est_Node_Id" ,pghn.parent_hierarchy_node_id "Parent Node Id" ,upper(hlei1.lei_information1) "Est_Rep_Name" ,NVL(hlei2.lei_information10,'N') "Headquarters" ,upper(ltrim(rtrim(eloc.address_line_1))||' '|| ltrim(rtrim(eloc.address_line_2))||' '|| ltrim(rtrim(eloc.address_line_3))||' '|| ltrim(rtrim(eloc.town_or_city))||', '|| ltrim(rtrim(eloc.region_2))||' '|| ltrim(rtrim(eloc.postal_code))) "Estab Address", PER_PERUSE1L_XMLP_PKG.c_tot_actformula(pghn.hierarchy_node_id, NVL ( hlei2.lei_information10 , 'N' )) C_tot_act, PER_PERUSE1L_XMLP_PKG.c_report_emps_p c_report_emps, PER_PERUSE1L_XMLP_PKG.C_main_activity_p C_main_activity, PER_PERUSE1L_XMLP_PKG.C_tot_emps_p C_tot_emps from hr_location_extra_info hlei1 ,hr_location_extra_info hlei2 ,per_gen_hierarchy_nodes pghn ,hr_locations_all eloc where (hlei1.information_type = 'EEO-1 Specific Information' and hlei1.lei_information_category= 'EEO-1 Specific Information') and (hlei2.information_type = 'Establishment Information' and hlei2.lei_information_category= 'Establishment Information') and hlei1.location_id = hlei2.location_id and hlei1.location_id = pghn.entity_id and pghn.parent_hierarchy_node_id = :c_parent_node_id and pghn.node_type = 'EST' and eloc.location_id = pghn.entity_id and pghn.parent_hierarchy_node_id=:Parent_Node_Id PER PERRPE1L_XML US PER EEO Establishment Employment Listing Imported from BI Publisher Description: EEO Establishment Employment Listing Application: Human Resources Source: EEO Establishment Employment Listing (XML) Short Name: PERRPE1L_XML DB package: PER_PERUSE1L_XMLP_PKG BI Publisher :c_business_group_name :c_end_of_time :c_hierarchy_name :c_hierarchy_version_num :c_main_activity :c_maximum_no_of_employees :c_no_of_establishments :c_parent_node_id :c_parent_org_id :c_payroll_period_date_end :c_payroll_period_date_start :c_report_date :c_report_emps :c_report_year :c_tot_emps :default_activities_line1 :default_activities_line2 :default_activities_line3 :default_activities_line4 :p_audit_report :p_business_group_id :p_conc_request_id :p_hierarchy_id :p_hierarchy_version_id :p_maximum_no_of_employees :p_payroll_period_date :p_payroll_period_date_end :p_payroll_period_date_start :p_report_year :parent_node_id :tot_count_emps 1 -30 :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 -20 :p_maximum_no_of_employees Number 49 Y US Maximum No Of Employees Used in SRS Reporting 3 10 :p_payroll_period_date_start Date Y US Payroll Period Start Date Used in SRS Reporting 4 20 :p_payroll_period_date_end Date Y US Payroll Period End Date Used in SRS Reporting 5 30 :p_hierarchy_id LOV Oracle HR_US_GH_HIERARCHY_ID Y select pgh.hierarchy_id id, pgh.name value, null description from per_gen_hierarchy pgh where pgh.business_group_id=fnd_global.per_business_group_id order by value,description Y US Hierarchy_Name Used in SRS Reporting 6 40 :p_hierarchy_version_id LOV Oracle HR_US_GH_HIER_VERSION_ID Y select pgv.hierarchy_version_id id, pgh.name||' ver: '||pgv.version_number value, null description from per_gen_hierarchy pgh,per_gen_hierarchy_versions pgv where pgh.hierarchy_id=:$flex$.hierarchy_name and pgh.hierarchy_id=pgv.hierarchy_id and pgv.status='A' and pqh_generic_hierarchy_package.validate_vets_hierarchy (pgv.hierarchy_version_id)='Y' order by pgv.version_number Y US Hierarchy Version Used in SRS Reporting 7 50 :p_audit_report LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description N US Create Audit Report Create Audit Report Yes or No