ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471A751A9E05362FB09050512Y select decode( pzee.level_cat, 'Top Management', 'Top management', 'Senior Management', 'Senior management', 'Prof Qualified and Experienced Specialist and Mid-Management', 'Professionally qualified and experienced specialists and mid-management', 'Skilled, Academic, Jr Mgmt, Supervisors, Foremen and Supts', 'Skilled technical and academically qualified workers, junior management, supervisors, foremen, and superintendents', 'Semiskilled and Discretionary Decision Making', 'Semi-skilled and discretionary decision making', 'Unskilled and Defined Decision Making', 'Unskilled and defined decision making', 'Non-Renewal of Contract', 'Non-renewal of contract', 'Dismissal - Operational Requirements', 'retrenchment - Operational requirements', 'Dismissal - Misconduct', 'Dismissal - misconduct', 'Dismissal - Incapacity', 'Dismissal - incapacity', pzee.level_cat ) level_cat, pzee.level_cat_code level_cat_code, sum(nvl(pzee.ma,0)) ma, sum(nvl(pzee.mc,0)) mc, sum(nvl(pzee.mi,0)) mi, sum(nvl(pzee.mw,0)) mw, sum(nvl(pzee.fa,0)) fa, sum(nvl(pzee.fc,0)) fc, sum(nvl(pzee.fi,0)) fi, sum(nvl(pzee.fw,0)) fw, sum(nvl(pzee.total,0)) total, sum(nvl(pzee1.ma,0) + nvl(pzee1.mc,0) + nvl(pzee1.mi,0) + nvl(pzee1.mw,0)) fm, sum(nvl(pzee1.fa,0) + nvl(pzee1.fc,0) + nvl(pzee1.fi,0) + nvl(pzee1.fw,0)) ff, sum(nvl(pzee1.total,0)) f_total, sum(nvl(pzee1.total,0) + nvl(pzee.total,0)) all_total, PER_ZA_EE_WORKFORCE_PROFILE.CF_EQ2_ALL_TOTALFORMULA(:REPORT_ID,sum(nvl(pzee1.total,0) + nvl(pzee.total,0))) CF_EQ2_ALL_TOTAL from per_za_employment_equity pzee, per_za_employment_equity pzee1 where pzee.legal_entity_id = :LEGAL_ENTITY_ID and pzee.business_group_id = :P_BUSINESS_GROUP_ID and pzee.report_id = :REPORT_ID and pzee.legal_entity_id = pzee1.legal_entity_id and pzee.report_id ||'F' = pzee1.report_id and pzee.level_cat_code = pzee1.level_cat_code and pzee.level_cat = pzee1.level_cat and nvl(pzee.disability,'X') = nvl(pzee1.disability ,'X') and pzee.employment_type = pzee1.employment_type and pzee.employment_type = 'Permanent' and pzee.level_cat_code <> '15' group by pzee.level_cat,pzee.level_cat_code order by level_cat_code PER PERZAEWPXML US PER Employment Equity Workforce Profile (PDF) Imported from BI Publisher Description: Employment Equity - Workforce Profile Report Application: Human Resources Source: Employment Equity Workforce Profile (PDF) Short Name: PERZAEWPXML DB package: PER_ZA_EE_WORKFORCE_PROFILE BI Publisher :cp_from_date :cp_submission_date :cp_to_date :legal_entity_id :p_business_group_id :p_legal_entity_id :p_report_date :p_submission_date :report_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 10 :p_report_date Date SELECT effective_date FROM fnd_sessions WHERE session_id = USERENV('sessionid') Y US Report Date Effective Date 3 20 :p_legal_entity_id LOV Oracle PER_ZA_LEGAL_ENTITY Y select haou.organization_id id, haou.name value, null description from fnd_sessions fss,hr_all_organization_units haou,hr_organization_information hoi,hr_organization_information hoi2 where fss.session_id=userenv('sessionid') and fss.effective_date between haou.date_from and nvl(haou.date_to,to_date('31-12-4712','DD-MM-YYYY')) and haou.business_group_id=fnd_global.per_business_group_id and hoi.organization_id=haou.organization_id and hoi.org_information_context='ZA_LEGAL_ENTITY' and hoi2.organization_id=haou.organization_id and hoi2.org_information_context='CLASS' and hoi2.org_information1='HR_LEGAL' and hoi2.org_information2='Y' order by haou.name US Legal Entity Legal Entity 4 30 :p_submission_date Date SELECT effective_date FROM fnd_sessions WHERE session_id = USERENV('sessionid') Y US Report Submission Date Report Submission Date