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 216: HR_LOOKUPS HL

212: PER_ALL_ASSIGNMENTS_F PAF,
213: PER_ASSIGNMENT_STATUS_TYPES AST,
214: PER_PEOPLE_EXTRA_INFO PPET,
215: PER_JOBS JOB,
216: HR_LOOKUPS HL
217: WHERE PAF.PERSON_ID = PPET.PERSON_ID
218: AND PAF.PERSON_ID = PEO.PERSON_ID
219: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
220: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'

Line 360: HR_LOOKUPS HL,

356: PER_ALL_ASSIGNMENTS_F PAF,
357: PER_ASSIGNMENT_STATUS_TYPES AST,
358: PER_PEOPLE_EXTRA_INFO PPET,
359: PER_JOBS JOB,
360: HR_LOOKUPS HL,
361: PER_PEOPLE_EXTRA_INFO PEI
362: WHERE PAF.PERSON_ID = PPET.PERSON_ID
363: AND PAF.PERSON_ID = PEO.PERSON_ID
364: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 579: HR_LOOKUPS HL

575: PER_ALL_ASSIGNMENTS_F PAF,
576: PER_ASSIGNMENT_STATUS_TYPES AST,
577: PER_PEOPLE_EXTRA_INFO PPET,
578: PER_JOBS JOB,
579: HR_LOOKUPS HL
580: WHERE PAF.PERSON_ID = PPET.PERSON_ID
581: AND PAF.PERSON_ID = PEO.PERSON_ID
582: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
583: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'

Line 723: HR_LOOKUPS HL,

719: PER_ALL_ASSIGNMENTS_F PAF,
720: PER_ASSIGNMENT_STATUS_TYPES AST,
721: PER_PEOPLE_EXTRA_INFO PPET,
722: PER_JOBS JOB,
723: HR_LOOKUPS HL,
724: PER_PEOPLE_EXTRA_INFO PEI
725: WHERE PAF.PERSON_ID = PPET.PERSON_ID
726: AND PAF.PERSON_ID = PEO.PERSON_ID
727: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 941: HR_LOOKUPS HL

937: PER_ALL_PEOPLE_F PEO,
938: PER_ALL_ASSIGNMENTS_F PAF,
939: PER_ASSIGNMENT_STATUS_TYPES AST,
940: PER_JOBS JOB,
941: HR_LOOKUPS HL
942: WHERE PAF.PERSON_ID = PEO.PERSON_ID
943: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
944: AND not exists (
945: SELECT

Line 1088: HR_LOOKUPS HL,

1084: PER_ALL_PEOPLE_F PEO,
1085: PER_ALL_ASSIGNMENTS_F PAF,
1086: PER_ASSIGNMENT_STATUS_TYPES AST,
1087: PER_JOBS JOB,
1088: HR_LOOKUPS HL,
1089: PER_PEOPLE_EXTRA_INFO PEI
1090: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1091: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1092: AND PEO.PER_INFORMATION1 = '13'

Line 1318: HR_LOOKUPS HL

1314: PER_ALL_PEOPLE_F PEO,
1315: PER_ALL_ASSIGNMENTS_F PAF,
1316: PER_ASSIGNMENT_STATUS_TYPES AST,
1317: PER_JOBS JOB,
1318: HR_LOOKUPS HL
1319: WHERE PEO.PERSON_ID = PAF.PERSON_ID
1320: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1321: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
1322: AND HL.LOOKUP_TYPE = 'US_IPEDS_JOB_CATEGORIES'

Line 1456: HR_LOOKUPS HL,

1452: PER_ALL_PEOPLE_F PEO,
1453: PER_ALL_ASSIGNMENTS_F PAF,
1454: PER_ASSIGNMENT_STATUS_TYPES AST,
1455: PER_JOBS JOB,
1456: HR_LOOKUPS HL,
1457: PER_PEOPLE_EXTRA_INFO PEI
1458: WHERE PEO.PERSON_ID = PAF.PERSON_ID
1459: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1460: AND PEO.PER_INFORMATION1 = '13'