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_SA_GET_PERSON_DETAILS dependencies on PER_SHARED_TYPES

Line 15: ,per_shared_types SHTYPE

11: select a.meaning
12: from per_all_people_f PEOPLE
13: ,hr_lookups a
14: ,per_all_assignments_f ASSIGN
15: ,per_shared_types SHTYPE
16: where l_effective_date between ASSIGN.effective_start_date
17: and ASSIGN.effective_end_date
18: and l_effective_date BETWEEN PEOPLE.effective_start_date
19: and PEOPLE.effective_end_date

Line 54: ,per_shared_types SHTYPE

50: l_Effective_Date Date) IS
51: select a.meaning
52: from per_all_people_f PEOPLE
53: ,hr_lookups a
54: ,per_shared_types SHTYPE
55: where PEOPLE.person_id = l_person_id
56: and l_effective_date BETWEEN PEOPLE.effective_start_date
57: AND PEOPLE.effective_end_date
58: and SHTYPE.LOOKUP_TYPE (+)= 'NATIONALITY'