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

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

221: ,CP_PT)
222: ,NVL(PPP.PROPOSED_SALARY_N
223: ,0) * PPB.PAY_ANNUALIZATION_FACTOR) SALARY_RANGE,
224: -- Added for bug#11736960
225: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
226: ,P_REPORT_DATE
227: ,'Y')
228: ,0
229: ,DECODE(PEO.SEX

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

230: ,'M'
231: ,1
232: ,NULL)
233: ,NULL)) NRMEN,
234: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
235: ,P_REPORT_DATE
236: ,'Y')
237: ,0
238: ,DECODE(PEO.SEX

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

239: ,'F'
240: ,1
241: ,NULL)
242: ,NULL)) NRWMEN,
243: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
244: ,P_REPORT_DATE
245: ,'Y')
246: ,2
247: ,DECODE(PEO.SEX

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

248: ,'M'
249: ,1
250: ,NULL)
251: ,NULL)) BNHMEN,
252: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
253: ,P_REPORT_DATE
254: ,'Y')
255: ,2
256: ,DECODE(PEO.SEX

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

257: ,'F'
258: ,1
259: ,NULL)
260: ,NULL)) BNHWMEN,
261: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
262: ,P_REPORT_DATE
263: ,'Y')
264: ,6
265: ,DECODE(PEO.SEX

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

266: ,'M'
267: ,1
268: ,NULL)
269: ,NULL)) AM_ALMEN,
270: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
271: ,P_REPORT_DATE
272: ,'Y')
273: ,6
274: ,DECODE(PEO.SEX

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

275: ,'F'
276: ,1
277: ,NULL)
278: ,NULL)) AM_ALWMEN,
279: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
280: ,P_REPORT_DATE
281: ,'Y')
282: ,4
283: ,DECODE(PEO.SEX

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

284: ,'M'
285: ,1
286: ,NULL)
287: ,NULL)) A_PMEN,
288: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
289: ,P_REPORT_DATE
290: ,'Y')
291: ,4
292: ,DECODE(PEO.SEX

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

293: ,'F'
294: ,1
295: ,NULL)
296: ,NULL)) A_PWMEN,
297: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
298: ,P_REPORT_DATE
299: ,'Y')
300: ,3
301: ,DECODE(PEO.SEX

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

302: ,'M'
303: ,1
304: ,NULL)
305: ,NULL)) HMEN,
306: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
307: ,P_REPORT_DATE
308: ,'Y')
309: ,3
310: ,DECODE(PEO.SEX

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

311: ,'F'
312: ,1
313: ,NULL)
314: ,NULL)) HWMEN,
315: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
316: ,P_REPORT_DATE
317: ,'Y')
318: ,1
319: ,DECODE(PEO.SEX

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

320: ,'M'
321: ,1
322: ,NULL)
323: ,NULL)) WNHMEN,
324: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
325: ,P_REPORT_DATE
326: ,'Y')
327: ,1
328: ,DECODE(PEO.SEX

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

329: ,'F'
330: ,1
331: ,NULL)
332: ,NULL)) WNHWMEN,
333: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
334: ,P_REPORT_DATE
335: ,'Y')
336: ,99
337: ,DECODE(PEO.SEX

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

338: ,'M'
339: ,1
340: ,NULL)
341: ,NULL)) URMEN,
342: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
343: ,P_REPORT_DATE
344: ,'Y')
345: ,99
346: ,DECODE(PEO.SEX

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

347: ,'F'
348: ,1
349: ,NULL)
350: ,NULL)) URWMEN,
351: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
352: ,P_REPORT_DATE
353: ,'Y')
354: ,5
355: ,DECODE(PEO.SEX

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

356: ,'M'
357: ,1
358: ,NULL)
359: ,NULL)) NH_OPMEN,
360: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
361: ,P_REPORT_DATE
362: ,'Y')
363: ,5
364: ,DECODE(PEO.SEX

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

365: ,'F'
366: ,1
367: ,NULL)
368: ,NULL)) NH_OPWMEN,
369: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
370: ,P_REPORT_DATE
371: ,'Y')
372: ,13
373: ,DECODE(PEO.SEX

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

374: ,'M'
375: ,1
376: ,NULL)
377: ,NULL)) TMRMEN,
378: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
379: ,P_REPORT_DATE
380: ,'Y')
381: ,13
382: ,DECODE(PEO.SEX

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

853: SELECT
854: 1 LINE,
855: 'Less than 9 months' DISP_NAME,
856: -- Added for bug#11736960
857: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
858: ,P_REPORT_DATE
859: ,'Y')
860: ,0
861: ,DECODE(PEO.SEX

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

862: ,'M'
863: ,1
864: ,NULL)
865: ,NULL)) NRMEN,
866: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
867: ,P_REPORT_DATE
868: ,'Y')
869: ,0
870: ,DECODE(PEO.SEX

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

871: ,'F'
872: ,1
873: ,NULL)
874: ,NULL)) NRWMEN,
875: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
876: ,P_REPORT_DATE
877: ,'Y')
878: ,2
879: ,DECODE(PEO.SEX

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

880: ,'M'
881: ,1
882: ,NULL)
883: ,NULL)) BNHMEN,
884: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
885: ,P_REPORT_DATE
886: ,'Y')
887: ,2
888: ,DECODE(PEO.SEX

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

889: ,'F'
890: ,1
891: ,NULL)
892: ,NULL)) BNHWMEN,
893: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
894: ,P_REPORT_DATE
895: ,'Y')
896: ,6
897: ,DECODE(PEO.SEX

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

898: ,'M'
899: ,1
900: ,NULL)
901: ,NULL)) AM_ALMEN,
902: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
903: ,P_REPORT_DATE
904: ,'Y')
905: ,6
906: ,DECODE(PEO.SEX

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

907: ,'F'
908: ,1
909: ,NULL)
910: ,NULL)) AM_ALWMEN,
911: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
912: ,P_REPORT_DATE
913: ,'Y')
914: ,4
915: ,DECODE(PEO.SEX

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

916: ,'M'
917: ,1
918: ,NULL)
919: ,NULL)) A_PMEN,
920: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
921: ,P_REPORT_DATE
922: ,'Y')
923: ,4
924: ,DECODE(PEO.SEX

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

925: ,'F'
926: ,1
927: ,NULL)
928: ,NULL)) A_PWMEN,
929: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
930: ,P_REPORT_DATE
931: ,'Y')
932: ,3
933: ,DECODE(PEO.SEX

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

934: ,'M'
935: ,1
936: ,NULL)
937: ,NULL)) HMEN,
938: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
939: ,P_REPORT_DATE
940: ,'Y')
941: ,3
942: ,DECODE(PEO.SEX

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

943: ,'F'
944: ,1
945: ,NULL)
946: ,NULL)) HWMEN,
947: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
948: ,P_REPORT_DATE
949: ,'Y')
950: ,1
951: ,DECODE(PEO.SEX

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

952: ,'M'
953: ,1
954: ,NULL)
955: ,NULL)) WNHMEN,
956: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
957: ,P_REPORT_DATE
958: ,'Y')
959: ,1
960: ,DECODE(PEO.SEX

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

961: ,'F'
962: ,1
963: ,NULL)
964: ,NULL)) WNHWMEN,
965: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
966: ,P_REPORT_DATE
967: ,'Y')
968: ,99
969: ,DECODE(PEO.SEX

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

970: ,'M'
971: ,1
972: ,NULL)
973: ,NULL)) URMEN,
974: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
975: ,P_REPORT_DATE
976: ,'Y')
977: ,99
978: ,DECODE(PEO.SEX

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

980: ,1
981: ,NULL)
982: ,NULL)) URWMEN,
983:
984: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
985: ,P_REPORT_DATE
986: ,'Y')
987: ,5
988: ,DECODE(PEO.SEX

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

989: ,'M'
990: ,1
991: ,NULL)
992: ,NULL)) NH_OPMEN,
993: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
994: ,P_REPORT_DATE
995: ,'Y')
996: ,5
997: ,DECODE(PEO.SEX

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

999: ,1
1000: ,NULL)
1001: ,NULL)) NH_OPWMEN,
1002:
1003: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1004: ,P_REPORT_DATE
1005: ,'Y')
1006: ,13
1007: ,DECODE(PEO.SEX

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

1008: ,'M'
1009: ,1
1010: ,NULL)
1011: ,NULL)) TMRMEN,
1012: COUNT(DECODE(PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PEO.PERSON_ID
1013: ,P_REPORT_DATE
1014: ,'Y')
1015: ,13
1016: ,DECODE(PEO.SEX