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.HR_PERSON_RECORD dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 432: PER_ASSIGNMENT_STATUS_TYPES ST ,

428: , GRADE_LADDER_PGM_ID
429: , '' GRADE_LADDER_PGM_NAME
430: , SUPERVISOR_ASSIGNMENT_ID
431: FROM PER_ASSIGNMENTS_F2 paaf,
432: PER_ASSIGNMENT_STATUS_TYPES ST ,
433: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
434: WHERE paaf.person_id = p_person_id
435: AND paaf.business_group_id = p_business_group_id
436: AND paaf.ASSIGNMENT_STATUS_TYPE_ID = ST.ASSIGNMENT_STATUS_TYPE_ID

Line 433: PER_ASSIGNMENT_STATUS_TYPES_TL STTL

429: , '' GRADE_LADDER_PGM_NAME
430: , SUPERVISOR_ASSIGNMENT_ID
431: FROM PER_ASSIGNMENTS_F2 paaf,
432: PER_ASSIGNMENT_STATUS_TYPES ST ,
433: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
434: WHERE paaf.person_id = p_person_id
435: AND paaf.business_group_id = p_business_group_id
436: AND paaf.ASSIGNMENT_STATUS_TYPE_ID = ST.ASSIGNMENT_STATUS_TYPE_ID
437: AND ST.ASSIGNMENT_STATUS_TYPE_ID = STTL.ASSIGNMENT_STATUS_TYPE_ID

Line 1433: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL

1429: papf.location_id,
1430: (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAPF.LOCATION_ID
1431: AND LANGUAGE = USERENV('LANG')) REPORTEE_LOCATION_DESC,
1432: papf.assignment_status_type_id,
1433: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1434: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id
1435: AND LANGUAGE = USERENV('LANG')) REPORTEE_ASG_STATUS_DESC
1436: FROM per_assignments_f papf , per_people_f ppf
1437: WHERE