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 PQH_NR_ALIEN_PKG

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

50: L_TMR_UR_WMEN NUMBER(10) := 0;
51: CURSOR GET_LINE1_COUNTS IS
52: SELECT
53: '1' JCODE,
54: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
55: ,P_REPORT_DATE)
56: ,'1'
57: ,DECODE(PEO.SEX
58: ,'M'

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

58: ,'M'
59: ,1
60: ,NULL)
61: ,NULL)) NRMEN,
62: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
63: ,P_REPORT_DATE)
64: ,'1'
65: ,DECODE(PEO.SEX
66: ,'F'

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

66: ,'F'
67: ,1
68: ,NULL)
69: ,NULL)) NRWMEN,
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: ,'M'
77: ,1
78: ,NULL)
79: ,NULL)))) BNHMEN,
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: ,'2'

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

86: ,'F'
87: ,1
88: ,NULL)
89: ,NULL)))) BNHWMEN,
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: ,'M'
97: ,1
98: ,NULL)
99: ,NULL)))) AM_ALMEN,
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: ,'6'

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

106: ,'F'
107: ,1
108: ,NULL)
109: ,NULL)))) AM_ALWMEN,
110: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
111: ,P_REPORT_DATE)
112: ,NULL
113: ,(DECODE(PEO.PER_INFORMATION1
114: ,'4'

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

121: ,'M'
122: ,1
123: ,NULL)
124: ,NULL)))) APMEN,
125: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
126: ,P_REPORT_DATE)
127: ,NULL
128: ,(DECODE(PEO.PER_INFORMATION1
129: ,'4'

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

136: ,'F'
137: ,1
138: ,NULL)
139: ,NULL)))) APWMEN,
140: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
141: ,P_REPORT_DATE)
142: ,NULL
143: ,(DECODE(PEO.PER_INFORMATION1
144: ,'3'

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

151: ,'M'
152: ,1
153: ,NULL)
154: ,NULL)))) HMEN,
155: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
156: ,P_REPORT_DATE)
157: ,NULL
158: ,(DECODE(PEO.PER_INFORMATION1
159: ,'3'

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

166: ,'F'
167: ,1
168: ,NULL)
169: ,NULL)))) HWMEN,
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: ,'M'
177: ,1
178: ,NULL)
179: ,NULL)))) WNHMEN,
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: ,'1'

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

186: ,'F'
187: ,1
188: ,NULL)
189: ,NULL)))) WNHWMEN,
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 200: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID

