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 PQH_NR_ALIEN_PKG

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

185: ,CP_PR
186: ,CP_PT)
187: ,NVL(PPP.PROPOSED_SALARY_N
188: ,0) * PPB.PAY_ANNUALIZATION_FACTOR) SALARY_RANGE,
189: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
190: ,P_REPORT_DATE)
191: ,'1'
192: ,DECODE(PEO.SEX
193: ,'M'

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

193: ,'M'
194: ,1
195: ,NULL)
196: ,NULL)) NRMEN,
197: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
198: ,P_REPORT_DATE)
199: ,'1'
200: ,DECODE(PEO.SEX
201: ,'F'

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

201: ,'F'
202: ,1
203: ,NULL)
204: ,NULL)) NRWMEN,
205: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
206: ,P_REPORT_DATE)
207: ,NULL
208: ,(DECODE(PEO.PER_INFORMATION1
209: ,'2'

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

211: ,'M'
212: ,1
213: ,NULL)
214: ,NULL)))) BNHMEN,
215: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
216: ,P_REPORT_DATE)
217: ,NULL
218: ,(DECODE(PEO.PER_INFORMATION1
219: ,'2'

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

221: ,'F'
222: ,1
223: ,NULL)
224: ,NULL)))) BNHWMEN,
225: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
226: ,P_REPORT_DATE)
227: ,NULL
228: ,(DECODE(PEO.PER_INFORMATION1
229: ,'6'

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

231: ,'M'
232: ,1
233: ,NULL)
234: ,NULL)))) AM_ALMEN,
235: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
236: ,P_REPORT_DATE)
237: ,NULL
238: ,(DECODE(PEO.PER_INFORMATION1
239: ,'6'

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

241: ,'F'
242: ,1
243: ,NULL)
244: ,NULL)))) AM_ALWMEN,
245: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
246: ,P_REPORT_DATE)
247: ,NULL
248: ,(DECODE(PEO.PER_INFORMATION1
249: ,'4'

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

256: ,'M'
257: ,1
258: ,NULL)
259: ,NULL)))) A_PMEN,
260: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
261: ,P_REPORT_DATE)
262: ,NULL
263: ,(DECODE(PEO.PER_INFORMATION1
264: ,'4'

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

271: ,'F'
272: ,1
273: ,NULL)
274: ,NULL)))) A_PWMEN,
275: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
276: ,P_REPORT_DATE)
277: ,NULL
278: ,(DECODE(PEO.PER_INFORMATION1
279: ,'3'

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

286: ,'M'
287: ,1
288: ,NULL)
289: ,NULL)))) HMEN,
290: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
291: ,P_REPORT_DATE)
292: ,NULL
293: ,(DECODE(PEO.PER_INFORMATION1
294: ,'3'

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

301: ,'F'
302: ,1
303: ,NULL)
304: ,NULL)))) HWMEN,
305: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
306: ,P_REPORT_DATE)
307: ,NULL
308: ,(DECODE(PEO.PER_INFORMATION1
309: ,'1'

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

311: ,'M'
312: ,1
313: ,NULL)
314: ,NULL)))) WNHMEN,
315: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
316: ,P_REPORT_DATE)
317: ,NULL
318: ,(DECODE(PEO.PER_INFORMATION1
319: ,'1'

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

321: ,'F'
322: ,1
323: ,NULL)
324: ,NULL)))) WNHWMEN,
325: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
326: ,P_REPORT_DATE)
327: ,NULL
328: ,(DECODE(PEO.PER_INFORMATION1
329: ,NULL

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

332: ,1
333: ,NULL)
334: ,NULL))
335: ,NULL)) URMEN,
336: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
337: ,P_REPORT_DATE)
338: ,NULL
339: ,(DECODE(PEO.PER_INFORMATION1
340: ,NULL

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

626: CURSOR GET_LINE2_COUNTS IS
627: SELECT
628: 1 LINE,
629: 'Less than 9 months' DISP_NAME,
630: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
631: ,P_REPORT_DATE)
632: ,'1'
633: ,DECODE(PEO.SEX
634: ,'M'

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

634: ,'M'
635: ,1
636: ,NULL)
637: ,NULL)) NRMEN,
638: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
639: ,P_REPORT_DATE)
640: ,'1'
641: ,DECODE(PEO.SEX
642: ,'F'

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

642: ,'F'
643: ,1
644: ,NULL)
645: ,NULL)) NRWMEN,
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: ,'2'

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

652: ,'M'
653: ,1
654: ,NULL)
655: ,NULL)))) BNHMEN,
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: ,'2'

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

662: ,'F'
663: ,1
664: ,NULL)
665: ,NULL)))) BNHWMEN,
666: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
667: ,P_REPORT_DATE)
668: ,NULL
669: ,(DECODE(PEO.PER_INFORMATION1
670: ,'6'

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

672: ,'M'
673: ,1
674: ,NULL)
675: ,NULL)))) AM_ALMEN,
676: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
677: ,P_REPORT_DATE)
678: ,NULL
679: ,(DECODE(PEO.PER_INFORMATION1
680: ,'6'

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

682: ,'F'
683: ,1
684: ,NULL)
685: ,NULL)))) AM_ALWMEN,
686: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
687: ,P_REPORT_DATE)
688: ,NULL
689: ,(DECODE(PEO.PER_INFORMATION1
690: ,'4'

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

697: ,'M'
698: ,1
699: ,NULL)
700: ,NULL)))) A_PMEN,
701: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
702: ,P_REPORT_DATE)
703: ,NULL
704: ,(DECODE(PEO.PER_INFORMATION1
705: ,'4'

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

712: ,'F'
713: ,1
714: ,NULL)
715: ,NULL)))) A_PWMEN,
716: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
717: ,P_REPORT_DATE)
718: ,NULL
719: ,(DECODE(PEO.PER_INFORMATION1
720: ,'3'

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

727: ,'M'
728: ,1
729: ,NULL)
730: ,NULL)))) HMEN,
731: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
732: ,P_REPORT_DATE)
733: ,NULL
734: ,(DECODE(PEO.PER_INFORMATION1
735: ,'3'

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

742: ,'F'
743: ,1
744: ,NULL)
745: ,NULL)))) HWMEN,
746: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
747: ,P_REPORT_DATE)
748: ,NULL
749: ,(DECODE(PEO.PER_INFORMATION1
750: ,'1'

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

752: ,'M'
753: ,1
754: ,NULL)
755: ,NULL)))) WNHMEN,
756: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
757: ,P_REPORT_DATE)
758: ,NULL
759: ,(DECODE(PEO.PER_INFORMATION1
760: ,'1'

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

762: ,'F'
763: ,1
764: ,NULL)
765: ,NULL)))) WNHWMEN,
766: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
767: ,P_REPORT_DATE)
768: ,NULL
769: ,(DECODE(PEO.PER_INFORMATION1
770: ,NULL

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

772: ,'M'
773: ,1
774: ,NULL)
775: ,NULL)))) URMEN,
776: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID
777: ,P_REPORT_DATE)
778: ,NULL
779: ,(DECODE(PEO.PER_INFORMATION1
780: ,NULL