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 451: PER_ASSIGNMENT_STATUS_TYPES ST ,

447: , GRADE_LADDER_PGM_ID
448: , '' GRADE_LADDER_PGM_NAME
449: , SUPERVISOR_ASSIGNMENT_ID
450: FROM PER_ASSIGNMENTS_F2 paaf,
451: PER_ASSIGNMENT_STATUS_TYPES ST ,
452: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
453: WHERE paaf.person_id = p_person_id
454: AND paaf.business_group_id = p_business_group_id
455: AND paaf.ASSIGNMENT_STATUS_TYPE_ID = ST.ASSIGNMENT_STATUS_TYPE_ID

Line 452: PER_ASSIGNMENT_STATUS_TYPES_TL STTL

448: , '' GRADE_LADDER_PGM_NAME
449: , SUPERVISOR_ASSIGNMENT_ID
450: FROM PER_ASSIGNMENTS_F2 paaf,
451: PER_ASSIGNMENT_STATUS_TYPES ST ,
452: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
453: WHERE paaf.person_id = p_person_id
454: AND paaf.business_group_id = p_business_group_id
455: AND paaf.ASSIGNMENT_STATUS_TYPE_ID = ST.ASSIGNMENT_STATUS_TYPE_ID
456: AND ST.ASSIGNMENT_STATUS_TYPE_ID = STTL.ASSIGNMENT_STATUS_TYPE_ID

Line 1454: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL

1450: papf.location_id,
1451: (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAPF.LOCATION_ID
1452: AND LANGUAGE = USERENV('LANG')) REPORTEE_LOCATION_DESC,
1453: papf.assignment_status_type_id,
1454: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1455: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id
1456: AND LANGUAGE = USERENV('LANG')) REPORTEE_ASG_STATUS_DESC
1457: FROM per_assignments_f papf , per_people_f ppf
1458: WHERE