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 407: PER_PEOPLE_EXTRA_INFO PPET,

403: FROM
404: PER_ALL_PEOPLE_F PEO,
405: PER_ALL_ASSIGNMENTS_F PAF,
406: PER_ASSIGNMENT_STATUS_TYPES AST,
407: PER_PEOPLE_EXTRA_INFO PPET,
408: PER_JOBS JOB,
409: HR_LOOKUPS HL
410: WHERE PAF.PERSON_ID = PPET.PERSON_ID
411: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 552: PER_PEOPLE_EXTRA_INFO PPET,

548: FROM
549: PER_ALL_PEOPLE_F PEO,
550: PER_ALL_ASSIGNMENTS_F PAF,
551: PER_ASSIGNMENT_STATUS_TYPES AST,
552: PER_PEOPLE_EXTRA_INFO PPET,
553: PER_JOBS JOB,
554: HR_LOOKUPS HL,
555: PER_PEOPLE_EXTRA_INFO PEI
556: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 555: PER_PEOPLE_EXTRA_INFO PEI

551: PER_ASSIGNMENT_STATUS_TYPES AST,
552: PER_PEOPLE_EXTRA_INFO PPET,
553: PER_JOBS JOB,
554: HR_LOOKUPS HL,
555: PER_PEOPLE_EXTRA_INFO PEI
556: WHERE PAF.PERSON_ID = PPET.PERSON_ID
557: AND PAF.PERSON_ID = PEO.PERSON_ID
558: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
559: AND PEO.PER_INFORMATION1 = '13'

Line 567: PER_PEOPLE_EXTRA_INFO PEI2

