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_JOBS

Line 408: PER_JOBS JOB,

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
412: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 553: PER_JOBS JOB,

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
557: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 961: PER_JOBS JOB,

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
965: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1106: PER_JOBS JOB,

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
1110: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1513: PER_JOBS JOB,

1509: FROM
1510: PER_ALL_PEOPLE_F PEO,
1511: PER_ALL_ASSIGNMENTS_F PAF,
1512: PER_ASSIGNMENT_STATUS_TYPES AST,
1513: PER_JOBS JOB,
1514: HR_LOOKUPS HL
1515: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1516: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1517: AND not exists (

Line 1661: PER_JOBS JOB,

1657: FROM
1658: PER_ALL_PEOPLE_F PEO,
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'

Line 2080: PER_JOBS JOB,

2076: FROM
2077: PER_ALL_PEOPLE_F PEO,
2078: PER_ALL_ASSIGNMENTS_F PAF,
2079: PER_ASSIGNMENT_STATUS_TYPES AST,
2080: PER_JOBS JOB,
2081: HR_LOOKUPS HL
2082: WHERE PEO.PERSON_ID = PAF.PERSON_ID
2083: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2084: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8

Line 2219: PER_JOBS JOB,

2215: FROM
2216: PER_ALL_PEOPLE_F PEO,
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'