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_TYPE_USAGE_INFO dependencies on PER_PERSON_TYPES_TL

Line 96: FROM per_person_types_tl ttl

92: ,p_person_id IN NUMBER
93: )
94: IS
95: SELECT ttl.user_person_type
96: FROM per_person_types_tl ttl
97: ,per_person_types typ
98: ,per_person_type_usages_f ptu
99: WHERE ttl.language = userenv('LANG')
100: AND ttl.person_type_id = typ.person_type_id

Line 151: FROM per_person_types_tl ttl

147: ,p_person_id IN NUMBER
148: )
149: IS
150: SELECT ttl.user_person_type
151: FROM per_person_types_tl ttl
152: ,per_person_types typ
153: ,per_person_type_usages_f ptu
154: WHERE ttl.language = userenv('LANG')
155: AND ttl.person_type_id = typ.person_type_id

Line 251: FROM per_person_types_tl ttl

247: IS
248: CURSOR csr_person_types
249: IS
250: SELECT ttl.user_person_type
251: FROM per_person_types_tl ttl
252: ,per_person_types typ
253: ,per_person_type_usages_f ptu
254: WHERE ttl.language = userenv('LANG')
255: AND ttl.person_type_id = typ.person_type_id

Line 262: l_user_person_type per_person_types_tl.user_person_type%type;

258: AND p_effective_date BETWEEN ptu.effective_start_date
259: AND ptu.effective_end_date
260: AND ptu.person_id = p_person_id;
261:
262: l_user_person_type per_person_types_tl.user_person_type%type;
263: BEGIN
264: open csr_person_types;
265: fetch csr_person_types into l_user_person_type;
266: if csr_person_types%notfound then

Line 309: FROM per_person_types_tl ttl

305: IS
306: CURSOR csr_person_types
307: IS
308: SELECT ttl.user_person_type
309: FROM per_person_types_tl ttl
310: ,per_person_types typ
311: ,per_person_type_usages_f ptu
312: WHERE ttl.language = userenv('LANG')
313: AND ttl.person_type_id = typ.person_type_id

Line 320: l_user_person_type per_person_types_tl.user_person_type%type;

316: AND p_effective_date BETWEEN ptu.effective_start_date
317: AND ptu.effective_end_date
318: AND ptu.person_id = p_person_id;
319:
320: l_user_person_type per_person_types_tl.user_person_type%type;
321: BEGIN
322: open csr_person_types;
323: fetch csr_person_types into l_user_person_type;
324: if csr_person_types%notfound then