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 400: PER_PEOPLE_EXTRA_INFO PPEA,

396: HR_LOOKUPS HLA,
397: PER_ALL_PEOPLE_F PEO,
398: PER_ALL_ASSIGNMENTS_F PAF,
399: PER_ASSIGNMENT_STATUS_TYPES AST,
400: PER_PEOPLE_EXTRA_INFO PPEA,
401: PER_PEOPLE_EXTRA_INFO PPET,
402: HR_LOOKUPS HL,
403: PER_PAY_PROPOSALS PPP,
404: PER_PAY_BASES PPB,

Line 401: PER_PEOPLE_EXTRA_INFO PPET,

397: PER_ALL_PEOPLE_F PEO,
398: PER_ALL_ASSIGNMENTS_F PAF,
399: PER_ASSIGNMENT_STATUS_TYPES AST,
400: PER_PEOPLE_EXTRA_INFO PPEA,
401: PER_PEOPLE_EXTRA_INFO PPET,
402: HR_LOOKUPS HL,
403: PER_PAY_PROPOSALS PPP,
404: PER_PAY_BASES PPB,
405: PER_JOBS JOB

Line 573: PER_PEOPLE_EXTRA_INFO PPEA,

569: HR_LOOKUPS HLA,
570: PER_ALL_PEOPLE_F PEO,
571: PER_ALL_ASSIGNMENTS_F PAF,
572: PER_ASSIGNMENT_STATUS_TYPES AST,
573: PER_PEOPLE_EXTRA_INFO PPEA,
574: PER_PEOPLE_EXTRA_INFO PPET,
575: HR_LOOKUPS HL,
576: PER_PAY_PROPOSALS PPP,
577: PER_PAY_BASES PPB,

Line 574: PER_PEOPLE_EXTRA_INFO PPET,

570: PER_ALL_PEOPLE_F PEO,
571: PER_ALL_ASSIGNMENTS_F PAF,
572: PER_ASSIGNMENT_STATUS_TYPES AST,
573: PER_PEOPLE_EXTRA_INFO PPEA,
574: PER_PEOPLE_EXTRA_INFO PPET,
575: HR_LOOKUPS HL,
576: PER_PAY_PROPOSALS PPP,
577: PER_PAY_BASES PPB,
578: PER_JOBS JOB,

Line 579: PER_PEOPLE_EXTRA_INFO PEI

575: HR_LOOKUPS HL,
576: PER_PAY_PROPOSALS PPP,
577: PER_PAY_BASES PPB,
578: PER_JOBS JOB,
579: PER_PEOPLE_EXTRA_INFO PEI
580: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
581: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
582: AND PEO.PER_INFORMATION1 = '13'
583: AND PEO.PERSON_ID = pei.person_id (+)

Line 590: PER_PEOPLE_EXTRA_INFO PEI2

