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.PER_PERUSEO1_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 317: PER_ALL_ASSIGNMENTS_F ASS,

313: SELECT
314: COUNT(PEO.PERSON_ID)
315: INTO L_COUNT_EMPS
316: FROM
317: PER_ALL_ASSIGNMENTS_F ASS,
318: PER_ALL_PEOPLE_F PEO,
319: PER_JOBS_VL JOB
320: WHERE PEO.PERSON_ID = ASS.PERSON_ID
321: AND PEO.PER_INFORMATION1 is not NULL

Line 341: PER_ALL_ASSIGNMENTS_F ASS1

337: AND ASS.EFFECTIVE_START_DATE = (
338: SELECT
339: MAX(ASS1.EFFECTIVE_START_DATE)
340: FROM
341: PER_ALL_ASSIGNMENTS_F ASS1
342: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
343: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
344: AND ASS.PERSON_ID = ASS1.PERSON_ID
345: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 492: PER_ALL_ASSIGNMENTS_F ASS,

488: ,NULL))
489: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
490: FROM
491: PER_ALL_PEOPLE_F PEO,
492: PER_ALL_ASSIGNMENTS_F ASS,
493: PER_JOBS_VL JOB
494: WHERE PEO.PERSON_ID = ASS.PERSON_ID
495: AND PEO.PER_INFORMATION1 is not NULL
496: AND JOB.JOB_INFORMATION_CATEGORY = 'US'

Line 518: PER_ALL_ASSIGNMENTS_F ASS1

514: AND ASS.EFFECTIVE_START_DATE = (
515: SELECT
516: MAX(ASS1.EFFECTIVE_START_DATE)
517: FROM
518: PER_ALL_ASSIGNMENTS_F ASS1
519: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
520: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
521: AND ASS.PERSON_ID = ASS1.PERSON_ID
522: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 607: PER_ALL_ASSIGNMENTS_F ASS,

603: SELECT
604: COUNT('ass')
605: INTO L_COUNT_EMPS
606: FROM
607: PER_ALL_ASSIGNMENTS_F ASS,
608: PER_ALL_PEOPLE_F PEO,
609: PER_JOBS_VL JOB
610: WHERE PEO.PERSON_ID = ASS.PERSON_ID
611: AND PEO.PER_INFORMATION1 is not NULL

Line 625: PER_ALL_ASSIGNMENTS_F ASS1

621: AND ASS.EFFECTIVE_START_DATE = (
622: SELECT
623: MAX(ASS1.EFFECTIVE_START_DATE)
624: FROM
625: PER_ALL_ASSIGNMENTS_F ASS1
626: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
627: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
628: AND ASS.PERSON_ID = ASS1.PERSON_ID
629: AND ASS1.ASSIGNMENT_TYPE = 'E'

Line 855: PER_ALL_ASSIGNMENTS_F ASS,

851: JOB.NAME JOB_NAME,
852: ASS.JOB_ID
853: FROM
854: PER_ALL_PEOPLE_F PEO,
855: PER_ALL_ASSIGNMENTS_F ASS,
856: PER_JOBS_VL JOB,
857: HR_LOCATIONS_ALL HL
858: WHERE PEO.PERSON_ID = ASS.PERSON_ID
859: AND PEO.PER_INFORMATION1 is not null