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_PQIPED8_XMLP_PKG dependencies on PQH_NR_ALIEN_PKG

Line 44: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

40: CURSOR GET_LINE1_COUNTS IS
41: SELECT
42: '01' TENINFO,
43: HLA.LOOKUP_CODE ARANK,
44: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
45: ,P_REPORT_DATE)
46: ,'1'
47: ,DECODE(PEO.SEX
48: ,'M'

Line 52: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

48: ,'M'
49: ,1
50: ,NULL)
51: ,NULL)) NRMEN,
52: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
53: ,P_REPORT_DATE)
54: ,'1'
55: ,DECODE(PEO.SEX
56: ,'F'

Line 60: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

56: ,'F'
57: ,1
58: ,NULL)
59: ,NULL)) NRWMEN,
60: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
61: ,P_REPORT_DATE)
62: ,NULL
63: ,(DECODE(PEO.PER_INFORMATION1
64: ,'2'

Line 70: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

66: ,'M'
67: ,1
68: ,NULL)
69: ,NULL)))) BNHMEN,
70: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
71: ,P_REPORT_DATE)
72: ,NULL
73: ,(DECODE(PEO.PER_INFORMATION1
74: ,'2'

Line 80: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

76: ,'F'
77: ,1
78: ,NULL)
79: ,NULL)))) BNHWMEN,
80: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
81: ,P_REPORT_DATE)
82: ,NULL
83: ,(DECODE(PEO.PER_INFORMATION1
84: ,'6'

Line 90: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

86: ,'M'
87: ,1
88: ,NULL)
89: ,NULL)))) AM_ALMEN,
90: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
91: ,P_REPORT_DATE)
92: ,NULL
93: ,(DECODE(PEO.PER_INFORMATION1
94: ,'6'

Line 100: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

96: ,'F'
97: ,1
98: ,NULL)
99: ,NULL)))) AM_ALWMEN,
100: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
101: ,P_REPORT_DATE)
102: ,NULL
103: ,(DECODE(PEO.PER_INFORMATION1
104: ,'4'

Line 115: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

111: ,'M'
112: ,1
113: ,NULL)
114: ,NULL)))) APMEN,
115: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
116: ,P_REPORT_DATE)
117: ,NULL
118: ,(DECODE(PEO.PER_INFORMATION1
119: ,'4'

Line 130: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

126: ,'F'
127: ,1
128: ,NULL)
129: ,NULL)))) APWMEN,
130: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
131: ,P_REPORT_DATE)
132: ,NULL
133: ,(DECODE(PEO.PER_INFORMATION1
134: ,'3'

Line 145: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

141: ,'M'
142: ,1
143: ,NULL)
144: ,NULL)))) HMEN,
145: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
146: ,P_REPORT_DATE)
147: ,NULL
148: ,(DECODE(PEO.PER_INFORMATION1
149: ,'3'

Line 160: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

156: ,'F'
157: ,1
158: ,NULL)
159: ,NULL)))) HWMEN,
160: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
161: ,P_REPORT_DATE)
162: ,NULL
163: ,(DECODE(PEO.PER_INFORMATION1
164: ,'1'

Line 170: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

166: ,'M'
167: ,1
168: ,NULL)
169: ,NULL)))) WNHMEN,
170: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
171: ,P_REPORT_DATE)
172: ,NULL
173: ,(DECODE(PEO.PER_INFORMATION1
174: ,'1'

Line 180: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

176: ,'F'
177: ,1
178: ,NULL)
179: ,NULL)))) WNHWMEN,
180: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
181: ,P_REPORT_DATE)
182: ,NULL
183: ,(DECODE(PEO.PER_INFORMATION1
184: ,NULL

Line 190: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

186: ,'M'
187: ,1
188: ,NULL)
189: ,NULL)))) URMEN,
190: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
191: ,P_REPORT_DATE)
192: ,NULL
193: ,(DECODE(PEO.PER_INFORMATION1
194: ,NULL

Line 464: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

460: CURSOR GET_LINE2_COUNTS IS
461: SELECT
462: '01' TENINFO,
463: '01' ARANK,
464: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
465: ,P_REPORT_DATE)
466: ,'1'
467: ,DECODE(PEO.SEX
468: ,'M'

Line 472: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

468: ,'M'
469: ,1
470: ,NULL)
471: ,NULL)) NRMEN,
472: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
473: ,P_REPORT_DATE)
474: ,'1'
475: ,DECODE(PEO.SEX
476: ,'F'

Line 480: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

476: ,'F'
477: ,1
478: ,NULL)
479: ,NULL)) NRWMEN,
480: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
481: ,P_REPORT_DATE)
482: ,NULL
483: ,(DECODE(PEO.PER_INFORMATION1
484: ,'2'

Line 490: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

486: ,'M'
487: ,1
488: ,NULL)
489: ,NULL)))) BNHMEN,
490: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
491: ,P_REPORT_DATE)
492: ,NULL
493: ,(DECODE(PEO.PER_INFORMATION1
494: ,'2'

Line 500: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

496: ,'F'
497: ,1
498: ,NULL)
499: ,NULL)))) BNHWMEN,
500: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
501: ,P_REPORT_DATE)
502: ,NULL
503: ,(DECODE(PEO.PER_INFORMATION1
504: ,'6'

Line 510: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

506: ,'M'
507: ,1
508: ,NULL)
509: ,NULL)))) AM_ALMEN,
510: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
511: ,P_REPORT_DATE)
512: ,NULL
513: ,(DECODE(PEO.PER_INFORMATION1
514: ,'6'

Line 520: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

516: ,'F'
517: ,1
518: ,NULL)
519: ,NULL)))) AM_ALWMEN,
520: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
521: ,P_REPORT_DATE)
522: ,NULL
523: ,(DECODE(PEO.PER_INFORMATION1
524: ,'4'

Line 535: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

531: ,'M'
532: ,1
533: ,NULL)
534: ,NULL)))) APMEN,
535: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
536: ,P_REPORT_DATE)
537: ,NULL
538: ,(DECODE(PEO.PER_INFORMATION1
539: ,'4'

Line 550: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

546: ,'F'
547: ,1
548: ,NULL)
549: ,NULL)))) APWMEN,
550: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
551: ,P_REPORT_DATE)
552: ,NULL
553: ,(DECODE(PEO.PER_INFORMATION1
554: ,'3'

Line 565: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

561: ,'M'
562: ,1
563: ,NULL)
564: ,NULL)))) HMEN,
565: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
566: ,P_REPORT_DATE)
567: ,NULL
568: ,(DECODE(PEO.PER_INFORMATION1
569: ,'3'

Line 580: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

576: ,'F'
577: ,1
578: ,NULL)
579: ,NULL)))) HWMEN,
580: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
581: ,P_REPORT_DATE)
582: ,NULL
583: ,(DECODE(PEO.PER_INFORMATION1
584: ,'1'

Line 590: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

586: ,'M'
587: ,1
588: ,NULL)
589: ,NULL)))) WNHMEN,
590: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
591: ,P_REPORT_DATE)
592: ,NULL
593: ,(DECODE(PEO.PER_INFORMATION1
594: ,'1'

Line 600: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

596: ,'F'
597: ,1
598: ,NULL)
599: ,NULL)))) WNHWMEN,
600: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
601: ,P_REPORT_DATE)
602: ,NULL
603: ,(DECODE(PEO.PER_INFORMATION1
604: ,NULL

Line 610: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

606: ,'M'
607: ,1
608: ,NULL)
609: ,NULL)))) URMEN,
610: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
611: ,P_REPORT_DATE)
612: ,NULL
613: ,(DECODE(PEO.PER_INFORMATION1
614: ,NULL

Line 883: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

879: CURSOR GET_LINE3_COUNTS IS
880: SELECT
881: '02' TENINFO,
882: HLA.LOOKUP_CODE ARANK,
883: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
884: ,P_REPORT_DATE)
885: ,'1'
886: ,DECODE(PEO.SEX
887: ,'M'

Line 891: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

887: ,'M'
888: ,1
889: ,NULL)
890: ,NULL)) NRMEN,
891: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
892: ,P_REPORT_DATE)
893: ,'1'
894: ,DECODE(PEO.SEX
895: ,'F'

Line 899: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

895: ,'F'
896: ,1
897: ,NULL)
898: ,NULL)) NRWMEN,
899: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
900: ,P_REPORT_DATE)
901: ,NULL
902: ,(DECODE(PEO.PER_INFORMATION1
903: ,'2'

Line 909: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

905: ,'M'
906: ,1
907: ,NULL)
908: ,NULL)))) BNHMEN,
909: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
910: ,P_REPORT_DATE)
911: ,NULL
912: ,(DECODE(PEO.PER_INFORMATION1
913: ,'2'

Line 919: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

915: ,'F'
916: ,1
917: ,NULL)
918: ,NULL)))) BNHWMEN,
919: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
920: ,P_REPORT_DATE)
921: ,NULL
922: ,(DECODE(PEO.PER_INFORMATION1
923: ,'6'

Line 929: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

925: ,'M'
926: ,1
927: ,NULL)
928: ,NULL)))) AM_ALMEN,
929: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
930: ,P_REPORT_DATE)
931: ,NULL
932: ,(DECODE(PEO.PER_INFORMATION1
933: ,'6'

Line 939: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

935: ,'F'
936: ,1
937: ,NULL)
938: ,NULL)))) AM_ALWMEN,
939: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
940: ,P_REPORT_DATE)
941: ,NULL
942: ,(DECODE(PEO.PER_INFORMATION1
943: ,'4'

Line 954: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

950: ,'M'
951: ,1
952: ,NULL)
953: ,NULL)))) APMEN,
954: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
955: ,P_REPORT_DATE)
956: ,NULL
957: ,(DECODE(PEO.PER_INFORMATION1
958: ,'4'

Line 969: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

965: ,'F'
966: ,1
967: ,NULL)
968: ,NULL)))) APWMEN,
969: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
970: ,P_REPORT_DATE)
971: ,NULL
972: ,(DECODE(PEO.PER_INFORMATION1
973: ,'3'

Line 984: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

980: ,'M'
981: ,1
982: ,NULL)
983: ,NULL)))) HMEN,
984: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
985: ,P_REPORT_DATE)
986: ,NULL
987: ,(DECODE(PEO.PER_INFORMATION1
988: ,'3'

Line 999: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

995: ,'F'
996: ,1
997: ,NULL)
998: ,NULL)))) HWMEN,
999: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1000: ,P_REPORT_DATE)
1001: ,NULL
1002: ,(DECODE(PEO.PER_INFORMATION1
1003: ,'1'

Line 1009: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1005: ,'M'
1006: ,1
1007: ,NULL)
1008: ,NULL)))) WNHMEN,
1009: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1010: ,P_REPORT_DATE)
1011: ,NULL
1012: ,(DECODE(PEO.PER_INFORMATION1
1013: ,'1'

Line 1019: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1015: ,'F'
1016: ,1
1017: ,NULL)
1018: ,NULL)))) WNHWMEN,
1019: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1020: ,P_REPORT_DATE)
1021: ,NULL
1022: ,(DECODE(PEO.PER_INFORMATION1
1023: ,NULL

Line 1029: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1025: ,'M'
1026: ,1
1027: ,NULL)
1028: ,NULL)))) URMEN,
1029: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1030: ,P_REPORT_DATE)
1031: ,NULL
1032: ,(DECODE(PEO.PER_INFORMATION1
1033: ,NULL

Line 1303: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1299: CURSOR GET_LINE4_COUNTS IS
1300: SELECT
1301: '02' TENINFO,
1302: '01' ARANK,
1303: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1304: ,P_REPORT_DATE)
1305: ,'1'
1306: ,DECODE(PEO.SEX
1307: ,'M'

Line 1311: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1307: ,'M'
1308: ,1
1309: ,NULL)
1310: ,NULL)) NRMEN,
1311: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1312: ,P_REPORT_DATE)
1313: ,'1'
1314: ,DECODE(PEO.SEX
1315: ,'F'

Line 1319: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1315: ,'F'
1316: ,1
1317: ,NULL)
1318: ,NULL)) NRWMEN,
1319: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1320: ,P_REPORT_DATE)
1321: ,NULL
1322: ,(DECODE(PEO.PER_INFORMATION1
1323: ,'2'

Line 1329: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1325: ,'M'
1326: ,1
1327: ,NULL)
1328: ,NULL)))) BNHMEN,
1329: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1330: ,P_REPORT_DATE)
1331: ,NULL
1332: ,(DECODE(PEO.PER_INFORMATION1
1333: ,'2'

Line 1339: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1335: ,'F'
1336: ,1
1337: ,NULL)
1338: ,NULL)))) BNHWMEN,
1339: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1340: ,P_REPORT_DATE)
1341: ,NULL
1342: ,(DECODE(PEO.PER_INFORMATION1
1343: ,'6'

Line 1349: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1345: ,'M'
1346: ,1
1347: ,NULL)
1348: ,NULL)))) AM_ALMEN,
1349: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1350: ,P_REPORT_DATE)
1351: ,NULL
1352: ,(DECODE(PEO.PER_INFORMATION1
1353: ,'6'

Line 1359: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1355: ,'F'
1356: ,1
1357: ,NULL)
1358: ,NULL)))) AM_ALWMEN,
1359: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1360: ,P_REPORT_DATE)
1361: ,NULL
1362: ,(DECODE(PEO.PER_INFORMATION1
1363: ,'4'

Line 1374: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1370: ,'M'
1371: ,1
1372: ,NULL)
1373: ,NULL)))) APMEN,
1374: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1375: ,P_REPORT_DATE)
1376: ,NULL
1377: ,(DECODE(PEO.PER_INFORMATION1
1378: ,'4'

Line 1389: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1385: ,'F'
1386: ,1
1387: ,NULL)
1388: ,NULL)))) APWMEN,
1389: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1390: ,P_REPORT_DATE)
1391: ,NULL
1392: ,(DECODE(PEO.PER_INFORMATION1
1393: ,'3'

Line 1404: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1400: ,'M'
1401: ,1
1402: ,NULL)
1403: ,NULL)))) HMEN,
1404: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1405: ,P_REPORT_DATE)
1406: ,NULL
1407: ,(DECODE(PEO.PER_INFORMATION1
1408: ,'3'

Line 1419: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1415: ,'F'
1416: ,1
1417: ,NULL)
1418: ,NULL)))) HWMEN,
1419: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1420: ,P_REPORT_DATE)
1421: ,NULL
1422: ,(DECODE(PEO.PER_INFORMATION1
1423: ,'1'

Line 1429: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1425: ,'M'
1426: ,1
1427: ,NULL)
1428: ,NULL)))) WNHMEN,
1429: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1430: ,P_REPORT_DATE)
1431: ,NULL
1432: ,(DECODE(PEO.PER_INFORMATION1
1433: ,'1'

Line 1439: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1435: ,'F'
1436: ,1
1437: ,NULL)
1438: ,NULL)))) WNHWMEN,
1439: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1440: ,P_REPORT_DATE)
1441: ,NULL
1442: ,(DECODE(PEO.PER_INFORMATION1
1443: ,NULL

Line 1449: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1445: ,'M'
1446: ,1
1447: ,NULL)
1448: ,NULL)))) URMEN,
1449: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1450: ,P_REPORT_DATE)
1451: ,NULL
1452: ,(DECODE(PEO.PER_INFORMATION1
1453: ,NULL

Line 1722: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1718: CURSOR GET_LINE5_COUNTS IS
1719: SELECT
1720: '03' TENINFO,
1721: HLA.LOOKUP_CODE ARANK,
1722: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1723: ,P_REPORT_DATE)
1724: ,'1'
1725: ,DECODE(PEO.SEX
1726: ,'M'

Line 1730: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1726: ,'M'
1727: ,1
1728: ,NULL)
1729: ,NULL)) NRMEN,
1730: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1731: ,P_REPORT_DATE)
1732: ,'1'
1733: ,DECODE(PEO.SEX
1734: ,'F'

Line 1738: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1734: ,'F'
1735: ,1
1736: ,NULL)
1737: ,NULL)) NRWMEN,
1738: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1739: ,P_REPORT_DATE)
1740: ,NULL
1741: ,(DECODE(PEO.PER_INFORMATION1
1742: ,'2'

Line 1748: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1744: ,'M'
1745: ,1
1746: ,NULL)
1747: ,NULL)))) BNHMEN,
1748: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1749: ,P_REPORT_DATE)
1750: ,NULL
1751: ,(DECODE(PEO.PER_INFORMATION1
1752: ,'2'

Line 1758: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1754: ,'F'
1755: ,1
1756: ,NULL)
1757: ,NULL)))) BNHWMEN,
1758: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1759: ,P_REPORT_DATE)
1760: ,NULL
1761: ,(DECODE(PEO.PER_INFORMATION1
1762: ,'6'

Line 1768: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1764: ,'M'
1765: ,1
1766: ,NULL)
1767: ,NULL)))) AM_ALMEN,
1768: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1769: ,P_REPORT_DATE)
1770: ,NULL
1771: ,(DECODE(PEO.PER_INFORMATION1
1772: ,'6'

Line 1778: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1774: ,'F'
1775: ,1
1776: ,NULL)
1777: ,NULL)))) AM_ALWMEN,
1778: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1779: ,P_REPORT_DATE)
1780: ,NULL
1781: ,(DECODE(PEO.PER_INFORMATION1
1782: ,'4'

Line 1793: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1789: ,'M'
1790: ,1
1791: ,NULL)
1792: ,NULL)))) APMEN,
1793: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1794: ,P_REPORT_DATE)
1795: ,NULL
1796: ,(DECODE(PEO.PER_INFORMATION1
1797: ,'4'

Line 1808: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1804: ,'F'
1805: ,1
1806: ,NULL)
1807: ,NULL)))) APWMEN,
1808: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1809: ,P_REPORT_DATE)
1810: ,NULL
1811: ,(DECODE(PEO.PER_INFORMATION1
1812: ,'3'

Line 1823: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1819: ,'M'
1820: ,1
1821: ,NULL)
1822: ,NULL)))) HMEN,
1823: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1824: ,P_REPORT_DATE)
1825: ,NULL
1826: ,(DECODE(PEO.PER_INFORMATION1
1827: ,'3'

Line 1838: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1834: ,'F'
1835: ,1
1836: ,NULL)
1837: ,NULL)))) HWMEN,
1838: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1839: ,P_REPORT_DATE)
1840: ,NULL
1841: ,(DECODE(PEO.PER_INFORMATION1
1842: ,'1'

Line 1848: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1844: ,'M'
1845: ,1
1846: ,NULL)
1847: ,NULL)))) WNHMEN,
1848: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1849: ,P_REPORT_DATE)
1850: ,NULL
1851: ,(DECODE(PEO.PER_INFORMATION1
1852: ,'1'

Line 1858: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1854: ,'F'
1855: ,1
1856: ,NULL)
1857: ,NULL)))) WNHWMEN,
1858: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1859: ,P_REPORT_DATE)
1860: ,NULL
1861: ,(DECODE(PEO.PER_INFORMATION1
1862: ,NULL

Line 1868: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

1864: ,'M'
1865: ,1
1866: ,NULL)
1867: ,NULL)))) URMEN,
1868: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1869: ,P_REPORT_DATE)
1870: ,NULL
1871: ,(DECODE(PEO.PER_INFORMATION1
1872: ,NULL

Line 2148: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2144: CURSOR GET_LINE6_COUNTS IS
2145: SELECT
2146: '03' TENINFO,
2147: '01' ARANK,
2148: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2149: ,P_REPORT_DATE)
2150: ,'1'
2151: ,DECODE(PEO.SEX
2152: ,'M'

Line 2156: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2152: ,'M'
2153: ,1
2154: ,NULL)
2155: ,NULL)) NRMEN,
2156: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2157: ,P_REPORT_DATE)
2158: ,'1'
2159: ,DECODE(PEO.SEX
2160: ,'F'

Line 2164: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2160: ,'F'
2161: ,1
2162: ,NULL)
2163: ,NULL)) NRWMEN,
2164: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2165: ,P_REPORT_DATE)
2166: ,NULL
2167: ,(DECODE(PEO.PER_INFORMATION1
2168: ,'2'

Line 2174: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2170: ,'M'
2171: ,1
2172: ,NULL)
2173: ,NULL)))) BNHMEN,
2174: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2175: ,P_REPORT_DATE)
2176: ,NULL
2177: ,(DECODE(PEO.PER_INFORMATION1
2178: ,'2'

Line 2184: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2180: ,'F'
2181: ,1
2182: ,NULL)
2183: ,NULL)))) BNHWMEN,
2184: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2185: ,P_REPORT_DATE)
2186: ,NULL
2187: ,(DECODE(PEO.PER_INFORMATION1
2188: ,'6'

Line 2194: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2190: ,'M'
2191: ,1
2192: ,NULL)
2193: ,NULL)))) AM_ALMEN,
2194: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2195: ,P_REPORT_DATE)
2196: ,NULL
2197: ,(DECODE(PEO.PER_INFORMATION1
2198: ,'6'

Line 2204: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2200: ,'F'
2201: ,1
2202: ,NULL)
2203: ,NULL)))) AM_ALWMEN,
2204: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2205: ,P_REPORT_DATE)
2206: ,NULL
2207: ,(DECODE(PEO.PER_INFORMATION1
2208: ,'4'

Line 2219: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2215: ,'M'
2216: ,1
2217: ,NULL)
2218: ,NULL)))) APMEN,
2219: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2220: ,P_REPORT_DATE)
2221: ,NULL
2222: ,(DECODE(PEO.PER_INFORMATION1
2223: ,'4'

Line 2234: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2230: ,'F'
2231: ,1
2232: ,NULL)
2233: ,NULL)))) APWMEN,
2234: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2235: ,P_REPORT_DATE)
2236: ,NULL
2237: ,(DECODE(PEO.PER_INFORMATION1
2238: ,'3'

Line 2249: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2245: ,'M'
2246: ,1
2247: ,NULL)
2248: ,NULL)))) HMEN,
2249: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2250: ,P_REPORT_DATE)
2251: ,NULL
2252: ,(DECODE(PEO.PER_INFORMATION1
2253: ,'3'

Line 2264: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2260: ,'F'
2261: ,1
2262: ,NULL)
2263: ,NULL)))) HWMEN,
2264: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2265: ,P_REPORT_DATE)
2266: ,NULL
2267: ,(DECODE(PEO.PER_INFORMATION1
2268: ,'1'

Line 2274: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2270: ,'M'
2271: ,1
2272: ,NULL)
2273: ,NULL)))) WNHMEN,
2274: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2275: ,P_REPORT_DATE)
2276: ,NULL
2277: ,(DECODE(PEO.PER_INFORMATION1
2278: ,'1'

Line 2284: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2280: ,'F'
2281: ,1
2282: ,NULL)
2283: ,NULL)))) WNHWMEN,
2284: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2285: ,P_REPORT_DATE)
2286: ,NULL
2287: ,(DECODE(PEO.PER_INFORMATION1
2288: ,NULL

Line 2294: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

2290: ,'M'
2291: ,1
2292: ,NULL)
2293: ,NULL)))) URMEN,
2294: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
2295: ,P_REPORT_DATE)
2296: ,NULL
2297: ,(DECODE(PEO.PER_INFORMATION1
2298: ,NULL