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 PER_PEOPLE_EXTRA_INFO

Line 214: PER_PEOPLE_EXTRA_INFO PPET,

210: FROM
211: PER_ALL_PEOPLE_F PEO,
212: PER_ALL_ASSIGNMENTS_F PAF,
213: PER_ASSIGNMENT_STATUS_TYPES AST,
214: PER_PEOPLE_EXTRA_INFO PPET,
215: PER_JOBS JOB,
216: HR_LOOKUPS HL
217: WHERE PAF.PERSON_ID = PPET.PERSON_ID
218: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 358: PER_PEOPLE_EXTRA_INFO PPET,

354: FROM
355: PER_ALL_PEOPLE_F PEO,
356: PER_ALL_ASSIGNMENTS_F PAF,
357: PER_ASSIGNMENT_STATUS_TYPES AST,
358: PER_PEOPLE_EXTRA_INFO PPET,
359: PER_JOBS JOB,
360: HR_LOOKUPS HL,
361: PER_PEOPLE_EXTRA_INFO PEI
362: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 361: PER_PEOPLE_EXTRA_INFO PEI

357: PER_ASSIGNMENT_STATUS_TYPES AST,
358: PER_PEOPLE_EXTRA_INFO PPET,
359: PER_JOBS JOB,
360: HR_LOOKUPS HL,
361: PER_PEOPLE_EXTRA_INFO PEI
362: WHERE PAF.PERSON_ID = PPET.PERSON_ID
363: AND PAF.PERSON_ID = PEO.PERSON_ID
364: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
365: AND PEO.PER_INFORMATION1 = '13'

Line 373: PER_PEOPLE_EXTRA_INFO PEI2