586: AND not exists (
587: SELECT
588: 1
589: FROM
590: PER_PEOPLE_EXTRA_INFO PEI2
591: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
592: AND PEI2.PERSON_ID = PEI.PERSON_ID )
593: AND PEI.PERSON_EXTRA_INFO_ID = (
594: SELECT

Line 597: PER_PEOPLE_EXTRA_INFO PEI1

593: AND PEI.PERSON_EXTRA_INFO_ID = (
594: SELECT
595: MAX(PEI1.PERSON_EXTRA_INFO_ID)
596: FROM
597: PER_PEOPLE_EXTRA_INFO PEI1
598: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
599: OR ( not exists (
600: SELECT
601: PERSON_EXTRA_INFO_ID

Line 603: PER_PEOPLE_EXTRA_INFO PEI3

599: OR ( not exists (
600: SELECT
601: PERSON_EXTRA_INFO_ID
602: FROM
603: PER_PEOPLE_EXTRA_INFO PEI3
604: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
605: AND PAF.PERSON_ID = PPET.PERSON_ID
606: AND PAF.PERSON_ID = PEO.PERSON_ID
607: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'

Line 1010: PER_PEOPLE_EXTRA_INFO PPET,

1006: FROM
1007: PER_ALL_PEOPLE_F PEO,
1008: PER_ALL_ASSIGNMENTS_F PAF,
1009: PER_ASSIGNMENT_STATUS_TYPES AST,
1010: PER_PEOPLE_EXTRA_INFO PPET,
1011: HR_LOOKUPS HL,
1012: PER_PAY_PROPOSALS PPP,
1013: PER_PAY_BASES PPB,
1014: PER_JOBS JOB

Line 1030: PER_PEOPLE_EXTRA_INFO PEA

1026: AND not exists (
1027: SELECT
1028: PEA.PERSON_ID
1029: FROM
1030: PER_PEOPLE_EXTRA_INFO PEA
1031: WHERE PEA.PERSON_ID = PEO.PERSON_ID
1032: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
1033: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
1034: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 1183: PER_PEOPLE_EXTRA_INFO PPET,

1179: FROM
1180: PER_ALL_PEOPLE_F PEO,
1181: PER_ALL_ASSIGNMENTS_F PAF,
1182: PER_ASSIGNMENT_STATUS_TYPES AST,
1183: PER_PEOPLE_EXTRA_INFO PPET,
1184: HR_LOOKUPS HL,
1185: PER_PAY_PROPOSALS PPP,
1186: PER_PAY_BASES PPB,
1187: PER_JOBS JOB,

Line 1188: PER_PEOPLE_EXTRA_INFO PEI

1184: HR_LOOKUPS HL,
1185: PER_PAY_PROPOSALS PPP,
1186: PER_PAY_BASES PPB,
1187: PER_JOBS JOB,
1188: PER_PEOPLE_EXTRA_INFO PEI
1189: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1190: AND PAF.PERSON_ID = PEO.PERSON_ID
1191: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1192: AND PEO.PER_INFORMATION1 = '13'

Line 1200: PER_PEOPLE_EXTRA_INFO PEI2

1196: AND not exists (
1197: SELECT
1198: 1
1199: FROM
1200: PER_PEOPLE_EXTRA_INFO PEI2
1201: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1202: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1203: AND PEI.PERSON_EXTRA_INFO_ID = (
1204: SELECT

Line 1207: PER_PEOPLE_EXTRA_INFO PEI1

1203: AND PEI.PERSON_EXTRA_INFO_ID = (
1204: SELECT
1205: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1206: FROM
1207: PER_PEOPLE_EXTRA_INFO PEI1
1208: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1209: OR ( not exists (
1210: SELECT
1211: PERSON_EXTRA_INFO_ID

Line 1213: PER_PEOPLE_EXTRA_INFO PEI3

1209: OR ( not exists (
1210: SELECT
1211: PERSON_EXTRA_INFO_ID
1212: FROM
1213: PER_PEOPLE_EXTRA_INFO PEI3
1214: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1215: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
1216: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
1217: AND PAF.EFFECTIVE_END_DATE

Line 1227: PER_PEOPLE_EXTRA_INFO PEA

1223: AND not exists (
1224: SELECT
1225: PEA.PERSON_ID
1226: FROM
1227: PER_PEOPLE_EXTRA_INFO PEA
1228: WHERE PEA.PERSON_ID = PEO.PERSON_ID
1229: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
1230: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
1231: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 1620: PER_PEOPLE_EXTRA_INFO PPEA,

1616: HR_LOOKUPS HLA,
1617: PER_ALL_PEOPLE_F PEO,
1618: PER_ALL_ASSIGNMENTS_F PAF,
1619: PER_ASSIGNMENT_STATUS_TYPES AST,
1620: PER_PEOPLE_EXTRA_INFO PPEA,
1621: PER_PEOPLE_EXTRA_INFO PPET,
1622: HR_LOOKUPS HL,
1623: PER_PAY_PROPOSALS PPP,
1624: PER_PAY_BASES PPB,

Line 1621: PER_PEOPLE_EXTRA_INFO PPET,

1617: PER_ALL_PEOPLE_F PEO,
1618: PER_ALL_ASSIGNMENTS_F PAF,
1619: PER_ASSIGNMENT_STATUS_TYPES AST,
1620: PER_PEOPLE_EXTRA_INFO PPEA,
1621: PER_PEOPLE_EXTRA_INFO PPET,
1622: HR_LOOKUPS HL,
1623: PER_PAY_PROPOSALS PPP,
1624: PER_PAY_BASES PPB,
1625: PER_JOBS JOB

Line 1793: PER_PEOPLE_EXTRA_INFO PPEA,

1789: HR_LOOKUPS HLA,
1790: PER_ALL_PEOPLE_F PEO,
1791: PER_ALL_ASSIGNMENTS_F PAF,
1792: PER_ASSIGNMENT_STATUS_TYPES AST,
1793: PER_PEOPLE_EXTRA_INFO PPEA,
1794: PER_PEOPLE_EXTRA_INFO PPET,
1795: HR_LOOKUPS HL,
1796: PER_PAY_PROPOSALS PPP,
1797: PER_PAY_BASES PPB,

Line 1794: PER_PEOPLE_EXTRA_INFO PPET,

1790: PER_ALL_PEOPLE_F PEO,
1791: PER_ALL_ASSIGNMENTS_F PAF,
1792: PER_ASSIGNMENT_STATUS_TYPES AST,
1793: PER_PEOPLE_EXTRA_INFO PPEA,
1794: PER_PEOPLE_EXTRA_INFO PPET,
1795: HR_LOOKUPS HL,
1796: PER_PAY_PROPOSALS PPP,
1797: PER_PAY_BASES PPB,
1798: PER_JOBS JOB,

Line 1799: PER_PEOPLE_EXTRA_INFO PEI

1795: HR_LOOKUPS HL,
1796: PER_PAY_PROPOSALS PPP,
1797: PER_PAY_BASES PPB,
1798: PER_JOBS JOB,
1799: PER_PEOPLE_EXTRA_INFO PEI
1800: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1801: AND PAF.PERSON_ID = PPET.PERSON_ID
1802: AND PAF.PERSON_ID = PEO.PERSON_ID
1803: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1812: PER_PEOPLE_EXTRA_INFO PEI2

1808: AND not exists (
1809: SELECT
1810: 1
1811: FROM
1812: PER_PEOPLE_EXTRA_INFO PEI2
1813: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1814: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1815: AND PEI.PERSON_EXTRA_INFO_ID = (
1816: SELECT

Line 1819: PER_PEOPLE_EXTRA_INFO PEI1

1815: AND PEI.PERSON_EXTRA_INFO_ID = (
1816: SELECT
1817: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1818: FROM
1819: PER_PEOPLE_EXTRA_INFO PEI1
1820: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1821: OR ( not exists (
1822: SELECT
1823: PERSON_EXTRA_INFO_ID

Line 1825: PER_PEOPLE_EXTRA_INFO PEI3

1821: OR ( not exists (
1822: SELECT
1823: PERSON_EXTRA_INFO_ID
1824: FROM
1825: PER_PEOPLE_EXTRA_INFO PEI3
1826: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1827: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'
1828: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
1829: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE

Line 2229: PER_PEOPLE_EXTRA_INFO PPET,

2225: FROM
2226: PER_ALL_PEOPLE_F PEO,
2227: PER_ALL_ASSIGNMENTS_F PAF,
2228: PER_ASSIGNMENT_STATUS_TYPES AST,
2229: PER_PEOPLE_EXTRA_INFO PPET,
2230: HR_LOOKUPS HL,
2231: PER_PAY_PROPOSALS PPP,
2232: PER_PAY_BASES PPB,
2233: PER_JOBS JOB

Line 2249: PER_PEOPLE_EXTRA_INFO PEA

2245: AND not exists (
2246: SELECT
2247: PEA.PERSON_ID
2248: FROM
2249: PER_PEOPLE_EXTRA_INFO PEA
2250: WHERE PEA.PERSON_ID = PEO.PERSON_ID
2251: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
2252: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
2253: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 2403: PER_PEOPLE_EXTRA_INFO PPET,

2399: FROM
2400: PER_ALL_PEOPLE_F PEO,
2401: PER_ALL_ASSIGNMENTS_F PAF,
2402: PER_ASSIGNMENT_STATUS_TYPES AST,
2403: PER_PEOPLE_EXTRA_INFO PPET,
2404: HR_LOOKUPS HL,
2405: PER_PAY_PROPOSALS PPP,
2406: PER_PAY_BASES PPB,
2407: PER_JOBS JOB,

Line 2408: PER_PEOPLE_EXTRA_INFO PEI

2404: HR_LOOKUPS HL,
2405: PER_PAY_PROPOSALS PPP,
2406: PER_PAY_BASES PPB,
2407: PER_JOBS JOB,
2408: PER_PEOPLE_EXTRA_INFO PEI
2409: WHERE PAF.PERSON_ID = PPET.PERSON_ID
2410: AND PAF.PERSON_ID = PEO.PERSON_ID
2411: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2412: AND PEO.PER_INFORMATION1 = '13'

Line 2420: PER_PEOPLE_EXTRA_INFO PEI2

2416: AND not exists (
2417: SELECT
2418: 1
2419: FROM
2420: PER_PEOPLE_EXTRA_INFO PEI2
2421: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
2422: AND PEI2.PERSON_ID = PEI.PERSON_ID )
2423: AND PEI.PERSON_EXTRA_INFO_ID = (
2424: SELECT

Line 2427: PER_PEOPLE_EXTRA_INFO PEI1

2423: AND PEI.PERSON_EXTRA_INFO_ID = (
2424: SELECT
2425: MAX(PEI1.PERSON_EXTRA_INFO_ID)
2426: FROM
2427: PER_PEOPLE_EXTRA_INFO PEI1
2428: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
2429: OR ( not exists (
2430: SELECT
2431: PERSON_EXTRA_INFO_ID

Line 2433: PER_PEOPLE_EXTRA_INFO PEI3

2429: OR ( not exists (
2430: SELECT
2431: PERSON_EXTRA_INFO_ID
2432: FROM
2433: PER_PEOPLE_EXTRA_INFO PEI3
2434: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
2435: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'
2436: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
2437: AND PAF.EFFECTIVE_END_DATE

Line 2447: PER_PEOPLE_EXTRA_INFO PEA

2443: AND not exists (
2444: SELECT
2445: PEA.PERSON_ID
2446: FROM
2447: PER_PEOPLE_EXTRA_INFO PEA
2448: WHERE PEA.PERSON_ID = PEO.PERSON_ID
2449: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
2450: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
2451: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 2840: PER_PEOPLE_EXTRA_INFO PPEA,

2836: HR_LOOKUPS HLA,
2837: PER_ALL_PEOPLE_F PEO,
2838: PER_ALL_ASSIGNMENTS_F PAF,
2839: PER_ASSIGNMENT_STATUS_TYPES AST,
2840: PER_PEOPLE_EXTRA_INFO PPEA,
2841: HR_LOOKUPS HL,
2842: PER_PAY_PROPOSALS PPP,
2843: PER_PAY_BASES PPB,
2844: PER_JOBS JOB

Line 2864: PER_PEOPLE_EXTRA_INFO PET

2860: AND not exists (
2861: SELECT
2862: PET.PERSON_ID
2863: FROM
2864: PER_PEOPLE_EXTRA_INFO PET
2865: WHERE PET.PERSON_ID = PEO.PERSON_ID
2866: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
2867: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
2868: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 3017: PER_PEOPLE_EXTRA_INFO PPEA,

3013: HR_LOOKUPS HLA,
3014: PER_ALL_PEOPLE_F PEO,
3015: PER_ALL_ASSIGNMENTS_F PAF,
3016: PER_ASSIGNMENT_STATUS_TYPES AST,
3017: PER_PEOPLE_EXTRA_INFO PPEA,
3018: HR_LOOKUPS HL,
3019: PER_PAY_PROPOSALS PPP,
3020: PER_PAY_BASES PPB,
3021: PER_JOBS JOB,

Line 3022: PER_PEOPLE_EXTRA_INFO PEI

3018: HR_LOOKUPS HL,
3019: PER_PAY_PROPOSALS PPP,
3020: PER_PAY_BASES PPB,
3021: PER_JOBS JOB,
3022: PER_PEOPLE_EXTRA_INFO PEI
3023: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3024: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
3025: AND PEO.PER_INFORMATION1 = '13'
3026: AND PEO.PERSON_ID = pei.person_id (+)

Line 3033: PER_PEOPLE_EXTRA_INFO PEI2

3029: AND not exists (
3030: SELECT
3031: 1
3032: FROM
3033: PER_PEOPLE_EXTRA_INFO PEI2
3034: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
3035: AND PEI2.PERSON_ID = PEI.PERSON_ID )
3036: AND PEI.PERSON_EXTRA_INFO_ID = (
3037: SELECT

Line 3040: PER_PEOPLE_EXTRA_INFO PEI1

3036: AND PEI.PERSON_EXTRA_INFO_ID = (
3037: SELECT
3038: MAX(PEI1.PERSON_EXTRA_INFO_ID)
3039: FROM
3040: PER_PEOPLE_EXTRA_INFO PEI1
3041: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
3042: OR ( not exists (
3043: SELECT
3044: PERSON_EXTRA_INFO_ID

Line 3046: PER_PEOPLE_EXTRA_INFO PEI3

3042: OR ( not exists (
3043: SELECT
3044: PERSON_EXTRA_INFO_ID
3045: FROM
3046: PER_PEOPLE_EXTRA_INFO PEI3
3047: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
3048: AND PAF.PERSON_ID = PPEA.PERSON_ID
3049: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'
3050: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE

Line 3065: PER_PEOPLE_EXTRA_INFO PET

3061: AND not exists (
3062: SELECT
3063: PET.PERSON_ID
3064: FROM
3065: PER_PEOPLE_EXTRA_INFO PET
3066: WHERE PET.PERSON_ID = PEO.PERSON_ID
3067: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
3068: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
3069: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 3470: PER_PEOPLE_EXTRA_INFO PET

3466: AND not exists (
3467: SELECT
3468: PET.PERSON_ID
3469: FROM
3470: PER_PEOPLE_EXTRA_INFO PET
3471: WHERE PET.PERSON_ID = PEO.PERSON_ID
3472: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
3473: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
3474: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 3479: PER_PEOPLE_EXTRA_INFO PEA

3475: AND not exists (
3476: SELECT
3477: PEA.PERSON_ID
3478: FROM
3479: PER_PEOPLE_EXTRA_INFO PEA
3480: WHERE PEA.PERSON_ID = PEO.PERSON_ID
3481: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
3482: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
3483: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)

Line 3636: PER_PEOPLE_EXTRA_INFO PEI

3632: HR_LOOKUPS HL,
3633: PER_PAY_PROPOSALS PPP,
3634: PER_PAY_BASES PPB,
3635: PER_JOBS JOB,
3636: PER_PEOPLE_EXTRA_INFO PEI
3637: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3638: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
3639: AND PEO.PER_INFORMATION1 = '13'
3640: AND PEO.PERSON_ID = pei.person_id (+)

Line 3647: PER_PEOPLE_EXTRA_INFO PEI2

3643: AND not exists (
3644: SELECT
3645: 1
3646: FROM
3647: PER_PEOPLE_EXTRA_INFO PEI2
3648: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
3649: AND PEI2.PERSON_ID = PEI.PERSON_ID )
3650: AND PEI.PERSON_EXTRA_INFO_ID = (
3651: SELECT

Line 3654: PER_PEOPLE_EXTRA_INFO PEI1

3650: AND PEI.PERSON_EXTRA_INFO_ID = (
3651: SELECT
3652: MAX(PEI1.PERSON_EXTRA_INFO_ID)
3653: FROM
3654: PER_PEOPLE_EXTRA_INFO PEI1
3655: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
3656: OR ( not exists (
3657: SELECT
3658: PERSON_EXTRA_INFO_ID

Line 3660: PER_PEOPLE_EXTRA_INFO PEI3

3656: OR ( not exists (
3657: SELECT
3658: PERSON_EXTRA_INFO_ID
3659: FROM
3660: PER_PEOPLE_EXTRA_INFO PEI3
3661: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
3662: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
3663: AND PAF.EFFECTIVE_END_DATE
3664: AND P_REPORT_DATE BETWEEN PEO.EFFECTIVE_START_DATE

Line 3670: PER_PEOPLE_EXTRA_INFO PET

3666: AND not exists (
3667: SELECT
3668: PET.PERSON_ID
3669: FROM
3670: PER_PEOPLE_EXTRA_INFO PET
3671: WHERE PET.PERSON_ID = PEO.PERSON_ID
3672: AND PET.INFORMATION_TYPE in ( 'PQH_TENURE_STATUS' )
3673: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
3674: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 3679: PER_PEOPLE_EXTRA_INFO PEA

3675: AND not exists (
3676: SELECT
3677: PEA.PERSON_ID
3678: FROM
3679: PER_PEOPLE_EXTRA_INFO PEA
3680: WHERE PEA.PERSON_ID = PEO.PERSON_ID
3681: AND PEA.INFORMATION_TYPE in ( 'PQH_ACADEMIC_RANK' )
3682: AND PEA.PEI_INFORMATION1 in ( '02' , '03' , '04' , '05' , '06' )
3683: AND P_REPORT_DATE between FND_DATE.CANONICAL_TO_DATE(PEA.PEI_INFORMATION2)