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_JOBS

Line 210: PER_JOBS JOB

206: PER_PEOPLE_EXTRA_INFO PPET,
207: HR_LOOKUPS HL,
208: PER_PAY_PROPOSALS PPP,
209: PER_PAY_BASES PPB,
210: PER_JOBS JOB
211: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
212: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
213: AND PAF.PERSON_ID = PPET.PERSON_ID
214: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 382: PER_JOBS JOB,

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

Line 628: PER_JOBS JOB

624: PER_PEOPLE_EXTRA_INFO PPET,
625: HR_LOOKUPS HL,
626: PER_PAY_PROPOSALS PPP,
627: PER_PAY_BASES PPB,
628: PER_JOBS JOB
629: WHERE PAF.PERSON_ID = PPET.PERSON_ID
630: AND PAF.PERSON_ID = PEO.PERSON_ID
631: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
632: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'

Line 800: PER_JOBS JOB,

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

Line 1049: PER_JOBS JOB

1045: PER_PEOPLE_EXTRA_INFO PPET,
1046: HR_LOOKUPS HL,
1047: PER_PAY_PROPOSALS PPP,
1048: PER_PAY_BASES PPB,
1049: PER_JOBS JOB
1050: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1051: AND PAF.PERSON_ID = PPET.PERSON_ID
1052: AND PAF.PERSON_ID = PEO.PERSON_ID
1053: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1221: PER_JOBS JOB,

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

Line 1467: PER_JOBS JOB

1463: PER_PEOPLE_EXTRA_INFO PPET,
1464: HR_LOOKUPS HL,
1465: PER_PAY_PROPOSALS PPP,
1466: PER_PAY_BASES PPB,
1467: PER_JOBS JOB
1468: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1469: AND PAF.PERSON_ID = PEO.PERSON_ID
1470: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1471: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'

Line 1639: PER_JOBS JOB,

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

Line 1887: PER_JOBS JOB

1883: PER_PEOPLE_EXTRA_INFO PPEA,
1884: HR_LOOKUPS HL,
1885: PER_PAY_PROPOSALS PPP,
1886: PER_PAY_BASES PPB,
1887: PER_JOBS JOB
1888: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1889: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1890: AND PAF.PERSON_ID = PPEA.PERSON_ID
1891: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'

Line 2062: PER_JOBS JOB,

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

Line 2311: PER_JOBS JOB

2307: PER_ASSIGNMENT_STATUS_TYPES AST,
2308: HR_LOOKUPS HL,
2309: PER_PAY_PROPOSALS PPP,
2310: PER_PAY_BASES PPB,
2311: PER_JOBS JOB
2312: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2313: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2314: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
2315: AND PAF.EFFECTIVE_END_DATE

Line 2486: PER_JOBS JOB,

2482: PER_ASSIGNMENT_STATUS_TYPES AST,
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'