196: ,'M'
197: ,1
198: ,NULL)
199: ,NULL)))) URMEN,
200: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
201: ,P_REPORT_DATE)
202: ,NULL
203: ,(DECODE(PEO.PER_INFORMATION1
204: ,NULL

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

413: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
414: CURSOR GET_LINE2_COUNTS IS
415: SELECT
416: '2' JCODE,
417: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
418: ,P_REPORT_DATE)
419: ,'1'
420: ,DECODE(PEO.SEX
421: ,'M'

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

421: ,'M'
422: ,1
423: ,NULL)
424: ,NULL)) NRMEN,
425: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
426: ,P_REPORT_DATE)
427: ,'1'
428: ,DECODE(PEO.SEX
429: ,'F'

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

429: ,'F'
430: ,1
431: ,NULL)
432: ,NULL)) NRWMEN,
433: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
434: ,P_REPORT_DATE)
435: ,NULL
436: ,(DECODE(PEO.PER_INFORMATION1
437: ,'2'

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

439: ,'M'
440: ,1
441: ,NULL)
442: ,NULL)))) BNHMEN,
443: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
444: ,P_REPORT_DATE)
445: ,NULL
446: ,(DECODE(PEO.PER_INFORMATION1
447: ,'2'

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

449: ,'F'
450: ,1
451: ,NULL)
452: ,NULL)))) BNHWMEN,
453: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
454: ,P_REPORT_DATE)
455: ,NULL
456: ,(DECODE(PEO.PER_INFORMATION1
457: ,'6'

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

459: ,'M'
460: ,1
461: ,NULL)
462: ,NULL)))) AM_ALMEN,
463: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
464: ,P_REPORT_DATE)
465: ,NULL
466: ,(DECODE(PEO.PER_INFORMATION1
467: ,'6'

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

469: ,'F'
470: ,1
471: ,NULL)
472: ,NULL)))) AM_ALWMEN,
473: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
474: ,P_REPORT_DATE)
475: ,NULL
476: ,(DECODE(PEO.PER_INFORMATION1
477: ,'4'

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

484: ,'M'
485: ,1
486: ,NULL)
487: ,NULL)))) APMEN,
488: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
489: ,P_REPORT_DATE)
490: ,NULL
491: ,(DECODE(PEO.PER_INFORMATION1
492: ,'4'

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

499: ,'F'
500: ,1
501: ,NULL)
502: ,NULL)))) APWMEN,
503: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
504: ,P_REPORT_DATE)
505: ,NULL
506: ,(DECODE(PEO.PER_INFORMATION1
507: ,'3'

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

514: ,'M'
515: ,1
516: ,NULL)
517: ,NULL)))) HMEN,
518: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
519: ,P_REPORT_DATE)
520: ,NULL
521: ,(DECODE(PEO.PER_INFORMATION1
522: ,'3'

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

529: ,'F'
530: ,1
531: ,NULL)
532: ,NULL)))) HWMEN,
533: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
534: ,P_REPORT_DATE)
535: ,NULL
536: ,(DECODE(PEO.PER_INFORMATION1
537: ,'1'

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

539: ,'M'
540: ,1
541: ,NULL)
542: ,NULL)))) WNHMEN,
543: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
544: ,P_REPORT_DATE)
545: ,NULL
546: ,(DECODE(PEO.PER_INFORMATION1
547: ,'1'

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

549: ,'F'
550: ,1
551: ,NULL)
552: ,NULL)))) WNHWMEN,
553: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
554: ,P_REPORT_DATE)
555: ,NULL
556: ,(DECODE(PEO.PER_INFORMATION1
557: ,NULL

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

559: ,'M'
560: ,1
561: ,NULL)
562: ,NULL)))) URMEN,
563: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
564: ,P_REPORT_DATE)
565: ,NULL
566: ,(DECODE(PEO.PER_INFORMATION1
567: ,NULL

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

776: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
777: CURSOR GET_LINE3_COUNTS IS
778: SELECT
779: '3' JCODE,
780: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
781: ,P_REPORT_DATE)
782: ,'1'
783: ,DECODE(PEO.SEX
784: ,'M'

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

784: ,'M'
785: ,1
786: ,NULL)
787: ,NULL)) NRMEN,
788: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
789: ,P_REPORT_DATE)
790: ,'1'
791: ,DECODE(PEO.SEX
792: ,'F'

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

792: ,'F'
793: ,1
794: ,NULL)
795: ,NULL)) NRWMEN,
796: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
797: ,P_REPORT_DATE)
798: ,NULL
799: ,(DECODE(PEO.PER_INFORMATION1
800: ,'2'

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

802: ,'M'
803: ,1
804: ,NULL)
805: ,NULL)))) BNHMEN,
806: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
807: ,P_REPORT_DATE)
808: ,NULL
809: ,(DECODE(PEO.PER_INFORMATION1
810: ,'2'

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

812: ,'F'
813: ,1
814: ,NULL)
815: ,NULL)))) BNHWMEN,
816: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
817: ,P_REPORT_DATE)
818: ,NULL
819: ,(DECODE(PEO.PER_INFORMATION1
820: ,'6'

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

822: ,'M'
823: ,1
824: ,NULL)
825: ,NULL)))) AM_ALMEN,
826: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
827: ,P_REPORT_DATE)
828: ,NULL
829: ,(DECODE(PEO.PER_INFORMATION1
830: ,'6'

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

832: ,'F'
833: ,1
834: ,NULL)
835: ,NULL)))) AM_ALWMEN,
836: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
837: ,P_REPORT_DATE)
838: ,NULL
839: ,(DECODE(PEO.PER_INFORMATION1
840: ,'4'

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

847: ,'M'
848: ,1
849: ,NULL)
850: ,NULL)))) APMEN,
851: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
852: ,P_REPORT_DATE)
853: ,NULL
854: ,(DECODE(PEO.PER_INFORMATION1
855: ,'4'

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

862: ,'F'
863: ,1
864: ,NULL)
865: ,NULL)))) APWMEN,
866: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
867: ,P_REPORT_DATE)
868: ,NULL
869: ,(DECODE(PEO.PER_INFORMATION1
870: ,'3'

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

877: ,'M'
878: ,1
879: ,NULL)
880: ,NULL)))) HMEN,
881: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
882: ,P_REPORT_DATE)
883: ,NULL
884: ,(DECODE(PEO.PER_INFORMATION1
885: ,'3'

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

892: ,'F'
893: ,1
894: ,NULL)
895: ,NULL)))) HWMEN,
896: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
897: ,P_REPORT_DATE)
898: ,NULL
899: ,(DECODE(PEO.PER_INFORMATION1
900: ,'1'

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

902: ,'M'
903: ,1
904: ,NULL)
905: ,NULL)))) WNHMEN,
906: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
907: ,P_REPORT_DATE)
908: ,NULL
909: ,(DECODE(PEO.PER_INFORMATION1
910: ,'1'

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

912: ,'F'
913: ,1
914: ,NULL)
915: ,NULL)))) WNHWMEN,
916: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
917: ,P_REPORT_DATE)
918: ,NULL
919: ,(DECODE(PEO.PER_INFORMATION1
920: ,NULL

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

922: ,'M'
923: ,1
924: ,NULL)
925: ,NULL)))) URMEN,
926: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
927: ,P_REPORT_DATE)
928: ,NULL
929: ,(DECODE(PEO.PER_INFORMATION1
930: ,NULL

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

1145: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID );
1146: CURSOR GET_LINE4_COUNTS IS
1147: SELECT
1148: HL.LOOKUP_CODE JCODE,
1149: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1150: ,P_REPORT_DATE)
1151: ,'1'
1152: ,DECODE(PEO.SEX
1153: ,'M'

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

1153: ,'M'
1154: ,1
1155: ,NULL)
1156: ,NULL)) NRMEN,
1157: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1158: ,P_REPORT_DATE)
1159: ,'1'
1160: ,DECODE(PEO.SEX
1161: ,'F'

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

1161: ,'F'
1162: ,1
1163: ,NULL)
1164: ,NULL)) NRWMEN,
1165: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1166: ,P_REPORT_DATE)
1167: ,NULL
1168: ,(DECODE(PEO.PER_INFORMATION1
1169: ,'2'

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

1171: ,'M'
1172: ,1
1173: ,NULL)
1174: ,NULL)))) BNHMEN,
1175: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1176: ,P_REPORT_DATE)
1177: ,NULL
1178: ,(DECODE(PEO.PER_INFORMATION1
1179: ,'2'

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

1181: ,'F'
1182: ,1
1183: ,NULL)
1184: ,NULL)))) BNHWMEN,
1185: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1186: ,P_REPORT_DATE)
1187: ,NULL
1188: ,(DECODE(PEO.PER_INFORMATION1
1189: ,'6'

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

1191: ,'M'
1192: ,1
1193: ,NULL)
1194: ,NULL)))) AM_ALMEN,
1195: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1196: ,P_REPORT_DATE)
1197: ,NULL
1198: ,(DECODE(PEO.PER_INFORMATION1
1199: ,'6'

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

1201: ,'F'
1202: ,1
1203: ,NULL)
1204: ,NULL)))) AM_ALWMEN,
1205: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1206: ,P_REPORT_DATE)
1207: ,NULL
1208: ,(DECODE(PEO.PER_INFORMATION1
1209: ,'4'

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

1216: ,'M'
1217: ,1
1218: ,NULL)
1219: ,NULL)))) APMEN,
1220: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1221: ,P_REPORT_DATE)
1222: ,NULL
1223: ,(DECODE(PEO.PER_INFORMATION1
1224: ,'4'

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

1231: ,'F'
1232: ,1
1233: ,NULL)
1234: ,NULL)))) APWMEN,
1235: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1236: ,P_REPORT_DATE)
1237: ,NULL
1238: ,(DECODE(PEO.PER_INFORMATION1
1239: ,'3'

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

1246: ,'M'
1247: ,1
1248: ,NULL)
1249: ,NULL)))) HMEN,
1250: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1251: ,P_REPORT_DATE)
1252: ,NULL
1253: ,(DECODE(PEO.PER_INFORMATION1
1254: ,'3'

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

1261: ,'F'
1262: ,1
1263: ,NULL)
1264: ,NULL)))) HWMEN,
1265: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1266: ,P_REPORT_DATE)
1267: ,NULL
1268: ,(DECODE(PEO.PER_INFORMATION1
1269: ,'1'

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

1271: ,'M'
1272: ,1
1273: ,NULL)
1274: ,NULL)))) WNHMEN,
1275: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1276: ,P_REPORT_DATE)
1277: ,NULL
1278: ,(DECODE(PEO.PER_INFORMATION1
1279: ,'1'

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

1281: ,'F'
1282: ,1
1283: ,NULL)
1284: ,NULL)))) WNHWMEN,
1285: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1286: ,P_REPORT_DATE)
1287: ,NULL
1288: ,(DECODE(PEO.PER_INFORMATION1
1289: ,NULL

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

1291: ,'M'
1292: ,1
1293: ,NULL)
1294: ,NULL)))) URMEN,
1295: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
1296: ,P_REPORT_DATE)
1297: ,NULL
1298: ,(DECODE(PEO.PER_INFORMATION1
1299: ,NULL