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_PQIPED9_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

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

57: CURSOR GET_LINE1_COUNTS IS
58: SELECT
59: '1' JCODE,
60: -- Added for bug#11736960
61: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
62: ,P_REPORT_DATE
63: ,'Y')
64: ,0
65: ,DECODE(PEO.SEX

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

66: ,'M'
67: ,1
68: ,NULL)
69: ,NULL)) NRMEN,
70: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
71: ,P_REPORT_DATE
72: ,'Y')
73: ,0
74: ,DECODE(PEO.SEX

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

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

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

84: ,'M'
85: ,1
86: ,NULL)
87: ,NULL)) BNHMEN,
88: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
89: ,P_REPORT_DATE
90: ,'Y')
91: ,2
92: ,DECODE(PEO.SEX

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

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

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

102: ,'M'
103: ,1
104: ,NULL)
105: ,NULL)) AM_ALMEN,
106: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
107: ,P_REPORT_DATE
108: ,'Y')
109: ,6
110: ,DECODE(PEO.SEX

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

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

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

120: ,'M'
121: ,1
122: ,NULL)
123: ,NULL)) AMEN,
124: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
125: ,P_REPORT_DATE
126: ,'Y')
127: ,4
128: ,DECODE(PEO.SEX

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

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

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

138: ,'M'
139: ,1
140: ,NULL)
141: ,NULL)) NH_OPMEN,
142: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
143: ,P_REPORT_DATE
144: ,'Y')
145: ,5
146: ,DECODE(PEO.SEX

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

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

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

156: ,'M'
157: ,1
158: ,NULL)
159: ,NULL)) HMEN,
160: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
161: ,P_REPORT_DATE
162: ,'Y')
163: ,3
164: ,DECODE(PEO.SEX

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

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

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

174: ,'M'
175: ,1
176: ,NULL)
177: ,NULL)) WNHMEN,
178: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
179: ,P_REPORT_DATE
180: ,'Y')
181: ,1
182: ,DECODE(PEO.SEX

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

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

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

192: ,'M'
193: ,1
194: ,NULL)
195: ,NULL)) URMEN,
196: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
197: ,P_REPORT_DATE
198: ,'Y')
199: ,99
200: ,DECODE(PEO.SEX

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

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

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

210: ,'M'
211: ,1
212: ,NULL)
213: ,NULL)) TMRMEN,
214: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
215: ,P_REPORT_DATE
216: ,'Y')
217: ,13
218: ,DECODE(PEO.SEX

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

610: CURSOR GET_LINE2_COUNTS IS
611: SELECT
612: '2' JCODE,
613: -- Added for bug#11736960
614: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
615: ,P_REPORT_DATE
616: ,'Y')
617: ,0
618: ,DECODE(PEO.SEX

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

619: ,'M'
620: ,1
621: ,NULL)
622: ,NULL)) NRMEN,
623: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
624: ,P_REPORT_DATE
625: ,'Y')
626: ,0
627: ,DECODE(PEO.SEX

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

628: ,'F'
629: ,1
630: ,NULL)
631: ,NULL)) NRWMEN,
632: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
633: ,P_REPORT_DATE
634: ,'Y')
635: ,2
636: ,DECODE(PEO.SEX

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

637: ,'M'
638: ,1
639: ,NULL)
640: ,NULL)) BNHMEN,
641: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
642: ,P_REPORT_DATE
643: ,'Y')
644: ,2
645: ,DECODE(PEO.SEX

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

646: ,'F'
647: ,1
648: ,NULL)
649: ,NULL)) BNHWMEN,
650: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
651: ,P_REPORT_DATE
652: ,'Y')
653: ,6
654: ,DECODE(PEO.SEX

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

655: ,'M'
656: ,1
657: ,NULL)
658: ,NULL)) AM_ALMEN,
659: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
660: ,P_REPORT_DATE
661: ,'Y')
662: ,6
663: ,DECODE(PEO.SEX

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

664: ,'F'
665: ,1
666: ,NULL)
667: ,NULL)) AM_ALWMEN,
668: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
669: ,P_REPORT_DATE
670: ,'Y')
671: ,4
672: ,DECODE(PEO.SEX

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

673: ,'M'
674: ,1
675: ,NULL)
676: ,NULL)) AMEN,
677: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
678: ,P_REPORT_DATE
679: ,'Y')
680: ,4
681: ,DECODE(PEO.SEX

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

682: ,'F'
683: ,1
684: ,NULL)
685: ,NULL)) AWMEN,
686: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
687: ,P_REPORT_DATE
688: ,'Y')
689: ,5
690: ,DECODE(PEO.SEX

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

691: ,'M'
692: ,1
693: ,NULL)
694: ,NULL)) NH_OPMEN,
695: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
696: ,P_REPORT_DATE
697: ,'Y')
698: ,5
699: ,DECODE(PEO.SEX

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

700: ,'F'
701: ,1
702: ,NULL)
703: ,NULL)) NH_OPWMEN,
704: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
705: ,P_REPORT_DATE
706: ,'Y')
707: ,3
708: ,DECODE(PEO.SEX

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

709: ,'M'
710: ,1
711: ,NULL)
712: ,NULL)) HMEN,
713: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
714: ,P_REPORT_DATE
715: ,'Y')
716: ,3
717: ,DECODE(PEO.SEX

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

718: ,'F'
719: ,1
720: ,NULL)
721: ,NULL)) HWMEN,
722: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
723: ,P_REPORT_DATE
724: ,'Y')
725: ,1
726: ,DECODE(PEO.SEX

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

727: ,'M'
728: ,1
729: ,NULL)
730: ,NULL)) WNHMEN,
731: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
732: ,P_REPORT_DATE
733: ,'Y')
734: ,1
735: ,DECODE(PEO.SEX

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

736: ,'F'
737: ,1
738: ,NULL)
739: ,NULL)) WNHWMEN,
740: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
741: ,P_REPORT_DATE
742: ,'Y')
743: ,99
744: ,DECODE(PEO.SEX

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

745: ,'M'
746: ,1
747: ,NULL)
748: ,NULL)) URMEN,
749: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
750: ,P_REPORT_DATE
751: ,'Y')
752: ,99
753: ,DECODE(PEO.SEX

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

754: ,'F'
755: ,1
756: ,NULL)
757: ,NULL)) URWMEN,
758: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
759: ,P_REPORT_DATE
760: ,'Y')
761: ,13
762: ,DECODE(PEO.SEX

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

763: ,'M'
764: ,1
765: ,NULL)
766: ,NULL)) TMRMEN,
767: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
768: ,P_REPORT_DATE
769: ,'Y')
770: ,13
771: ,DECODE(PEO.SEX

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

1163: CURSOR GET_LINE3_COUNTS IS
1164: SELECT
1165: '3' JCODE,
1166: -- Added for bug#11736960
1167: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1168: ,P_REPORT_DATE
1169: ,'Y')
1170: ,0
1171: ,DECODE(PEO.SEX

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

1172: ,'M'
1173: ,1
1174: ,NULL)
1175: ,NULL)) NRMEN,
1176: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1177: ,P_REPORT_DATE
1178: ,'Y')
1179: ,0
1180: ,DECODE(PEO.SEX

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

1181: ,'F'
1182: ,1
1183: ,NULL)
1184: ,NULL)) NRWMEN,
1185: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1186: ,P_REPORT_DATE
1187: ,'Y')
1188: ,2
1189: ,DECODE(PEO.SEX

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

1190: ,'M'
1191: ,1
1192: ,NULL)
1193: ,NULL)) BNHMEN,
1194: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1195: ,P_REPORT_DATE
1196: ,'Y')
1197: ,2
1198: ,DECODE(PEO.SEX

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

1199: ,'F'
1200: ,1
1201: ,NULL)
1202: ,NULL)) BNHWMEN,
1203: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1204: ,P_REPORT_DATE
1205: ,'Y')
1206: ,6
1207: ,DECODE(PEO.SEX

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

1208: ,'M'
1209: ,1
1210: ,NULL)
1211: ,NULL)) AM_ALMEN,
1212: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1213: ,P_REPORT_DATE
1214: ,'Y')
1215: ,6
1216: ,DECODE(PEO.SEX

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

1217: ,'F'
1218: ,1
1219: ,NULL)
1220: ,NULL)) AM_ALWMEN,
1221: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1222: ,P_REPORT_DATE
1223: ,'Y')
1224: ,4
1225: ,DECODE(PEO.SEX

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

1226: ,'M'
1227: ,1
1228: ,NULL)
1229: ,NULL)) AMEN,
1230: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1231: ,P_REPORT_DATE
1232: ,'Y')
1233: ,4
1234: ,DECODE(PEO.SEX

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

1235: ,'F'
1236: ,1
1237: ,NULL)
1238: ,NULL)) AWMEN,
1239: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1240: ,P_REPORT_DATE
1241: ,'Y')
1242: ,5
1243: ,DECODE(PEO.SEX

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

1244: ,'M'
1245: ,1
1246: ,NULL)
1247: ,NULL)) NH_OPMEN,
1248: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1249: ,P_REPORT_DATE
1250: ,'Y')
1251: ,5
1252: ,DECODE(PEO.SEX

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

1253: ,'F'
1254: ,1
1255: ,NULL)
1256: ,NULL)) NH_OPWMEN,
1257: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1258: ,P_REPORT_DATE
1259: ,'Y')
1260: ,3
1261: ,DECODE(PEO.SEX

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

1262: ,'M'
1263: ,1
1264: ,NULL)
1265: ,NULL)) HMEN,
1266: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1267: ,P_REPORT_DATE
1268: ,'Y')
1269: ,3
1270: ,DECODE(PEO.SEX

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

1271: ,'F'
1272: ,1
1273: ,NULL)
1274: ,NULL)) HWMEN,
1275: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1276: ,P_REPORT_DATE
1277: ,'Y')
1278: ,1
1279: ,DECODE(PEO.SEX

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

1280: ,'M'
1281: ,1
1282: ,NULL)
1283: ,NULL)) WNHMEN,
1284: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1285: ,P_REPORT_DATE
1286: ,'Y')
1287: ,1
1288: ,DECODE(PEO.SEX

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

1289: ,'F'
1290: ,1
1291: ,NULL)
1292: ,NULL)) WNHWMEN,
1293: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1294: ,P_REPORT_DATE
1295: ,'Y')
1296: ,99
1297: ,DECODE(PEO.SEX

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

1298: ,'M'
1299: ,1
1300: ,NULL)
1301: ,NULL)) URMEN,
1302: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1303: ,P_REPORT_DATE
1304: ,'Y')
1305: ,99
1306: ,DECODE(PEO.SEX

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

1307: ,'F'
1308: ,1
1309: ,NULL)
1310: ,NULL)) URWMEN,
1311: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1312: ,P_REPORT_DATE
1313: ,'Y')
1314: ,13
1315: ,DECODE(PEO.SEX

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

1316: ,'M'
1317: ,1
1318: ,NULL)
1319: ,NULL)) TMRMEN,
1320: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1321: ,P_REPORT_DATE
1322: ,'Y')
1323: ,13
1324: ,DECODE(PEO.SEX

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

1722: CURSOR GET_LINE4_COUNTS IS
1723: SELECT
1724: HL.LOOKUP_CODE JCODE,
1725: -- Added for bug#11736960
1726: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1727: ,P_REPORT_DATE
1728: ,'Y')
1729: ,0
1730: ,DECODE(PEO.SEX

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

1731: ,'M'
1732: ,1
1733: ,NULL)
1734: ,NULL)) NRMEN,
1735: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1736: ,P_REPORT_DATE
1737: ,'Y')
1738: ,0
1739: ,DECODE(PEO.SEX

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

1740: ,'F'
1741: ,1
1742: ,NULL)
1743: ,NULL)) NRWMEN,
1744: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1745: ,P_REPORT_DATE
1746: ,'Y')
1747: ,2
1748: ,DECODE(PEO.SEX

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

1749: ,'M'
1750: ,1
1751: ,NULL)
1752: ,NULL)) BNHMEN,
1753: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1754: ,P_REPORT_DATE
1755: ,'Y')
1756: ,2
1757: ,DECODE(PEO.SEX

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

1758: ,'F'
1759: ,1
1760: ,NULL)
1761: ,NULL)) BNHWMEN,
1762: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1763: ,P_REPORT_DATE
1764: ,'Y')
1765: ,6
1766: ,DECODE(PEO.SEX

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

1767: ,'M'
1768: ,1
1769: ,NULL)
1770: ,NULL)) AM_ALMEN,
1771: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1772: ,P_REPORT_DATE
1773: ,'Y')
1774: ,6
1775: ,DECODE(PEO.SEX

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

1776: ,'F'
1777: ,1
1778: ,NULL)
1779: ,NULL)) AM_ALWMEN,
1780: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1781: ,P_REPORT_DATE
1782: ,'Y')
1783: ,4
1784: ,DECODE(PEO.SEX

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

1785: ,'M'
1786: ,1
1787: ,NULL)
1788: ,NULL)) AMEN,
1789: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1790: ,P_REPORT_DATE
1791: ,'Y')
1792: ,4
1793: ,DECODE(PEO.SEX

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

1794: ,'F'
1795: ,1
1796: ,NULL)
1797: ,NULL)) AWMEN,
1798: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1799: ,P_REPORT_DATE
1800: ,'Y')
1801: ,5
1802: ,DECODE(PEO.SEX

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

1803: ,'M'
1804: ,1
1805: ,NULL)
1806: ,NULL)) NH_OPMEN,
1807: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1808: ,P_REPORT_DATE
1809: ,'Y')
1810: ,5
1811: ,DECODE(PEO.SEX

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

1812: ,'F'
1813: ,1
1814: ,NULL)
1815: ,NULL)) NH_OPWMEN,
1816: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1817: ,P_REPORT_DATE
1818: ,'Y')
1819: ,3
1820: ,DECODE(PEO.SEX

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

1821: ,'M'
1822: ,1
1823: ,NULL)
1824: ,NULL)) HMEN,
1825: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1826: ,P_REPORT_DATE
1827: ,'Y')
1828: ,3
1829: ,DECODE(PEO.SEX

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

1830: ,'F'
1831: ,1
1832: ,NULL)
1833: ,NULL)) HWMEN,
1834: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1835: ,P_REPORT_DATE
1836: ,'Y')
1837: ,1
1838: ,DECODE(PEO.SEX

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

1839: ,'M'
1840: ,1
1841: ,NULL)
1842: ,NULL)) WNHMEN,
1843: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1844: ,P_REPORT_DATE
1845: ,'Y')
1846: ,1
1847: ,DECODE(PEO.SEX

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

1848: ,'F'
1849: ,1
1850: ,NULL)
1851: ,NULL)) WNHWMEN,
1852: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1853: ,P_REPORT_DATE
1854: ,'Y')
1855: ,99
1856: ,DECODE(PEO.SEX

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

1857: ,'M'
1858: ,1
1859: ,NULL)
1860: ,NULL)) URMEN,
1861: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1862: ,P_REPORT_DATE
1863: ,'Y')
1864: ,99
1865: ,DECODE(PEO.SEX

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

1866: ,'F'
1867: ,1
1868: ,NULL)
1869: ,NULL)) URWMEN,
1870: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1871: ,P_REPORT_DATE
1872: ,'Y')
1873: ,13
1874: ,DECODE(PEO.SEX

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

1875: ,'M'
1876: ,1
1877: ,NULL)
1878: ,NULL)) TMRMEN,
1879: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1880: ,P_REPORT_DATE
1881: ,'Y')
1882: ,13
1883: ,DECODE(PEO.SEX