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 215: PER_JOBS JOB,

211: PER_ALL_PEOPLE_F PEO,
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'

Line 359: PER_JOBS JOB,

355: PER_ALL_PEOPLE_F PEO,
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

Line 578: PER_JOBS JOB,

574: PER_ALL_PEOPLE_F PEO,
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'

Line 722: PER_JOBS JOB,

718: PER_ALL_PEOPLE_F PEO,
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

Line 940: PER_JOBS JOB,

936: FROM
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 (

Line 1087: PER_JOBS JOB,

1083: FROM
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'

Line 1317: PER_JOBS JOB,

1313: FROM
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

Line 1455: PER_JOBS JOB,

1451: FROM
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'