563: AND not exists (
564: SELECT
565: 1
566: FROM
567: PER_PEOPLE_EXTRA_INFO PEI2
568: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
569: AND PEI2.PERSON_ID = PEI.PERSON_ID )
570: AND PEI.PERSON_EXTRA_INFO_ID = (
571: SELECT

Line 574: PER_PEOPLE_EXTRA_INFO PEI1

570: AND PEI.PERSON_EXTRA_INFO_ID = (
571: SELECT
572: MAX(PEI1.PERSON_EXTRA_INFO_ID)
573: FROM
574: PER_PEOPLE_EXTRA_INFO PEI1
575: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
576: OR ( not exists (
577: SELECT
578: PERSON_EXTRA_INFO_ID

Line 580: PER_PEOPLE_EXTRA_INFO PEI3

576: OR ( not exists (
577: SELECT
578: PERSON_EXTRA_INFO_ID
579: FROM
580: PER_PEOPLE_EXTRA_INFO PEI3
581: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
582: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
583: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
584: AND P_REPORT_DATE

Line 960: PER_PEOPLE_EXTRA_INFO PPET,

956: FROM
957: PER_ALL_PEOPLE_F PEO,
958: PER_ALL_ASSIGNMENTS_F PAF,
959: PER_ASSIGNMENT_STATUS_TYPES AST,
960: PER_PEOPLE_EXTRA_INFO PPET,
961: PER_JOBS JOB,
962: HR_LOOKUPS HL
963: WHERE PAF.PERSON_ID = PPET.PERSON_ID
964: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1105: PER_PEOPLE_EXTRA_INFO PPET,

1101: FROM
1102: PER_ALL_PEOPLE_F PEO,
1103: PER_ALL_ASSIGNMENTS_F PAF,
1104: PER_ASSIGNMENT_STATUS_TYPES AST,
1105: PER_PEOPLE_EXTRA_INFO PPET,
1106: PER_JOBS JOB,
1107: HR_LOOKUPS HL,
1108: PER_PEOPLE_EXTRA_INFO PEI
1109: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 1108: PER_PEOPLE_EXTRA_INFO PEI

1104: PER_ASSIGNMENT_STATUS_TYPES AST,
1105: PER_PEOPLE_EXTRA_INFO PPET,
1106: PER_JOBS JOB,
1107: HR_LOOKUPS HL,
1108: PER_PEOPLE_EXTRA_INFO PEI
1109: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1110: AND PAF.PERSON_ID = PEO.PERSON_ID
1111: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1112: AND PEO.PER_INFORMATION1 = '13'

Line 1120: PER_PEOPLE_EXTRA_INFO PEI2

1116: AND not exists (
1117: SELECT
1118: 1
1119: FROM
1120: PER_PEOPLE_EXTRA_INFO PEI2
1121: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1122: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1123: AND PEI.PERSON_EXTRA_INFO_ID = (
1124: SELECT

Line 1127: PER_PEOPLE_EXTRA_INFO PEI1

1123: AND PEI.PERSON_EXTRA_INFO_ID = (
1124: SELECT
1125: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1126: FROM
1127: PER_PEOPLE_EXTRA_INFO PEI1
1128: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1129: OR ( not exists (
1130: SELECT
1131: PERSON_EXTRA_INFO_ID

Line 1133: PER_PEOPLE_EXTRA_INFO PEI3

1129: OR ( not exists (
1130: SELECT
1131: PERSON_EXTRA_INFO_ID
1132: FROM
1133: PER_PEOPLE_EXTRA_INFO PEI3
1134: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1135: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
1136: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1137: AND P_REPORT_DATE

Line 1521: PER_PEOPLE_EXTRA_INFO PET

1517: AND not exists (
1518: SELECT
1519: PET.PERSON_ID
1520: FROM
1521: PER_PEOPLE_EXTRA_INFO PET
1522: WHERE PET.PERSON_ID = PEO.PERSON_ID
1523: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1524: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1525: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 1663: PER_PEOPLE_EXTRA_INFO PEI

1659: PER_ALL_ASSIGNMENTS_F PAF,
1660: PER_ASSIGNMENT_STATUS_TYPES AST,
1661: PER_JOBS JOB,
1662: HR_LOOKUPS HL,
1663: PER_PEOPLE_EXTRA_INFO PEI
1664: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1665: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1666: AND PEO.PER_INFORMATION1 = '13'
1667: AND PEO.PERSON_ID = pei.person_id (+)

Line 1674: PER_PEOPLE_EXTRA_INFO PEI2

1670: AND not exists (
1671: SELECT
1672: 1
1673: FROM
1674: PER_PEOPLE_EXTRA_INFO PEI2
1675: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
1676: AND PEI2.PERSON_ID = PEI.PERSON_ID )
1677: AND PEI.PERSON_EXTRA_INFO_ID = (
1678: SELECT

Line 1681: PER_PEOPLE_EXTRA_INFO PEI1

1677: AND PEI.PERSON_EXTRA_INFO_ID = (
1678: SELECT
1679: MAX(PEI1.PERSON_EXTRA_INFO_ID)
1680: FROM
1681: PER_PEOPLE_EXTRA_INFO PEI1
1682: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
1683: OR ( not exists (
1684: SELECT
1685: PERSON_EXTRA_INFO_ID

Line 1687: PER_PEOPLE_EXTRA_INFO PEI3

1683: OR ( not exists (
1684: SELECT
1685: PERSON_EXTRA_INFO_ID
1686: FROM
1687: PER_PEOPLE_EXTRA_INFO PEI3
1688: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1689: AND not exists (
1690: SELECT
1691: PET.PERSON_ID

Line 1693: PER_PEOPLE_EXTRA_INFO PET

1689: AND not exists (
1690: SELECT
1691: PET.PERSON_ID
1692: FROM
1693: PER_PEOPLE_EXTRA_INFO PET
1694: WHERE PET.PERSON_ID = PEO.PERSON_ID
1695: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1696: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1697: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

Line 2221: PER_PEOPLE_EXTRA_INFO PEI

2217: PER_ALL_ASSIGNMENTS_F PAF,
2218: PER_ASSIGNMENT_STATUS_TYPES AST,
2219: PER_JOBS JOB,
2220: HR_LOOKUPS HL,
2221: PER_PEOPLE_EXTRA_INFO PEI
2222: WHERE PEO.PERSON_ID = PAF.PERSON_ID
2223: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2224: AND PEO.PER_INFORMATION1 = '13'
2225: AND PEO.PERSON_ID = pei.person_id (+)

Line 2232: PER_PEOPLE_EXTRA_INFO PEI2

2228: AND not exists (
2229: SELECT
2230: 1
2231: FROM
2232: PER_PEOPLE_EXTRA_INFO PEI2
2233: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
2234: AND PEI2.PERSON_ID = PEI.PERSON_ID )
2235: AND PEI.PERSON_EXTRA_INFO_ID = (
2236: SELECT

Line 2239: PER_PEOPLE_EXTRA_INFO PEI1

2235: AND PEI.PERSON_EXTRA_INFO_ID = (
2236: SELECT
2237: MAX(PEI1.PERSON_EXTRA_INFO_ID)
2238: FROM
2239: PER_PEOPLE_EXTRA_INFO PEI1
2240: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
2241: OR ( not exists (
2242: SELECT
2243: PERSON_EXTRA_INFO_ID

Line 2245: PER_PEOPLE_EXTRA_INFO PEI3

2241: OR ( not exists (
2242: SELECT
2243: PERSON_EXTRA_INFO_ID
2244: FROM
2245: PER_PEOPLE_EXTRA_INFO PEI3
2246: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
2247: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
2248: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'
2249: AND JOB.JOB_INFORMATION_CATEGORY = 'US'