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 HR_LOOKUPS

Line 409: HR_LOOKUPS HL

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'
413: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'

Line 554: HR_LOOKUPS HL,

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

Line 962: HR_LOOKUPS HL

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'
966: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'

Line 1107: HR_LOOKUPS HL,

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

Line 1514: HR_LOOKUPS HL

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 (
1518: SELECT

Line 1662: HR_LOOKUPS HL,

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'
1666: AND PEO.PER_INFORMATION1 = '13'

Line 2081: HR_LOOKUPS HL

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
2085: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'

Line 2220: HR_LOOKUPS HL,

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'
2224: AND PEO.PER_INFORMATION1 = '13'