eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

Line 154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,

150: CURSOR GET_LINE1_COUNTS IS
151: SELECT '68' LINE,
152: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
153: -- Added for bug#11736960
154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,

Line 155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,

151: SELECT '68' LINE,
152: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
153: -- Added for bug#11736960
154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,

Line 156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,

152: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
153: -- Added for bug#11736960
154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,

Line 157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,

153: -- Added for bug#11736960
154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,

Line 158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,

154: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,

Line 159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,

155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,

Line 160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,

156: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,

Line 161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,

157: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,

Line 162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,

158: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,

Line 163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,

159: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,

Line 164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,

160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) A_PMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,

Line 165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,

161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) A_PWMEN,
162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,

Line 166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,

162: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,

Line 167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,

163: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN

Line 168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,

164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
172: --

Line 169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,

165: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
172: --
173: /* Commented for bug#11736960 starts

Line 170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,

166: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
172: --
173: /* Commented for bug#11736960 starts
174: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,

Line 171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN

167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
168: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
169: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
171: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
172: --
173: /* Commented for bug#11736960 starts
174: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
175: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,

Line 306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,

302: CURSOR GET_LINE2_COUNTS IS
303: SELECT '2' LINE,
304: HL.LOOKUP_CODE JOBCODE,
305: -- Added for bug#11736960
306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,

Line 307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,

303: SELECT '2' LINE,
304: HL.LOOKUP_CODE JOBCODE,
305: -- Added for bug#11736960
306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,

Line 308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,

304: HL.LOOKUP_CODE JOBCODE,
305: -- Added for bug#11736960
306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,

Line 309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,

305: -- Added for bug#11736960
306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,

Line 310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,

306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,

Line 311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,

307: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 0, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,
308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,

Line 312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,

308: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,
309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,

Line 313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,

309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 2, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) BNHWMEN,
310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,

Line 314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,

310: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) AM_ALMEN,
311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,

Line 315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,

311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 6, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) AM_ALWMEN,
312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,

Line 316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,

312: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) APMEN,
313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,

Line 317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,

313: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 4, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) APWMEN,
314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,

Line 318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,

314: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) HMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,

Line 319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,

315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 3, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) HWMEN,
316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN

Line 320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,

316: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
324: --

Line 321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,

317: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 1, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
324: --
325: /* Commented for bug#11736960 starts

Line 322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,

318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
324: --
325: /* Commented for bug#11736960 starts
326: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,

Line 323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN

319: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 99, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN,
320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NH_OPMEN,
321: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 5, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NH_OPWMEN,
322: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) TMRMEN,
323: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID, P_REPORT_DATE, 'Y'), 13, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) TMRWMEN
324: --
325: /* Commented for bug#11736960 starts
326: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) NRMEN,
327: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) NRWMEN,