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 PER_PEOPLE_EXTRA_INFO

Line 205: PER_PEOPLE_EXTRA_INFO PPEA,

201: HR_LOOKUPS HLA,
202: PER_ALL_PEOPLE_F PEO,
203: PER_ALL_ASSIGNMENTS_F PAF,
204: PER_ASSIGNMENT_STATUS_TYPES AST,
205: PER_PEOPLE_EXTRA_INFO PPEA,
206: PER_PEOPLE_EXTRA_INFO PPET,
207: HR_LOOKUPS HL,
208: PER_PAY_PROPOSALS PPP,
209: PER_PAY_BASES PPB,

Line 206: PER_PEOPLE_EXTRA_INFO PPET,

202: PER_ALL_PEOPLE_F PEO,
203: PER_ALL_ASSIGNMENTS_F PAF,
204: PER_ASSIGNMENT_STATUS_TYPES AST,
205: PER_PEOPLE_EXTRA_INFO PPEA,
206: PER_PEOPLE_EXTRA_INFO PPET,
207: HR_LOOKUPS HL,
208: PER_PAY_PROPOSALS PPP,
209: PER_PAY_BASES PPB,
210: PER_JOBS JOB

Line 377: PER_PEOPLE_EXTRA_INFO PPEA,

373: HR_LOOKUPS HLA,
374: PER_ALL_PEOPLE_F PEO,
375: PER_ALL_ASSIGNMENTS_F PAF,
376: PER_ASSIGNMENT_STATUS_TYPES AST,
377: PER_PEOPLE_EXTRA_INFO PPEA,
378: PER_PEOPLE_EXTRA_INFO PPET,
379: HR_LOOKUPS HL,
380: PER_PAY_PROPOSALS PPP,
381: PER_PAY_BASES PPB,

Line 378: PER_PEOPLE_EXTRA_INFO PPET,

374: PER_ALL_PEOPLE_F PEO,
375: PER_ALL_ASSIGNMENTS_F PAF,
376: PER_ASSIGNMENT_STATUS_TYPES AST,
377: PER_PEOPLE_EXTRA_INFO PPEA,
378: PER_PEOPLE_EXTRA_INFO PPET,
379: HR_LOOKUPS HL,
380: PER_PAY_PROPOSALS PPP,
381: PER_PAY_BASES PPB,
382: PER_JOBS JOB,

Line 383: PER_PEOPLE_EXTRA_INFO PEI

379: HR_LOOKUPS HL,
380: PER_PAY_PROPOSALS PPP,
381: PER_PAY_BASES PPB,
382: PER_JOBS JOB,
383: PER_PEOPLE_EXTRA_INFO PEI
384: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
385: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
386: AND PEO.PER_INFORMATION1 = '13'
387: AND PEO.PERSON_ID = pei.person_id (+)

Line 394: PER_PEOPLE_EXTRA_INFO PEI2