369: AND not exists (
370: SELECT
371: 1
372: FROM
373: PER_PEOPLE_EXTRA_INFO PEI2
374: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
375: AND PEI2.PERSON_ID = PEI.PERSON_ID )
376: AND PEI.PERSON_EXTRA_INFO_ID = (
377: SELECT

Line 380: PER_PEOPLE_EXTRA_INFO PEI1

376: AND PEI.PERSON_EXTRA_INFO_ID = (
377: SELECT
378: MAX(PEI1.PERSON_EXTRA_INFO_ID)
379: FROM
380: PER_PEOPLE_EXTRA_INFO PEI1
381: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
382: OR ( not exists (
383: SELECT
384: PERSON_EXTRA_INFO_ID

Line 386: PER_PEOPLE_EXTRA_INFO PEI3

382: OR ( not exists (
383: SELECT
384: PERSON_EXTRA_INFO_ID
385: FROM
386: PER_PEOPLE_EXTRA_INFO PEI3
387: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
388: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
389: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
390: AND P_REPORT_DATE

Line 577: PER_PEOPLE_EXTRA_INFO PPET,

573: FROM
574: PER_ALL_PEOPLE_F PEO,
575: PER_ALL_ASSIGNMENTS_F PAF,
576: PER_ASSIGNMENT_STATUS_TYPES AST,
577: PER_PEOPLE_EXTRA_INFO PPET,
578: PER_JOBS JOB,
579: HR_LOOKUPS HL
580: WHERE PAF.PERSON_ID = PPET.PERSON_ID
581: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 721: PER_PEOPLE_EXTRA_INFO PPET,

717: FROM
718: PER_ALL_PEOPLE_F PEO,
719: PER_ALL_ASSIGNMENTS_F PAF,
720: PER_ASSIGNMENT_STATUS_TYPES AST,
721: PER_PEOPLE_EXTRA_INFO PPET,
722: PER_JOBS JOB,
723: HR_LOOKUPS HL,
724: PER_PEOPLE_EXTRA_INFO PEI
725: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 724: PER_PEOPLE_EXTRA_INFO PEI

720: PER_ASSIGNMENT_STATUS_TYPES AST,
721: PER_PEOPLE_EXTRA_INFO PPET,
722: PER_JOBS JOB,
723: HR_LOOKUPS HL,
724: PER_PEOPLE_EXTRA_INFO PEI
725: WHERE PAF.PERSON_ID = PPET.PERSON_ID
726: AND PAF.PERSON_ID = PEO.PERSON_ID
727: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
728: AND PEO.PER_INFORMATION1 = '13'

Line 736: PER_PEOPLE_EXTRA_INFO PEI2

732: AND not exists (
733: SELECT
734: 1
735: FROM
736: PER_PEOPLE_EXTRA_INFO PEI2
737: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
738: AND PEI2.PERSON_ID = PEI.PERSON_ID )
739: AND PEI.PERSON_EXTRA_INFO_ID = (
740: SELECT

Line 743: PER_PEOPLE_EXTRA_INFO PEI1

739: AND PEI.PERSON_EXTRA_INFO_ID = (
740: SELECT
741: MAX(PEI1.PERSON_EXTRA_INFO_ID)
742: FROM
743: PER_PEOPLE_EXTRA_INFO PEI1
744: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
745: OR ( not exists (
746: SELECT
747: PERSON_EXTRA_INFO_ID

Line 749: PER_PEOPLE_EXTRA_INFO PEI3

745: OR ( not exists (
746: SELECT
747: PERSON_EXTRA_INFO_ID
748: FROM
749: PER_PEOPLE_EXTRA_INFO PEI3
750: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
751: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
752: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
753: AND P_REPORT_DATE

Line 948: PER_PEOPLE_EXTRA_INFO PET

944: AND not exists (
945: SELECT
946: PET.PERSON_ID
947: FROM
948: PER_PEOPLE_EXTRA_INFO PET
949: WHERE PET.PERSON_ID = PEO.PERSON_ID
950: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
951: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
952: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 1089: PER_PEOPLE_EXTRA_INFO PEI

1085: PER_ALL_ASSIGNMENTS_F PAF,
1086: PER_ASSIGNMENT_STATUS_TYPES AST,
1087: PER_JOBS JOB,
1088: HR_LOOKUPS HL,
1089: PER_PEOPLE_EXTRA_INFO PEI
1090: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1091: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1092: AND PEO.PER_INFORMATION1 = '13'
1093: AND PEO.PERSON_ID = pei.person_id (+)

Line 1100: PER_PEOPLE_EXTRA_INFO PEI2

1096: AND not exists (
1097: SELECT
1098: 1
1099: FROM
1100: PER_PEOPLE_EXTRA_INFO PEI2
1101: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1102: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1103: AND PEI.PERSON_EXTRA_INFO_ID = (
1104: SELECT

Line 1107: PER_PEOPLE_EXTRA_INFO PEI1

1103: AND PEI.PERSON_EXTRA_INFO_ID = (
1104: SELECT
1105: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1106: FROM
1107: PER_PEOPLE_EXTRA_INFO PEI1
1108: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1109: OR ( not exists (
1110: SELECT
1111: PERSON_EXTRA_INFO_ID

Line 1113: PER_PEOPLE_EXTRA_INFO PEI3

1109: OR ( not exists (
1110: SELECT
1111: PERSON_EXTRA_INFO_ID
1112: FROM
1113: PER_PEOPLE_EXTRA_INFO PEI3
1114: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1115: AND not exists (
1116: SELECT
1117: PET.PERSON_ID

Line 1119: PER_PEOPLE_EXTRA_INFO PET

1115: AND not exists (
1116: SELECT
1117: PET.PERSON_ID
1118: FROM
1119: PER_PEOPLE_EXTRA_INFO PET
1120: WHERE PET.PERSON_ID = PEO.PERSON_ID
1121: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1122: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1123: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 1457: PER_PEOPLE_EXTRA_INFO PEI

1453: PER_ALL_ASSIGNMENTS_F PAF,
1454: PER_ASSIGNMENT_STATUS_TYPES AST,
1455: PER_JOBS JOB,
1456: HR_LOOKUPS HL,
1457: PER_PEOPLE_EXTRA_INFO PEI
1458: WHERE PEO.PERSON_ID = PAF.PERSON_ID
1459: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1460: AND PEO.PER_INFORMATION1 = '13'
1461: AND PEO.PERSON_ID = pei.person_id (+)

Line 1468: PER_PEOPLE_EXTRA_INFO PEI2

1464: AND not exists (
1465: SELECT
1466: 1
1467: FROM
1468: PER_PEOPLE_EXTRA_INFO PEI2
1469: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1470: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1471: AND PEI.PERSON_EXTRA_INFO_ID = (
1472: SELECT

Line 1475: PER_PEOPLE_EXTRA_INFO PEI1

1471: AND PEI.PERSON_EXTRA_INFO_ID = (
1472: SELECT
1473: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1474: FROM
1475: PER_PEOPLE_EXTRA_INFO PEI1
1476: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1477: OR ( not exists (
1478: SELECT
1479: PERSON_EXTRA_INFO_ID

Line 1481: PER_PEOPLE_EXTRA_INFO PEI3

1477: OR ( not exists (
1478: SELECT
1479: PERSON_EXTRA_INFO_ID
1480: FROM
1481: PER_PEOPLE_EXTRA_INFO PEI3
1482: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1483: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
1484: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
1485: AND JOB.JOB_INFORMATION_CATEGORY = 'US'