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

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

121: CURSOR GET_LINE1_COUNTS IS
122: SELECT
123: 2 LINE,
124: HL.LOOKUP_CODE JOBCODE,
125: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
126: ,P_REPORT_DATE)
127: ,'1'
128: ,DECODE(PEO.SEX
129: ,'M'

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

129: ,'M'
130: ,1
131: ,NULL)
132: ,NULL)) NRMEN,
133: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
134: ,P_REPORT_DATE)
135: ,'1'
136: ,DECODE(PEO.SEX
137: ,'F'

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

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

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

147: ,'M'
148: ,1
149: ,NULL)
150: ,NULL)))) BNHMEN,
151: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
152: ,P_REPORT_DATE)
153: ,NULL
154: ,(DECODE(PEO.PER_INFORMATION1
155: ,'2'

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

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

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

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

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

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

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

192: ,'M'
193: ,1
194: ,NULL)
195: ,NULL)))) APMEN,
196: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
197: ,P_REPORT_DATE)
198: ,NULL
199: ,(DECODE(PEO.PER_INFORMATION1
200: ,'4'

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

207: ,'F'
208: ,1
209: ,NULL)
210: ,NULL)))) APWMEN,
211: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
212: ,P_REPORT_DATE)
213: ,NULL
214: ,(DECODE(PEO.PER_INFORMATION1
215: ,'3'

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

222: ,'M'
223: ,1
224: ,NULL)
225: ,NULL)))) HMEN,
226: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
227: ,P_REPORT_DATE)
228: ,NULL
229: ,(DECODE(PEO.PER_INFORMATION1
230: ,'3'

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

237: ,'F'
238: ,1
239: ,NULL)
240: ,NULL)))) HWMEN,
241: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
242: ,P_REPORT_DATE)
243: ,NULL
244: ,(DECODE(PEO.PER_INFORMATION1
245: ,'1'

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

247: ,'M'
248: ,1
249: ,NULL)
250: ,NULL)))) WNHMEN,
251: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
252: ,P_REPORT_DATE)
253: ,NULL
254: ,(DECODE(PEO.PER_INFORMATION1
255: ,'1'

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

257: ,'F'
258: ,1
259: ,NULL)
260: ,NULL)))) WNHWMEN,
261: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
262: ,P_REPORT_DATE)
263: ,NULL
264: ,(DECODE(PEO.PER_INFORMATION1
265: ,NULL

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

267: ,'M'
268: ,1
269: ,NULL)
270: ,NULL)))) URMEN,
271: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
272: ,P_REPORT_DATE)
273: ,NULL
274: ,(DECODE(PEO.PER_INFORMATION1
275: ,NULL

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

506: CURSOR GET_LINE2_COUNTS IS
507: SELECT
508: 1 LINE,
509: 'Faculty(Instruction/Research/Public Service)' DISP_NAME,
510: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
511: ,P_REPORT_DATE)
512: ,'1'
513: ,DECODE(PEO.SEX
514: ,'M'

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

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

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

522: ,'F'
523: ,1
524: ,NULL)
525: ,NULL)) NRWMEN,
526: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
527: ,P_REPORT_DATE)
528: ,NULL
529: ,(DECODE(PEO.PER_INFORMATION1
530: ,'2'

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

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

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

542: ,'F'
543: ,1
544: ,NULL)
545: ,NULL)))) BNHWMEN,
546: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
547: ,P_REPORT_DATE)
548: ,NULL
549: ,(DECODE(PEO.PER_INFORMATION1
550: ,'6'

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

552: ,'M'
553: ,1
554: ,NULL)
555: ,NULL)))) AM_ALMEN,
556: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
557: ,P_REPORT_DATE)
558: ,NULL
559: ,(DECODE(PEO.PER_INFORMATION1
560: ,'6'

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

562: ,'F'
563: ,1
564: ,NULL)
565: ,NULL)))) AM_ALWMEN,
566: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
567: ,P_REPORT_DATE)
568: ,NULL
569: ,(DECODE(PEO.PER_INFORMATION1
570: ,'4'

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

577: ,'M'
578: ,1
579: ,NULL)
580: ,NULL)))) A_PMEN,
581: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
582: ,P_REPORT_DATE)
583: ,NULL
584: ,(DECODE(PEO.PER_INFORMATION1
585: ,'4'

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

592: ,'F'
593: ,1
594: ,NULL)
595: ,NULL)))) A_PWMEN,
596: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
597: ,P_REPORT_DATE)
598: ,NULL
599: ,(DECODE(PEO.PER_INFORMATION1
600: ,'3'

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

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

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

622: ,'F'
623: ,1
624: ,NULL)
625: ,NULL)))) HWMEN,
626: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
627: ,P_REPORT_DATE)
628: ,NULL
629: ,(DECODE(PEO.PER_INFORMATION1
630: ,'1'

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

632: ,'M'
633: ,1
634: ,NULL)
635: ,NULL)))) WNHMEN,
636: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
637: ,P_REPORT_DATE)
638: ,NULL
639: ,(DECODE(PEO.PER_INFORMATION1
640: ,'1'

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

642: ,'F'
643: ,1
644: ,NULL)
645: ,NULL)))) WNHWMEN,
646: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
647: ,P_REPORT_DATE)
648: ,NULL
649: ,(DECODE(PEO.PER_INFORMATION1
650: ,NULL

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

652: ,'M'
653: ,1
654: ,NULL)
655: ,NULL)))) URMEN,
656: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
657: ,P_REPORT_DATE)
658: ,NULL
659: ,(DECODE(PEO.PER_INFORMATION1
660: ,NULL