390: AND not exists (
391: SELECT
392: 1
393: FROM
394: PER_PEOPLE_EXTRA_INFO PEI2
395: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
396: AND PEI2.PERSON_ID = PEI.PERSON_ID )
397: AND PEI.PERSON_EXTRA_INFO_ID = (
398: SELECT

Line 401: PER_PEOPLE_EXTRA_INFO PEI1

397: AND PEI.PERSON_EXTRA_INFO_ID = (
398: SELECT
399: MAX(PEI1.PERSON_EXTRA_INFO_ID)
400: FROM
401: PER_PEOPLE_EXTRA_INFO PEI1
402: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
403: OR ( not exists (
404: SELECT
405: PERSON_EXTRA_INFO_ID

Line 407: PER_PEOPLE_EXTRA_INFO PEI3

403: OR ( not exists (
404: SELECT
405: PERSON_EXTRA_INFO_ID
406: FROM
407: PER_PEOPLE_EXTRA_INFO PEI3
408: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
409: AND PAF.PERSON_ID = PPET.PERSON_ID
410: AND PAF.PERSON_ID = PEO.PERSON_ID
411: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'

Line 624: PER_PEOPLE_EXTRA_INFO PPET,

620: FROM
621: PER_ALL_PEOPLE_F PEO,
622: PER_ALL_ASSIGNMENTS_F PAF,
623: PER_ASSIGNMENT_STATUS_TYPES AST,
624: PER_PEOPLE_EXTRA_INFO PPET,
625: HR_LOOKUPS HL,
626: PER_PAY_PROPOSALS PPP,
627: PER_PAY_BASES PPB,
628: PER_JOBS JOB

Line 644: PER_PEOPLE_EXTRA_INFO PEA

640: AND not exists (
641: SELECT
642: PEA.PERSON_ID
643: FROM
644: PER_PEOPLE_EXTRA_INFO PEA
645: WHERE PEA.PERSON_ID = PEO.PERSON_ID
646: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
647: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
648: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 796: PER_PEOPLE_EXTRA_INFO PPET,

792: FROM
793: PER_ALL_PEOPLE_F PEO,
794: PER_ALL_ASSIGNMENTS_F PAF,
795: PER_ASSIGNMENT_STATUS_TYPES AST,
796: PER_PEOPLE_EXTRA_INFO PPET,
797: HR_LOOKUPS HL,
798: PER_PAY_PROPOSALS PPP,
799: PER_PAY_BASES PPB,
800: PER_JOBS JOB,

Line 801: PER_PEOPLE_EXTRA_INFO PEI

797: HR_LOOKUPS HL,
798: PER_PAY_PROPOSALS PPP,
799: PER_PAY_BASES PPB,
800: PER_JOBS JOB,
801: PER_PEOPLE_EXTRA_INFO PEI
802: WHERE PAF.PERSON_ID = PPET.PERSON_ID
803: AND PAF.PERSON_ID = PEO.PERSON_ID
804: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
805: AND PEO.PER_INFORMATION1 = '13'

Line 813: PER_PEOPLE_EXTRA_INFO PEI2

809: AND not exists (
810: SELECT
811: 1
812: FROM
813: PER_PEOPLE_EXTRA_INFO PEI2
814: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
815: AND PEI2.PERSON_ID = PEI.PERSON_ID )
816: AND PEI.PERSON_EXTRA_INFO_ID = (
817: SELECT

Line 820: PER_PEOPLE_EXTRA_INFO PEI1

816: AND PEI.PERSON_EXTRA_INFO_ID = (
817: SELECT
818: MAX(PEI1.PERSON_EXTRA_INFO_ID)
819: FROM
820: PER_PEOPLE_EXTRA_INFO PEI1
821: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
822: OR ( not exists (
823: SELECT
824: PERSON_EXTRA_INFO_ID

Line 826: PER_PEOPLE_EXTRA_INFO PEI3

822: OR ( not exists (
823: SELECT
824: PERSON_EXTRA_INFO_ID
825: FROM
826: PER_PEOPLE_EXTRA_INFO PEI3
827: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
828: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
829: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
830: AND PAF.EFFECTIVE_END_DATE

Line 840: PER_PEOPLE_EXTRA_INFO PEA

836: AND not exists (
837: SELECT
838: PEA.PERSON_ID
839: FROM
840: PER_PEOPLE_EXTRA_INFO PEA
841: WHERE PEA.PERSON_ID = PEO.PERSON_ID
842: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
843: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
844: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 1044: PER_PEOPLE_EXTRA_INFO PPEA,

1040: HR_LOOKUPS HLA,
1041: PER_ALL_PEOPLE_F PEO,
1042: PER_ALL_ASSIGNMENTS_F PAF,
1043: PER_ASSIGNMENT_STATUS_TYPES AST,
1044: PER_PEOPLE_EXTRA_INFO PPEA,
1045: PER_PEOPLE_EXTRA_INFO PPET,
1046: HR_LOOKUPS HL,
1047: PER_PAY_PROPOSALS PPP,
1048: PER_PAY_BASES PPB,

Line 1045: PER_PEOPLE_EXTRA_INFO PPET,

1041: PER_ALL_PEOPLE_F PEO,
1042: PER_ALL_ASSIGNMENTS_F PAF,
1043: PER_ASSIGNMENT_STATUS_TYPES AST,
1044: PER_PEOPLE_EXTRA_INFO PPEA,
1045: PER_PEOPLE_EXTRA_INFO PPET,
1046: HR_LOOKUPS HL,
1047: PER_PAY_PROPOSALS PPP,
1048: PER_PAY_BASES PPB,
1049: PER_JOBS JOB

Line 1216: PER_PEOPLE_EXTRA_INFO PPEA,

1212: HR_LOOKUPS HLA,
1213: PER_ALL_PEOPLE_F PEO,
1214: PER_ALL_ASSIGNMENTS_F PAF,
1215: PER_ASSIGNMENT_STATUS_TYPES AST,
1216: PER_PEOPLE_EXTRA_INFO PPEA,
1217: PER_PEOPLE_EXTRA_INFO PPET,
1218: HR_LOOKUPS HL,
1219: PER_PAY_PROPOSALS PPP,
1220: PER_PAY_BASES PPB,

Line 1217: PER_PEOPLE_EXTRA_INFO PPET,

1213: PER_ALL_PEOPLE_F PEO,
1214: PER_ALL_ASSIGNMENTS_F PAF,
1215: PER_ASSIGNMENT_STATUS_TYPES AST,
1216: PER_PEOPLE_EXTRA_INFO PPEA,
1217: PER_PEOPLE_EXTRA_INFO PPET,
1218: HR_LOOKUPS HL,
1219: PER_PAY_PROPOSALS PPP,
1220: PER_PAY_BASES PPB,
1221: PER_JOBS JOB,

Line 1222: PER_PEOPLE_EXTRA_INFO PEI

1218: HR_LOOKUPS HL,
1219: PER_PAY_PROPOSALS PPP,
1220: PER_PAY_BASES PPB,
1221: PER_JOBS JOB,
1222: PER_PEOPLE_EXTRA_INFO PEI
1223: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1224: AND PAF.PERSON_ID = PPET.PERSON_ID
1225: AND PAF.PERSON_ID = PEO.PERSON_ID
1226: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1235: PER_PEOPLE_EXTRA_INFO PEI2

1231: AND not exists (
1232: SELECT
1233: 1
1234: FROM
1235: PER_PEOPLE_EXTRA_INFO PEI2
1236: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1237: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1238: AND PEI.PERSON_EXTRA_INFO_ID = (
1239: SELECT

Line 1242: PER_PEOPLE_EXTRA_INFO PEI1

1238: AND PEI.PERSON_EXTRA_INFO_ID = (
1239: SELECT
1240: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1241: FROM
1242: PER_PEOPLE_EXTRA_INFO PEI1
1243: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1244: OR ( not exists (
1245: SELECT
1246: PERSON_EXTRA_INFO_ID

Line 1248: PER_PEOPLE_EXTRA_INFO PEI3

1244: OR ( not exists (
1245: SELECT
1246: PERSON_EXTRA_INFO_ID
1247: FROM
1248: PER_PEOPLE_EXTRA_INFO PEI3
1249: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1250: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'
1251: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
1252: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE

Line 1463: PER_PEOPLE_EXTRA_INFO PPET,

1459: FROM
1460: PER_ALL_PEOPLE_F PEO,
1461: PER_ALL_ASSIGNMENTS_F PAF,
1462: PER_ASSIGNMENT_STATUS_TYPES AST,
1463: PER_PEOPLE_EXTRA_INFO PPET,
1464: HR_LOOKUPS HL,
1465: PER_PAY_PROPOSALS PPP,
1466: PER_PAY_BASES PPB,
1467: PER_JOBS JOB

Line 1483: PER_PEOPLE_EXTRA_INFO PEA

1479: AND not exists (
1480: SELECT
1481: PEA.PERSON_ID
1482: FROM
1483: PER_PEOPLE_EXTRA_INFO PEA
1484: WHERE PEA.PERSON_ID = PEO.PERSON_ID
1485: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
1486: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
1487: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 1635: PER_PEOPLE_EXTRA_INFO PPET,

1631: FROM
1632: PER_ALL_PEOPLE_F PEO,
1633: PER_ALL_ASSIGNMENTS_F PAF,
1634: PER_ASSIGNMENT_STATUS_TYPES AST,
1635: PER_PEOPLE_EXTRA_INFO PPET,
1636: HR_LOOKUPS HL,
1637: PER_PAY_PROPOSALS PPP,
1638: PER_PAY_BASES PPB,
1639: PER_JOBS JOB,

Line 1640: PER_PEOPLE_EXTRA_INFO PEI

1636: HR_LOOKUPS HL,
1637: PER_PAY_PROPOSALS PPP,
1638: PER_PAY_BASES PPB,
1639: PER_JOBS JOB,
1640: PER_PEOPLE_EXTRA_INFO PEI
1641: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1642: AND PAF.PERSON_ID = PEO.PERSON_ID
1643: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1644: AND PEO.PER_INFORMATION1 = '13'

Line 1652: PER_PEOPLE_EXTRA_INFO PEI2

1648: AND not exists (
1649: SELECT
1650: 1
1651: FROM
1652: PER_PEOPLE_EXTRA_INFO PEI2
1653: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1654: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1655: AND PEI.PERSON_EXTRA_INFO_ID = (
1656: SELECT

Line 1659: PER_PEOPLE_EXTRA_INFO PEI1

1655: AND PEI.PERSON_EXTRA_INFO_ID = (
1656: SELECT
1657: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1658: FROM
1659: PER_PEOPLE_EXTRA_INFO PEI1
1660: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1661: OR ( not exists (
1662: SELECT
1663: PERSON_EXTRA_INFO_ID

Line 1665: PER_PEOPLE_EXTRA_INFO PEI3

1661: OR ( not exists (
1662: SELECT
1663: PERSON_EXTRA_INFO_ID
1664: FROM
1665: PER_PEOPLE_EXTRA_INFO PEI3
1666: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1667: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
1668: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
1669: AND PAF.EFFECTIVE_END_DATE

Line 1679: PER_PEOPLE_EXTRA_INFO PEA

1675: AND not exists (
1676: SELECT
1677: PEA.PERSON_ID
1678: FROM
1679: PER_PEOPLE_EXTRA_INFO PEA
1680: WHERE PEA.PERSON_ID = PEO.PERSON_ID
1681: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
1682: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
1683: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 1883: PER_PEOPLE_EXTRA_INFO PPEA,

1879: HR_LOOKUPS HLA,
1880: PER_ALL_PEOPLE_F PEO,
1881: PER_ALL_ASSIGNMENTS_F PAF,
1882: PER_ASSIGNMENT_STATUS_TYPES AST,
1883: PER_PEOPLE_EXTRA_INFO PPEA,
1884: HR_LOOKUPS HL,
1885: PER_PAY_PROPOSALS PPP,
1886: PER_PAY_BASES PPB,
1887: PER_JOBS JOB

Line 1907: PER_PEOPLE_EXTRA_INFO PET

1903: AND not exists (
1904: SELECT
1905: PET.PERSON_ID
1906: FROM
1907: PER_PEOPLE_EXTRA_INFO PET
1908: WHERE PET.PERSON_ID = PEO.PERSON_ID
1909: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
1910: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1911: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 2058: PER_PEOPLE_EXTRA_INFO PPEA,

2054: HR_LOOKUPS HLA,
2055: PER_ALL_PEOPLE_F PEO,
2056: PER_ALL_ASSIGNMENTS_F PAF,
2057: PER_ASSIGNMENT_STATUS_TYPES AST,
2058: PER_PEOPLE_EXTRA_INFO PPEA,
2059: HR_LOOKUPS HL,
2060: PER_PAY_PROPOSALS PPP,
2061: PER_PAY_BASES PPB,
2062: PER_JOBS JOB,

Line 2063: PER_PEOPLE_EXTRA_INFO PEI

2059: HR_LOOKUPS HL,
2060: PER_PAY_PROPOSALS PPP,
2061: PER_PAY_BASES PPB,
2062: PER_JOBS JOB,
2063: PER_PEOPLE_EXTRA_INFO PEI
2064: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2065: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2066: AND PEO.PER_INFORMATION1 = '13'
2067: AND PEO.PERSON_ID = pei.person_id (+)

Line 2074: PER_PEOPLE_EXTRA_INFO PEI2

2070: AND not exists (
2071: SELECT
2072: 1
2073: FROM
2074: PER_PEOPLE_EXTRA_INFO PEI2
2075: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
2076: AND PEI2.PERSON_ID = PEI.PERSON_ID )
2077: AND PEI.PERSON_EXTRA_INFO_ID = (
2078: SELECT

Line 2081: PER_PEOPLE_EXTRA_INFO PEI1

2077: AND PEI.PERSON_EXTRA_INFO_ID = (
2078: SELECT
2079: MAX(PEI1.PERSON_EXTRA_INFO_ID)
2080: FROM
2081: PER_PEOPLE_EXTRA_INFO PEI1
2082: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
2083: OR ( not exists (
2084: SELECT
2085: PERSON_EXTRA_INFO_ID

Line 2087: PER_PEOPLE_EXTRA_INFO PEI3

2083: OR ( not exists (
2084: SELECT
2085: PERSON_EXTRA_INFO_ID
2086: FROM
2087: PER_PEOPLE_EXTRA_INFO PEI3
2088: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
2089: AND PAF.PERSON_ID = PPEA.PERSON_ID
2090: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'
2091: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE

Line 2106: PER_PEOPLE_EXTRA_INFO PET

2102: AND not exists (
2103: SELECT
2104: PET.PERSON_ID
2105: FROM
2106: PER_PEOPLE_EXTRA_INFO PET
2107: WHERE PET.PERSON_ID = PEO.PERSON_ID
2108: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
2109: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
2110: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 2322: PER_PEOPLE_EXTRA_INFO PET

2318: AND not exists (
2319: SELECT
2320: PET.PERSON_ID
2321: FROM
2322: PER_PEOPLE_EXTRA_INFO PET
2323: WHERE PET.PERSON_ID = PEO.PERSON_ID
2324: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
2325: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
2326: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 2331: PER_PEOPLE_EXTRA_INFO PEA

2327: AND not exists (
2328: SELECT
2329: PEA.PERSON_ID
2330: FROM
2331: PER_PEOPLE_EXTRA_INFO PEA
2332: WHERE PEA.PERSON_ID = PEO.PERSON_ID
2333: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
2334: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
2335: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 2487: PER_PEOPLE_EXTRA_INFO PEI

2483: HR_LOOKUPS HL,
2484: PER_PAY_PROPOSALS PPP,
2485: PER_PAY_BASES PPB,
2486: PER_JOBS JOB,
2487: PER_PEOPLE_EXTRA_INFO PEI
2488: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2489: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2490: AND PEO.PER_INFORMATION1 = '13'
2491: AND PEO.PERSON_ID = pei.person_id (+)

Line 2498: PER_PEOPLE_EXTRA_INFO PEI2

2494: AND not exists (
2495: SELECT
2496: 1
2497: FROM
2498: PER_PEOPLE_EXTRA_INFO PEI2
2499: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
2500: AND PEI2.PERSON_ID = PEI.PERSON_ID )
2501: AND PEI.PERSON_EXTRA_INFO_ID = (
2502: SELECT

Line 2505: PER_PEOPLE_EXTRA_INFO PEI1

2501: AND PEI.PERSON_EXTRA_INFO_ID = (
2502: SELECT
2503: MAX(PEI1.PERSON_EXTRA_INFO_ID)
2504: FROM
2505: PER_PEOPLE_EXTRA_INFO PEI1
2506: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
2507: OR ( not exists (
2508: SELECT
2509: PERSON_EXTRA_INFO_ID

Line 2511: PER_PEOPLE_EXTRA_INFO PEI3

2507: OR ( not exists (
2508: SELECT
2509: PERSON_EXTRA_INFO_ID
2510: FROM
2511: PER_PEOPLE_EXTRA_INFO PEI3
2512: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
2513: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
2514: AND PAF.EFFECTIVE_END_DATE
2515: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 2521: PER_PEOPLE_EXTRA_INFO PET

2517: AND not exists (
2518: SELECT
2519: PET.PERSON_ID
2520: FROM
2521: PER_PEOPLE_EXTRA_INFO PET
2522: WHERE PET.PERSON_ID = PEO.PERSON_ID
2523: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
2524: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
2525: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 2530: PER_PEOPLE_EXTRA_INFO PEA

2526: AND not exists (
2527: SELECT
2528: PEA.PERSON_ID
2529: FROM
2530: PER_PEOPLE_EXTRA_INFO PEA
2531: WHERE PEA.PERSON_ID = PEO.PERSON_ID
2532: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
2533: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
2534: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)