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.

[Home] [Help]

APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

Line 53: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

49: SELECT
50: '01' TENINFO,
51: HLA.LOOKUP_CODE ARANK,
52: -- Added for bug#11736960
53: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
54: ,P_REPORT_DATE
55: ,'Y')
56: ,0
57: ,DECODE(PEO.SEX

Line 62: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

58: ,'M'
59: ,1
60: ,NULL)
61: ,NULL)) NRMEN,
62: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
63: ,P_REPORT_DATE
64: ,'Y')
65: ,0
66: ,DECODE(PEO.SEX

Line 71: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

67: ,'F'
68: ,1
69: ,NULL)
70: ,NULL)) NRWMEN,
71: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
72: ,P_REPORT_DATE
73: ,'Y')
74: ,2
75: ,DECODE(PEO.SEX

Line 80: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

76: ,'M'
77: ,1
78: ,NULL)
79: ,NULL)) BNHMEN,
80: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
81: ,P_REPORT_DATE
82: ,'Y')
83: ,2
84: ,DECODE(PEO.SEX

Line 89: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

85: ,'F'
86: ,1
87: ,NULL)
88: ,NULL)) BNHWMEN,
89: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
90: ,P_REPORT_DATE
91: ,'Y')
92: ,6
93: ,DECODE(PEO.SEX

Line 98: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

94: ,'M'
95: ,1
96: ,NULL)
97: ,NULL)) AM_ALMEN,
98: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
99: ,P_REPORT_DATE
100: ,'Y')
101: ,6
102: ,DECODE(PEO.SEX

Line 107: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

103: ,'F'
104: ,1
105: ,NULL)
106: ,NULL)) AM_ALWMEN,
107: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
108: ,P_REPORT_DATE
109: ,'Y')
110: ,4
111: ,DECODE(PEO.SEX

Line 116: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

112: ,'M'
113: ,1
114: ,NULL)
115: ,NULL)) AMEN,
116: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
117: ,P_REPORT_DATE
118: ,'Y')
119: ,4
120: ,DECODE(PEO.SEX

Line 125: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

121: ,'F'
122: ,1
123: ,NULL)
124: ,NULL)) AWMEN,
125: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
126: ,P_REPORT_DATE
127: ,'Y')
128: ,5
129: ,DECODE(PEO.SEX

Line 134: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

130: ,'M'
131: ,1
132: ,NULL)
133: ,NULL)) NH_OPMEN,
134: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
135: ,P_REPORT_DATE
136: ,'Y')
137: ,5
138: ,DECODE(PEO.SEX

Line 143: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

139: ,'F'
140: ,1
141: ,NULL)
142: ,NULL)) NH_OPWMEN,
143: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
144: ,P_REPORT_DATE
145: ,'Y')
146: ,3
147: ,DECODE(PEO.SEX

Line 152: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

148: ,'M'
149: ,1
150: ,NULL)
151: ,NULL)) HMEN,
152: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
153: ,P_REPORT_DATE
154: ,'Y')
155: ,3
156: ,DECODE(PEO.SEX

Line 161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

157: ,'F'
158: ,1
159: ,NULL)
160: ,NULL)) HWMEN,
161: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
162: ,P_REPORT_DATE
163: ,'Y')
164: ,1
165: ,DECODE(PEO.SEX

Line 170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

166: ,'M'
167: ,1
168: ,NULL)
169: ,NULL)) WNHMEN,
170: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
171: ,P_REPORT_DATE
172: ,'Y')
173: ,1
174: ,DECODE(PEO.SEX

Line 179: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

175: ,'F'
176: ,1
177: ,NULL)
178: ,NULL)) WNHWMEN,
179: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
180: ,P_REPORT_DATE
181: ,'Y')
182: ,99
183: ,DECODE(PEO.SEX

Line 188: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

184: ,'M'
185: ,1
186: ,NULL)
187: ,NULL)) URMEN,
188: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
189: ,P_REPORT_DATE
190: ,'Y')
191: ,99
192: ,DECODE(PEO.SEX

Line 197: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

193: ,'F'
194: ,1
195: ,NULL)
196: ,NULL)) URWMEN,
197: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
198: ,P_REPORT_DATE
199: ,'Y')
200: ,13
201: ,DECODE(PEO.SEX

Line 206: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

202: ,'M'
203: ,1
204: ,NULL)
205: ,NULL)) TMRMEN,
206: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
207: ,P_REPORT_DATE
208: ,'Y')
209: ,13
210: ,DECODE(PEO.SEX

Line 663: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

659: SELECT
660: '01' TENINFO,
661: '01' ARANK,
662: -- Added for bug#11736960
663: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
664: ,P_REPORT_DATE
665: ,'Y')
666: ,0
667: ,DECODE(PEO.SEX

Line 672: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

668: ,'M'
669: ,1
670: ,NULL)
671: ,NULL)) NRMEN,
672: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
673: ,P_REPORT_DATE
674: ,'Y')
675: ,0
676: ,DECODE(PEO.SEX

Line 681: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

677: ,'F'
678: ,1
679: ,NULL)
680: ,NULL)) NRWMEN,
681: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
682: ,P_REPORT_DATE
683: ,'Y')
684: ,2
685: ,DECODE(PEO.SEX

Line 690: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

686: ,'M'
687: ,1
688: ,NULL)
689: ,NULL)) BNHMEN,
690: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
691: ,P_REPORT_DATE
692: ,'Y')
693: ,2
694: ,DECODE(PEO.SEX

Line 699: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

695: ,'F'
696: ,1
697: ,NULL)
698: ,NULL)) BNHWMEN,
699: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
700: ,P_REPORT_DATE
701: ,'Y')
702: ,6
703: ,DECODE(PEO.SEX

Line 708: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

704: ,'M'
705: ,1
706: ,NULL)
707: ,NULL)) AM_ALMEN,
708: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
709: ,P_REPORT_DATE
710: ,'Y')
711: ,6
712: ,DECODE(PEO.SEX

Line 717: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

713: ,'F'
714: ,1
715: ,NULL)
716: ,NULL)) AM_ALWMEN,
717: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
718: ,P_REPORT_DATE
719: ,'Y')
720: ,4
721: ,DECODE(PEO.SEX

Line 726: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

722: ,'M'
723: ,1
724: ,NULL)
725: ,NULL)) AMEN,
726: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
727: ,P_REPORT_DATE
728: ,'Y')
729: ,4
730: ,DECODE(PEO.SEX

Line 735: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

731: ,'F'
732: ,1
733: ,NULL)
734: ,NULL)) AWMEN,
735: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
736: ,P_REPORT_DATE
737: ,'Y')
738: ,5
739: ,DECODE(PEO.SEX

Line 744: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

740: ,'M'
741: ,1
742: ,NULL)
743: ,NULL)) NH_OPMEN,
744: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
745: ,P_REPORT_DATE
746: ,'Y')
747: ,5
748: ,DECODE(PEO.SEX

Line 753: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

749: ,'F'
750: ,1
751: ,NULL)
752: ,NULL)) NH_OPWMEN,
753: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
754: ,P_REPORT_DATE
755: ,'Y')
756: ,3
757: ,DECODE(PEO.SEX

Line 762: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

758: ,'M'
759: ,1
760: ,NULL)
761: ,NULL)) HMEN,
762: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
763: ,P_REPORT_DATE
764: ,'Y')
765: ,3
766: ,DECODE(PEO.SEX

Line 771: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

767: ,'F'
768: ,1
769: ,NULL)
770: ,NULL)) HWMEN,
771: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
772: ,P_REPORT_DATE
773: ,'Y')
774: ,1
775: ,DECODE(PEO.SEX

Line 780: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

776: ,'M'
777: ,1
778: ,NULL)
779: ,NULL)) WNHMEN,
780: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
781: ,P_REPORT_DATE
782: ,'Y')
783: ,1
784: ,DECODE(PEO.SEX

Line 789: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

785: ,'F'
786: ,1
787: ,NULL)
788: ,NULL)) WNHWMEN,
789: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
790: ,P_REPORT_DATE
791: ,'Y')
792: ,99
793: ,DECODE(PEO.SEX

Line 798: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

794: ,'M'
795: ,1
796: ,NULL)
797: ,NULL)) URMEN,
798: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
799: ,P_REPORT_DATE
800: ,'Y')
801: ,99
802: ,DECODE(PEO.SEX

Line 807: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

803: ,'F'
804: ,1
805: ,NULL)
806: ,NULL)) URWMEN,
807: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
808: ,P_REPORT_DATE
809: ,'Y')
810: ,13
811: ,DECODE(PEO.SEX

Line 816: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

812: ,'M'
813: ,1
814: ,NULL)
815: ,NULL)) TMRMEN,
816: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
817: ,P_REPORT_DATE
818: ,'Y')
819: ,13
820: ,DECODE(PEO.SEX

Line 1273: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1269: SELECT
1270: '02' TENINFO,
1271: HLA.LOOKUP_CODE ARANK,
1272: -- Added for bug#11736960
1273: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1274: ,P_REPORT_DATE
1275: ,'Y')
1276: ,0
1277: ,DECODE(PEO.SEX

Line 1282: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1278: ,'M'
1279: ,1
1280: ,NULL)
1281: ,NULL)) NRMEN,
1282: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1283: ,P_REPORT_DATE
1284: ,'Y')
1285: ,0
1286: ,DECODE(PEO.SEX

Line 1291: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1287: ,'F'
1288: ,1
1289: ,NULL)
1290: ,NULL)) NRWMEN,
1291: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1292: ,P_REPORT_DATE
1293: ,'Y')
1294: ,2
1295: ,DECODE(PEO.SEX

Line 1300: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1296: ,'M'
1297: ,1
1298: ,NULL)
1299: ,NULL)) BNHMEN,
1300: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1301: ,P_REPORT_DATE
1302: ,'Y')
1303: ,2
1304: ,DECODE(PEO.SEX

Line 1309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1305: ,'F'
1306: ,1
1307: ,NULL)
1308: ,NULL)) BNHWMEN,
1309: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1310: ,P_REPORT_DATE
1311: ,'Y')
1312: ,6
1313: ,DECODE(PEO.SEX

Line 1318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1314: ,'M'
1315: ,1
1316: ,NULL)
1317: ,NULL)) AM_ALMEN,
1318: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1319: ,P_REPORT_DATE
1320: ,'Y')
1321: ,6
1322: ,DECODE(PEO.SEX

Line 1327: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1323: ,'F'
1324: ,1
1325: ,NULL)
1326: ,NULL)) AM_ALWMEN,
1327: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1328: ,P_REPORT_DATE
1329: ,'Y')
1330: ,4
1331: ,DECODE(PEO.SEX

Line 1336: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1332: ,'M'
1333: ,1
1334: ,NULL)
1335: ,NULL)) AMEN,
1336: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1337: ,P_REPORT_DATE
1338: ,'Y')
1339: ,4
1340: ,DECODE(PEO.SEX

Line 1345: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1341: ,'F'
1342: ,1
1343: ,NULL)
1344: ,NULL)) AWMEN,
1345: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1346: ,P_REPORT_DATE
1347: ,'Y')
1348: ,5
1349: ,DECODE(PEO.SEX

Line 1354: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1350: ,'M'
1351: ,1
1352: ,NULL)
1353: ,NULL)) NH_OPMEN,
1354: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1355: ,P_REPORT_DATE
1356: ,'Y')
1357: ,5
1358: ,DECODE(PEO.SEX

Line 1363: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1359: ,'F'
1360: ,1
1361: ,NULL)
1362: ,NULL)) NH_OPWMEN,
1363: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1364: ,P_REPORT_DATE
1365: ,'Y')
1366: ,3
1367: ,DECODE(PEO.SEX

Line 1372: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1368: ,'M'
1369: ,1
1370: ,NULL)
1371: ,NULL)) HMEN,
1372: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1373: ,P_REPORT_DATE
1374: ,'Y')
1375: ,3
1376: ,DECODE(PEO.SEX

Line 1381: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1377: ,'F'
1378: ,1
1379: ,NULL)
1380: ,NULL)) HWMEN,
1381: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1382: ,P_REPORT_DATE
1383: ,'Y')
1384: ,1
1385: ,DECODE(PEO.SEX

Line 1390: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1386: ,'M'
1387: ,1
1388: ,NULL)
1389: ,NULL)) WNHMEN,
1390: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1391: ,P_REPORT_DATE
1392: ,'Y')
1393: ,1
1394: ,DECODE(PEO.SEX

Line 1399: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1395: ,'F'
1396: ,1
1397: ,NULL)
1398: ,NULL)) WNHWMEN,
1399: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1400: ,P_REPORT_DATE
1401: ,'Y')
1402: ,99
1403: ,DECODE(PEO.SEX

Line 1408: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1404: ,'M'
1405: ,1
1406: ,NULL)
1407: ,NULL)) URMEN,
1408: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1409: ,P_REPORT_DATE
1410: ,'Y')
1411: ,99
1412: ,DECODE(PEO.SEX

Line 1417: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1413: ,'F'
1414: ,1
1415: ,NULL)
1416: ,NULL)) URWMEN,
1417: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1418: ,P_REPORT_DATE
1419: ,'Y')
1420: ,13
1421: ,DECODE(PEO.SEX

Line 1426: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1422: ,'M'
1423: ,1
1424: ,NULL)
1425: ,NULL)) TMRMEN,
1426: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1427: ,P_REPORT_DATE
1428: ,'Y')
1429: ,13
1430: ,DECODE(PEO.SEX

Line 1883: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1879: SELECT
1880: '02' TENINFO,
1881: '01' ARANK,
1882: -- Added for bug#11736960
1883: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1884: ,P_REPORT_DATE
1885: ,'Y')
1886: ,0
1887: ,DECODE(PEO.SEX

Line 1892: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1888: ,'M'
1889: ,1
1890: ,NULL)
1891: ,NULL)) NRMEN,
1892: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1893: ,P_REPORT_DATE
1894: ,'Y')
1895: ,0
1896: ,DECODE(PEO.SEX

Line 1901: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1897: ,'F'
1898: ,1
1899: ,NULL)
1900: ,NULL)) NRWMEN,
1901: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1902: ,P_REPORT_DATE
1903: ,'Y')
1904: ,2
1905: ,DECODE(PEO.SEX

Line 1910: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1906: ,'M'
1907: ,1
1908: ,NULL)
1909: ,NULL)) BNHMEN,
1910: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1911: ,P_REPORT_DATE
1912: ,'Y')
1913: ,2
1914: ,DECODE(PEO.SEX

Line 1919: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1915: ,'F'
1916: ,1
1917: ,NULL)
1918: ,NULL)) BNHWMEN,
1919: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1920: ,P_REPORT_DATE
1921: ,'Y')
1922: ,6
1923: ,DECODE(PEO.SEX

Line 1928: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1924: ,'M'
1925: ,1
1926: ,NULL)
1927: ,NULL)) AM_ALMEN,
1928: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1929: ,P_REPORT_DATE
1930: ,'Y')
1931: ,6
1932: ,DECODE(PEO.SEX

Line 1937: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1933: ,'F'
1934: ,1
1935: ,NULL)
1936: ,NULL)) AM_ALWMEN,
1937: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1938: ,P_REPORT_DATE
1939: ,'Y')
1940: ,4
1941: ,DECODE(PEO.SEX

Line 1946: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1942: ,'M'
1943: ,1
1944: ,NULL)
1945: ,NULL)) AMEN,
1946: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1947: ,P_REPORT_DATE
1948: ,'Y')
1949: ,4
1950: ,DECODE(PEO.SEX

Line 1955: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1951: ,'F'
1952: ,1
1953: ,NULL)
1954: ,NULL)) AWMEN,
1955: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1956: ,P_REPORT_DATE
1957: ,'Y')
1958: ,5
1959: ,DECODE(PEO.SEX

Line 1964: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1960: ,'M'
1961: ,1
1962: ,NULL)
1963: ,NULL)) NH_OPMEN,
1964: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1965: ,P_REPORT_DATE
1966: ,'Y')
1967: ,5
1968: ,DECODE(PEO.SEX

Line 1973: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1969: ,'F'
1970: ,1
1971: ,NULL)
1972: ,NULL)) NH_OPWMEN,
1973: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1974: ,P_REPORT_DATE
1975: ,'Y')
1976: ,3
1977: ,DECODE(PEO.SEX

Line 1982: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1978: ,'M'
1979: ,1
1980: ,NULL)
1981: ,NULL)) HMEN,
1982: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1983: ,P_REPORT_DATE
1984: ,'Y')
1985: ,3
1986: ,DECODE(PEO.SEX

Line 1991: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1987: ,'F'
1988: ,1
1989: ,NULL)
1990: ,NULL)) HWMEN,
1991: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1992: ,P_REPORT_DATE
1993: ,'Y')
1994: ,1
1995: ,DECODE(PEO.SEX

Line 2000: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

1996: ,'M'
1997: ,1
1998: ,NULL)
1999: ,NULL)) WNHMEN,
2000: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2001: ,P_REPORT_DATE
2002: ,'Y')
2003: ,1
2004: ,DECODE(PEO.SEX

Line 2009: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2005: ,'F'
2006: ,1
2007: ,NULL)
2008: ,NULL)) WNHWMEN,
2009: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2010: ,P_REPORT_DATE
2011: ,'Y')
2012: ,99
2013: ,DECODE(PEO.SEX

Line 2018: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2014: ,'M'
2015: ,1
2016: ,NULL)
2017: ,NULL)) URMEN,
2018: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2019: ,P_REPORT_DATE
2020: ,'Y')
2021: ,99
2022: ,DECODE(PEO.SEX

Line 2027: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2023: ,'F'
2024: ,1
2025: ,NULL)
2026: ,NULL)) URWMEN,
2027: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2028: ,P_REPORT_DATE
2029: ,'Y')
2030: ,13
2031: ,DECODE(PEO.SEX

Line 2036: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2032: ,'M'
2033: ,1
2034: ,NULL)
2035: ,NULL)) TMRMEN,
2036: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2037: ,P_REPORT_DATE
2038: ,'Y')
2039: ,13
2040: ,DECODE(PEO.SEX

Line 2493: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2489: SELECT
2490: '03' TENINFO,
2491: HLA.LOOKUP_CODE ARANK,
2492: -- Added for bug#11736960
2493: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2494: ,P_REPORT_DATE
2495: ,'Y')
2496: ,0
2497: ,DECODE(PEO.SEX

Line 2502: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2498: ,'M'
2499: ,1
2500: ,NULL)
2501: ,NULL)) NRMEN,
2502: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2503: ,P_REPORT_DATE
2504: ,'Y')
2505: ,0
2506: ,DECODE(PEO.SEX

Line 2511: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2507: ,'F'
2508: ,1
2509: ,NULL)
2510: ,NULL)) NRWMEN,
2511: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2512: ,P_REPORT_DATE
2513: ,'Y')
2514: ,2
2515: ,DECODE(PEO.SEX

Line 2520: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2516: ,'M'
2517: ,1
2518: ,NULL)
2519: ,NULL)) BNHMEN,
2520: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2521: ,P_REPORT_DATE
2522: ,'Y')
2523: ,2
2524: ,DECODE(PEO.SEX

Line 2529: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2525: ,'F'
2526: ,1
2527: ,NULL)
2528: ,NULL)) BNHWMEN,
2529: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2530: ,P_REPORT_DATE
2531: ,'Y')
2532: ,6
2533: ,DECODE(PEO.SEX

Line 2538: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2534: ,'M'
2535: ,1
2536: ,NULL)
2537: ,NULL)) AM_ALMEN,
2538: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2539: ,P_REPORT_DATE
2540: ,'Y')
2541: ,6
2542: ,DECODE(PEO.SEX

Line 2547: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2543: ,'F'
2544: ,1
2545: ,NULL)
2546: ,NULL)) AM_ALWMEN,
2547: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2548: ,P_REPORT_DATE
2549: ,'Y')
2550: ,4
2551: ,DECODE(PEO.SEX

Line 2556: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2552: ,'M'
2553: ,1
2554: ,NULL)
2555: ,NULL)) AMEN,
2556: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2557: ,P_REPORT_DATE
2558: ,'Y')
2559: ,4
2560: ,DECODE(PEO.SEX

Line 2565: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2561: ,'F'
2562: ,1
2563: ,NULL)
2564: ,NULL)) AWMEN,
2565: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2566: ,P_REPORT_DATE
2567: ,'Y')
2568: ,5
2569: ,DECODE(PEO.SEX

Line 2574: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2570: ,'M'
2571: ,1
2572: ,NULL)
2573: ,NULL)) NH_OPMEN,
2574: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2575: ,P_REPORT_DATE
2576: ,'Y')
2577: ,5
2578: ,DECODE(PEO.SEX

Line 2583: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2579: ,'F'
2580: ,1
2581: ,NULL)
2582: ,NULL)) NH_OPWMEN,
2583: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2584: ,P_REPORT_DATE
2585: ,'Y')
2586: ,3
2587: ,DECODE(PEO.SEX

Line 2592: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2588: ,'M'
2589: ,1
2590: ,NULL)
2591: ,NULL)) HMEN,
2592: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2593: ,P_REPORT_DATE
2594: ,'Y')
2595: ,3
2596: ,DECODE(PEO.SEX

Line 2601: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2597: ,'F'
2598: ,1
2599: ,NULL)
2600: ,NULL)) HWMEN,
2601: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2602: ,P_REPORT_DATE
2603: ,'Y')
2604: ,1
2605: ,DECODE(PEO.SEX

Line 2610: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2606: ,'M'
2607: ,1
2608: ,NULL)
2609: ,NULL)) WNHMEN,
2610: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2611: ,P_REPORT_DATE
2612: ,'Y')
2613: ,1
2614: ,DECODE(PEO.SEX

Line 2619: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2615: ,'F'
2616: ,1
2617: ,NULL)
2618: ,NULL)) WNHWMEN,
2619: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2620: ,P_REPORT_DATE
2621: ,'Y')
2622: ,99
2623: ,DECODE(PEO.SEX

Line 2628: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2624: ,'M'
2625: ,1
2626: ,NULL)
2627: ,NULL)) URMEN,
2628: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2629: ,P_REPORT_DATE
2630: ,'Y')
2631: ,99
2632: ,DECODE(PEO.SEX

Line 2637: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2633: ,'F'
2634: ,1
2635: ,NULL)
2636: ,NULL)) URWMEN,
2637: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2638: ,P_REPORT_DATE
2639: ,'Y')
2640: ,13
2641: ,DECODE(PEO.SEX

Line 2646: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

2642: ,'M'
2643: ,1
2644: ,NULL)
2645: ,NULL)) TMRMEN,
2646: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
2647: ,P_REPORT_DATE
2648: ,'Y')
2649: ,13
2650: ,DECODE(PEO.SEX

Line 3110: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3106: SELECT
3107: '03' TENINFO,
3108: '01' ARANK,
3109: -- Added for bug#11736960
3110: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3111: ,P_REPORT_DATE
3112: ,'Y')
3113: ,0
3114: ,DECODE(PEO.SEX

Line 3119: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3115: ,'M'
3116: ,1
3117: ,NULL)
3118: ,NULL)) NRMEN,
3119: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3120: ,P_REPORT_DATE
3121: ,'Y')
3122: ,0
3123: ,DECODE(PEO.SEX

Line 3128: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3124: ,'F'
3125: ,1
3126: ,NULL)
3127: ,NULL)) NRWMEN,
3128: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3129: ,P_REPORT_DATE
3130: ,'Y')
3131: ,2
3132: ,DECODE(PEO.SEX

Line 3137: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3133: ,'M'
3134: ,1
3135: ,NULL)
3136: ,NULL)) BNHMEN,
3137: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3138: ,P_REPORT_DATE
3139: ,'Y')
3140: ,2
3141: ,DECODE(PEO.SEX

Line 3146: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3142: ,'F'
3143: ,1
3144: ,NULL)
3145: ,NULL)) BNHWMEN,
3146: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3147: ,P_REPORT_DATE
3148: ,'Y')
3149: ,6
3150: ,DECODE(PEO.SEX

Line 3155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3151: ,'M'
3152: ,1
3153: ,NULL)
3154: ,NULL)) AM_ALMEN,
3155: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3156: ,P_REPORT_DATE
3157: ,'Y')
3158: ,6
3159: ,DECODE(PEO.SEX

Line 3164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3160: ,'F'
3161: ,1
3162: ,NULL)
3163: ,NULL)) AM_ALWMEN,
3164: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3165: ,P_REPORT_DATE
3166: ,'Y')
3167: ,4
3168: ,DECODE(PEO.SEX

Line 3173: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3169: ,'M'
3170: ,1
3171: ,NULL)
3172: ,NULL)) AMEN,
3173: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3174: ,P_REPORT_DATE
3175: ,'Y')
3176: ,4
3177: ,DECODE(PEO.SEX

Line 3182: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3178: ,'F'
3179: ,1
3180: ,NULL)
3181: ,NULL)) AWMEN,
3182: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3183: ,P_REPORT_DATE
3184: ,'Y')
3185: ,5
3186: ,DECODE(PEO.SEX

Line 3191: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3187: ,'M'
3188: ,1
3189: ,NULL)
3190: ,NULL)) NH_OPMEN,
3191: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3192: ,P_REPORT_DATE
3193: ,'Y')
3194: ,5
3195: ,DECODE(PEO.SEX

Line 3200: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3196: ,'F'
3197: ,1
3198: ,NULL)
3199: ,NULL)) NH_OPWMEN,
3200: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3201: ,P_REPORT_DATE
3202: ,'Y')
3203: ,3
3204: ,DECODE(PEO.SEX

Line 3209: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3205: ,'M'
3206: ,1
3207: ,NULL)
3208: ,NULL)) HMEN,
3209: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3210: ,P_REPORT_DATE
3211: ,'Y')
3212: ,3
3213: ,DECODE(PEO.SEX

Line 3218: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3214: ,'F'
3215: ,1
3216: ,NULL)
3217: ,NULL)) HWMEN,
3218: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3219: ,P_REPORT_DATE
3220: ,'Y')
3221: ,1
3222: ,DECODE(PEO.SEX

Line 3227: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3223: ,'M'
3224: ,1
3225: ,NULL)
3226: ,NULL)) WNHMEN,
3227: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3228: ,P_REPORT_DATE
3229: ,'Y')
3230: ,1
3231: ,DECODE(PEO.SEX

Line 3236: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3232: ,'F'
3233: ,1
3234: ,NULL)
3235: ,NULL)) WNHWMEN,
3236: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3237: ,P_REPORT_DATE
3238: ,'Y')
3239: ,99
3240: ,DECODE(PEO.SEX

Line 3245: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3241: ,'M'
3242: ,1
3243: ,NULL)
3244: ,NULL)) URMEN,
3245: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3246: ,P_REPORT_DATE
3247: ,'Y')
3248: ,99
3249: ,DECODE(PEO.SEX

Line 3254: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3250: ,'F'
3251: ,1
3252: ,NULL)
3253: ,NULL)) URWMEN,
3254: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3255: ,P_REPORT_DATE
3256: ,'Y')
3257: ,13
3258: ,DECODE(PEO.SEX

Line 3263: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID

3259: ,'M'
3260: ,1
3261: ,NULL)
3262: ,NULL)) TMRMEN,
3263: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
3264: ,P_REPORT_DATE
3265: ,'Y')
3266: ,13
3267: ,DECODE(PEO.SEX