[Home] [Help]
98: -- Global types
99: type r_assignments is record
100: (
101: payroll_id per_all_assignments_f.payroll_id%type,
102: legal_entity_id hr_all_organization_units.organization_id%type,
103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
99: type r_assignments is record
100: (
101: payroll_id per_all_assignments_f.payroll_id%type,
102: legal_entity_id hr_all_organization_units.organization_id%type,
103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
107: occupational_category hr_lookups.meaning%type,
118:
119: -- Added for Employment equity report enhancement
120: type r_Encome_diff_rec is record
121: (
122: legal_entity_id hr_all_organization_units.organization_id%type,
123: legal_entity hr_all_organization_units.NAME%type,
124: occupational_code_id hr_lookups.lookup_code%type,
125: occupational_code hr_lookups.meaning%type,
126: ma number,
119: -- Added for Employment equity report enhancement
120: type r_Encome_diff_rec is record
121: (
122: legal_entity_id hr_all_organization_units.organization_id%type,
123: legal_entity hr_all_organization_units.NAME%type,
124: occupational_code_id hr_lookups.lookup_code%type,
125: occupational_code hr_lookups.meaning%type,
126: ma number,
127: mc number,
151:
152: type rec_assignments is record
153: (
154: payroll_id per_all_assignments_f.payroll_id%type,
155: legal_entity_id hr_all_organization_units.organization_id%type,
156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
152: type rec_assignments is record
153: (
154: payroll_id per_all_assignments_f.payroll_id%type,
155: legal_entity_id hr_all_organization_units.organization_id%type,
156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
160: occupational_category hr_lookups.meaning%type,
1870: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
1871: from hr_lookups hl,
1872: hr_lookups hl1,
1873: hr_lookups hl2,
1874: hr_all_organization_units haou,
1875: per_assignment_extra_info paei,
1876: per_all_assignments_f paaf,
1877: per_all_people_f papf
1878: where papf.business_group_id = p_business_group_id
1953: 0 FI,
1954: 0 FW,
1955: 0 total
1956: from hr_lookups hl
1957: , hr_all_organization_units haou
1958: where not exists
1959: (
1960: select 'X'
1961: from per_za_employment_equity pzee
2010: 0 FI,
2011: 0 FW,
2012: 0 total
2013: from hr_lookups hl
2014: , hr_all_organization_units haou
2015: where not exists
2016: (
2017: select 'X'
2018: from per_za_employment_equity pzee
2089: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2090: from hr_lookups hl,
2091: hr_lookups hl1,
2092: hr_lookups hl2,
2093: hr_all_organization_units haou,
2094: per_assignment_extra_info paei,
2095: per_all_assignments_f paaf,
2096: per_all_people_f papf
2097: where papf.business_group_id = p_business_group_id
2171: 0 FI,
2172: 0 FW,
2173: 0 total
2174: from hr_lookups hl
2175: , hr_all_organization_units haou
2176: where not exists
2177: (
2178: select 'X'
2179: from per_za_employment_equity pzee
2229: 0 FI,
2230: 0 FW,
2231: 0 total
2232: from hr_lookups hl
2233: , hr_all_organization_units haou
2234: where not exists
2235: (
2236: select 'X'
2237: from per_za_employment_equity pzee
2326: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2327: from hr_lookups hl,
2328: hr_lookups hl1,
2329: hr_lookups hl2,
2330: hr_all_organization_units haou,
2331: per_assignment_extra_info paei,
2332: per_all_assignments_f paaf,
2333: per_all_people_f papf
2334: where papf.business_group_id = p_business_group_id
2418: 0 FI,
2419: 0 FW,
2420: 0 total
2421: from hr_lookups hl
2422: , hr_all_organization_units haou
2423: where not exists
2424: (
2425: select 'X'
2426: from per_za_employment_equity pzee
2475: 0 FI,
2476: 0 FW,
2477: 0 total
2478: from hr_lookups hl
2479: , hr_all_organization_units haou
2480: where not exists
2481: (
2482: select 'X'
2483: from per_za_employment_equity pzee
2573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2574: from hr_lookups hl,
2575: hr_lookups hl1,
2576: hr_lookups hl2,
2577: hr_all_organization_units haou,
2578: per_assignment_extra_info paei,
2579: per_all_assignments_f paaf,
2580: per_all_people_f papf
2581: where papf.business_group_id = p_business_group_id
2665: 0 FI,
2666: 0 FW,
2667: 0 total
2668: from hr_lookups hl
2669: , hr_all_organization_units haou
2670: where not exists
2671: (
2672: select 'X'
2673: from per_za_employment_equity pzee
2722: 0 FI,
2723: 0 FW,
2724: 0 total
2725: from hr_lookups hl
2726: , hr_all_organization_units haou
2727: where not exists
2728: (
2729: select 'X'
2730: from per_za_employment_equity pzee
2823: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2824: from hr_lookups hl,
2825: hr_lookups hl1,
2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,
2829: per_all_assignments_f paaf,
2830: per_periods_of_service ppos,
2831: per_all_people_f papf
2918: 0 FI,
2919: 0 FW,
2920: 0 total
2921: from hr_lookups hl
2922: , hr_all_organization_units haou
2923: where not exists
2924: (
2925: select 'X'
2926: from per_za_employment_equity pzee
2975: 0 FI,
2976: 0 FW,
2977: 0 total
2978: from hr_lookups hl
2979: , hr_all_organization_units haou
2980: where not exists
2981: (
2982: select 'X'
2983: from per_za_employment_equity pzee
3053: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3054: from hr_lookups hl,
3055: hr_lookups hl1,
3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,
3059: per_all_assignments_f paaf,
3060: per_periods_of_service ppos,
3061: per_all_people_f papf
3151: 0 FI,
3152: 0 FW,
3153: 0 total
3154: from hr_lookups hl
3155: , hr_all_organization_units haou
3156: where not exists
3157: (
3158: select 'X'
3159: from per_za_employment_equity pzee
3208: 0 FI,
3209: 0 FW,
3210: 0 total
3211: from hr_lookups hl
3212: , hr_all_organization_units haou
3213: where not exists
3214: (
3215: select 'X'
3216: from per_za_employment_equity pzee
3308: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3309: from hr_lookups hl,
3310: hr_lookups hl1,
3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,
3314: per_all_assignments_f paaf,
3315: per_periods_of_service ppos,
3316: per_all_people_f papf
3404: 0 FI,
3405: 0 FW,
3406: 0 total
3407: from hr_lookups hl
3408: , hr_all_organization_units haou
3409: where not exists
3410: (
3411: select 'X'
3412: from per_za_employment_equity pzee
3460: 0 FI,
3461: 0 FW,
3462: 0 total
3463: from hr_lookups hl
3464: , hr_all_organization_units haou
3465: where not exists
3466: (
3467: select 'X'
3468: from per_za_employment_equity pzee
3574: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3575: from hr_lookups hl,
3576: hr_lookups hl1,
3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,
3580: per_all_assignments_f paaf,
3581: per_periods_of_service ppos,
3582: per_all_people_f papf
3703: 0 FC,
3704: 0 FI,
3705: 0 FW,
3706: 0 total
3707: from hr_all_organization_units haou
3708: where not exists
3709: (
3710: select 'X'
3711: from per_za_employment_equity pzee
3773: 0 FC,
3774: 0 FI,
3775: 0 FW,
3776: 0 total
3777: from hr_all_organization_units haou
3778: where not exists
3779: (
3780: select 'X'
3781: from per_za_employment_equity pzee
4154: , p_fw IN number
4155: , p_total IN number
4156: , p_cat_index IN number
4157: , p_lev_index IN number
4158: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
4159: , p_occupational_level IN hr_lookups.meaning%type
4160: , p_occupational_category IN hr_lookups.meaning%type
4161: , p_occupational_level_id IN hr_lookups.lookup_code%type
4162: , p_occupational_category_id IN hr_lookups.lookup_code%type
4259:
4260: -- Procedure is used to sort the employee data
4261: -- and ready to inset into global tables
4262:
4263: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
4264: , p_occupational_level IN hr_lookups.meaning%type
4265: , p_occupational_category IN hr_lookups.meaning%type
4266: , p_race IN per_all_people_f.per_information4%type
4267: , p_sex IN per_all_people_f.sex%type
5172: , g_cat_Enc_Diff_table(l_rowind).fc
5173: , g_cat_Enc_Diff_table(l_rowind).fi
5174: , g_cat_Enc_Diff_table(l_rowind).fw
5175: , g_cat_Enc_Diff_table(l_rowind).total
5176: FROM hr_all_organization_units haou
5177: Where haou.organization_id = g_cat_Enc_Diff_table(l_rowind).legal_entity_id;
5178:
5179:
5180: INSERT INTO per_za_employment_equity
5215: , g_cat_Enc_Diff_table(l_rowind).fc_inc
5216: , g_cat_Enc_Diff_table(l_rowind).fi_inc
5217: , g_cat_Enc_Diff_table(l_rowind).fw_inc
5218: , g_cat_Enc_Diff_table(l_rowind).total_inc
5219: FROM hr_all_organization_units haou
5220: Where haou.organization_id = g_cat_Enc_Diff_table(l_rowind).legal_entity_id;
5221:
5222: l_rowind := g_cat_Enc_Diff_table.next(l_rowind);
5223: END loop;
5263: , g_lev_Enc_Diff_table(l_rowind).fc
5264: , g_lev_Enc_Diff_table(l_rowind).fi
5265: , g_lev_Enc_Diff_table(l_rowind).fw
5266: , g_lev_Enc_Diff_table(l_rowind).total
5267: FROM hr_all_organization_units haou
5268: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
5269:
5270: INSERT INTO per_za_employment_equity
5271: (
5305: , g_lev_Enc_Diff_table(l_rowind).fc_inc
5306: , g_lev_Enc_Diff_table(l_rowind).fi_inc
5307: , g_lev_Enc_Diff_table(l_rowind).fw_inc
5308: , g_lev_Enc_Diff_table(l_rowind).total_inc
5309: FROM hr_all_organization_units haou
5310: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
5311:
5312: l_rowind := g_lev_Enc_Diff_table.next(l_rowind);
5313: END loop;
5353: 0 FI,
5354: 0 FW,
5355: 0 total
5356: from hr_lookups hl
5357: , hr_all_organization_units haou
5358: where not exists
5359: (
5360: select 'X'
5361: from per_za_employment_equity pzee
5408: 0 FI,
5409: 0 FW,
5410: 0 total
5411: from hr_lookups hl
5412: , hr_all_organization_units haou
5413: where not exists
5414: (
5415: select 'X'
5416: from per_za_employment_equity pzee
5463: 0 FI,
5464: 0 FW,
5465: 0 total
5466: from hr_lookups hl
5467: , hr_all_organization_units haou
5468: where not exists
5469: (
5470: select 'X'
5471: from per_za_employment_equity pzee
5518: 0 FI,
5519: 0 FW,
5520: 0 total
5521: from hr_lookups hl
5522: , hr_all_organization_units haou
5523: where not exists
5524: (
5525: select 'X'
5526: from per_za_employment_equity pzee
5583: , p_fw IN number
5584: , p_total IN number
5585: , p_cat_index IN number
5586: , p_lev_index IN number
5587: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
5588: , p_occupational_level IN hr_lookups.meaning%type
5589: , p_occupational_category IN hr_lookups.meaning%type
5590: , p_occupational_level_id IN hr_lookups.lookup_code%type
5591: , p_occupational_category_id IN hr_lookups.lookup_code%type
5644:
5645: END ins_g_Enc_Diff_table;
5646:
5647:
5648: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
5649: , p_occupational_level IN hr_lookups.meaning%type
5650: , p_occupational_category IN hr_lookups.meaning%type
5651: , p_race IN per_all_people_f.per_information4%type
5652: , p_sex IN per_all_people_f.sex%type
6639: , g_lev_Enc_Diff_table(l_rowind).fc
6640: , g_lev_Enc_Diff_table(l_rowind).fi
6641: , g_lev_Enc_Diff_table(l_rowind).fw
6642: , g_lev_Enc_Diff_table(l_rowind).total
6643: FROM hr_all_organization_units haou
6644: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
6645:
6646: INSERT INTO per_za_employment_equity
6647: (
6681: , g_lev_Enc_Diff_table(l_rowind).fc_inc
6682: , g_lev_Enc_Diff_table(l_rowind).fi_inc
6683: , g_lev_Enc_Diff_table(l_rowind).fw_inc
6684: , g_lev_Enc_Diff_table(l_rowind).total_inc
6685: FROM hr_all_organization_units haou
6686: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
6687:
6688: l_rowind := g_lev_Enc_Diff_table.next(l_rowind);
6689: END loop;
6730: , g_lev_Enc_Diff_table_F(l_rowind).fc
6731: , g_lev_Enc_Diff_table_F(l_rowind).fi
6732: , g_lev_Enc_Diff_table_F(l_rowind).fw
6733: , g_lev_Enc_Diff_table_F(l_rowind).total
6734: FROM hr_all_organization_units haou
6735: Where haou.organization_id = g_lev_Enc_Diff_table_F(l_rowind).legal_entity_id;
6736:
6737: INSERT INTO per_za_employment_equity
6738: (
6772: , g_lev_Enc_Diff_table_F(l_rowind).fc_inc
6773: , g_lev_Enc_Diff_table_F(l_rowind).fi_inc
6774: , g_lev_Enc_Diff_table_F(l_rowind).fw_inc
6775: , g_lev_Enc_Diff_table_F(l_rowind).total_inc
6776: FROM hr_all_organization_units haou
6777: Where haou.organization_id = g_lev_Enc_Diff_table_F(l_rowind).legal_entity_id;
6778:
6779: l_rowind := g_lev_Enc_Diff_table_F.next(l_rowind);
6780: END loop;
6822: , g_lev_Enc_Diff_table_T(l_rowind).fc
6823: , g_lev_Enc_Diff_table_T(l_rowind).fi
6824: , g_lev_Enc_Diff_table_T(l_rowind).fw
6825: , g_lev_Enc_Diff_table_T(l_rowind).total
6826: FROM hr_all_organization_units haou
6827: Where haou.organization_id = g_lev_Enc_Diff_table_T(l_rowind).legal_entity_id;
6828:
6829: INSERT INTO per_za_employment_equity
6830: (
6864: , g_lev_Enc_Diff_table_T(l_rowind).fc_inc
6865: , g_lev_Enc_Diff_table_T(l_rowind).fi_inc
6866: , g_lev_Enc_Diff_table_T(l_rowind).fw_inc
6867: , g_lev_Enc_Diff_table_T(l_rowind).total_inc
6868: FROM hr_all_organization_units haou
6869: Where haou.organization_id = g_lev_Enc_Diff_table_T(l_rowind).legal_entity_id;
6870:
6871:
6872: l_rowind := g_lev_Enc_Diff_table_T.next(l_rowind);
6914: , g_lev_Enc_Diff_table_TF(l_rowind).fc
6915: , g_lev_Enc_Diff_table_TF(l_rowind).fi
6916: , g_lev_Enc_Diff_table_TF(l_rowind).fw
6917: , g_lev_Enc_Diff_table_TF(l_rowind).total
6918: FROM hr_all_organization_units haou
6919: Where haou.organization_id = g_lev_Enc_Diff_table_TF(l_rowind).legal_entity_id;
6920:
6921: INSERT INTO per_za_employment_equity
6922: (
6956: , g_lev_Enc_Diff_table_TF(l_rowind).fc_inc
6957: , g_lev_Enc_Diff_table_TF(l_rowind).fi_inc
6958: , g_lev_Enc_Diff_table_TF(l_rowind).fw_inc
6959: , g_lev_Enc_Diff_table_TF(l_rowind).total_inc
6960: FROM hr_all_organization_units haou
6961: Where haou.organization_id = g_lev_Enc_Diff_table_TF(l_rowind).legal_entity_id;
6962:
6963: l_rowind := g_lev_Enc_Diff_table_TF.next(l_rowind);
6964: END loop;
7005: 0 FI,
7006: 0 FW,
7007: 0 total
7008: from hr_lookups hl
7009: , hr_all_organization_units haou
7010: where not exists
7011: (
7012: select 'X'
7013: from per_za_employment_equity pzee
7061: 0 FI,
7062: 0 FW,
7063: 0 total
7064: from hr_lookups hl
7065: , hr_all_organization_units haou
7066: where not exists
7067: (
7068: select 'X'
7069: from per_za_employment_equity pzee
7117: 0 FI,
7118: 0 FW,
7119: 0 total
7120: from hr_lookups hl
7121: , hr_all_organization_units haou
7122: where not exists
7123: (
7124: select 'X'
7125: from per_za_employment_equity pzee
7173: 0 FI,
7174: 0 FW,
7175: 0 total
7176: from hr_lookups hl
7177: , hr_all_organization_units haou
7178: where not exists
7179: (
7180: select 'X'
7181: from per_za_employment_equity pzee
7457: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7458: from hr_lookups hl,
7459: hr_lookups hl1,
7460: hr_lookups hl2,
7461: hr_all_organization_units haou,
7462: per_assignment_extra_info paei,
7463: per_all_assignments_f paaf,
7464: per_all_people_f papf
7465: where papf.business_group_id = p_business_group_id
7540: 0 FI,
7541: 0 FW,
7542: 0 total
7543: from hr_lookups hl
7544: , hr_all_organization_units haou
7545: where not exists
7546: (
7547: select 'X'
7548: from per_za_employment_equity pzee
7597: 0 FI,
7598: 0 FW,
7599: 0 total
7600: from hr_lookups hl
7601: , hr_all_organization_units haou
7602: where not exists
7603: (
7604: select 'X'
7605: from per_za_employment_equity pzee
7676: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7677: from hr_lookups hl,
7678: hr_lookups hl1,
7679: -- hr_lookups hl2,
7680: hr_all_organization_units haou,
7681: per_assignment_extra_info paei,
7682: per_all_assignments_f paaf,
7683: per_all_people_f papf
7684: where papf.business_group_id = p_business_group_id
7758: 0 FI,
7759: 0 FW,
7760: 0 total
7761: from hr_lookups hl
7762: , hr_all_organization_units haou
7763: where not exists
7764: (
7765: select 'X'
7766: from per_za_employment_equity pzee
7816: 0 FI,
7817: 0 FW,
7818: 0 total
7819: from hr_lookups hl
7820: , hr_all_organization_units haou
7821: where not exists
7822: (
7823: select 'X'
7824: from per_za_employment_equity pzee
7913: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7914: from hr_lookups hl,
7915: hr_lookups hl1,
7916: -- hr_lookups hl2,
7917: hr_all_organization_units haou,
7918: per_assignment_extra_info paei,
7919: per_all_assignments_f paaf,
7920: per_all_people_f papf
7921: where papf.business_group_id = p_business_group_id
8005: 0 FI,
8006: 0 FW,
8007: 0 total
8008: from hr_lookups hl
8009: , hr_all_organization_units haou
8010: where not exists
8011: (
8012: select 'X'
8013: from per_za_employment_equity pzee
8062: 0 FI,
8063: 0 FW,
8064: 0 total
8065: from hr_lookups hl
8066: , hr_all_organization_units haou
8067: where not exists
8068: (
8069: select 'X'
8070: from per_za_employment_equity pzee
8160: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8161: from hr_lookups hl,
8162: hr_lookups hl1,
8163: -- hr_lookups hl2,
8164: hr_all_organization_units haou,
8165: per_assignment_extra_info paei,
8166: per_all_assignments_f paaf,
8167: per_all_people_f papf
8168: where papf.business_group_id = p_business_group_id
8252: 0 FI,
8253: 0 FW,
8254: 0 total
8255: from hr_lookups hl
8256: , hr_all_organization_units haou
8257: where not exists
8258: (
8259: select 'X'
8260: from per_za_employment_equity pzee
8309: 0 FI,
8310: 0 FW,
8311: 0 total
8312: from hr_lookups hl
8313: , hr_all_organization_units haou
8314: where not exists
8315: (
8316: select 'X'
8317: from per_za_employment_equity pzee
8410: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8411: from hr_lookups hl,
8412: hr_lookups hl1,
8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,
8416: per_all_assignments_f paaf,
8417: per_periods_of_service ppos,
8418: per_all_people_f papf
8505: 0 FI,
8506: 0 FW,
8507: 0 total
8508: from hr_lookups hl
8509: , hr_all_organization_units haou
8510: where not exists
8511: (
8512: select 'X'
8513: from per_za_employment_equity pzee
8562: 0 FI,
8563: 0 FW,
8564: 0 total
8565: from hr_lookups hl
8566: , hr_all_organization_units haou
8567: where not exists
8568: (
8569: select 'X'
8570: from per_za_employment_equity pzee
8640: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8641: from hr_lookups hl,
8642: hr_lookups hl1,
8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,
8646: per_all_assignments_f paaf,
8647: per_periods_of_service ppos,
8648: per_all_people_f papf
8738: 0 FI,
8739: 0 FW,
8740: 0 total
8741: from hr_lookups hl
8742: , hr_all_organization_units haou
8743: where not exists
8744: (
8745: select 'X'
8746: from per_za_employment_equity pzee
8795: 0 FI,
8796: 0 FW,
8797: 0 total
8798: from hr_lookups hl
8799: , hr_all_organization_units haou
8800: where not exists
8801: (
8802: select 'X'
8803: from per_za_employment_equity pzee
8895: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8896: from hr_lookups hl,
8897: hr_lookups hl1,
8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,
8901: per_all_assignments_f paaf,
8902: per_periods_of_service ppos,
8903: per_all_people_f papf
8991: 0 FI,
8992: 0 FW,
8993: 0 total
8994: from hr_lookups hl
8995: , hr_all_organization_units haou
8996: where not exists
8997: (
8998: select 'X'
8999: from per_za_employment_equity pzee
9047: 0 FI,
9048: 0 FW,
9049: 0 total
9050: from hr_lookups hl
9051: , hr_all_organization_units haou
9052: where not exists
9053: (
9054: select 'X'
9055: from per_za_employment_equity pzee
9164: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
9165: from hr_lookups hl,
9166: hr_lookups hl1,
9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,
9170: per_all_assignments_f paaf,
9171: per_periods_of_service ppos,
9172: per_all_people_f papf
9311: 0 FC,
9312: 0 FI,
9313: 0 FW,
9314: 0 total
9315: from hr_all_organization_units haou
9316: where not exists
9317: (
9318: select 'X'
9319: from per_za_employment_equity pzee
9382: 0 FC,
9383: 0 FI,
9384: 0 FW,
9385: 0 total
9386: from hr_all_organization_units haou
9387: where not exists
9388: (
9389: select 'X'
9390: from per_za_employment_equity pzee