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

Line 33: FROM per_person_types dft

29: (p_person_type_id IN NUMBER
30: )
31: IS
32: SELECT dft.person_type_id
33: FROM per_person_types dft
34: ,per_person_types typ
35: WHERE dft.active_flag = 'Y'
36: AND dft.default_flag = 'Y'
37: AND dft.business_group_id = typ.business_group_id

Line 34: ,per_person_types typ

30: )
31: IS
32: SELECT dft.person_type_id
33: FROM per_person_types dft
34: ,per_person_types typ
35: WHERE dft.active_flag = 'Y'
36: AND dft.default_flag = 'Y'
37: AND dft.business_group_id = typ.business_group_id
38: AND dft.system_person_type = typ.system_person_type

Line 65: FROM per_person_types dft

61: ,p_system_person_type IN VARCHAR2
62: )
63: IS
64: SELECT dft.person_type_id
65: FROM per_person_types dft
66: WHERE dft.active_flag = 'Y'
67: AND dft.default_flag = 'Y'
68: AND dft.business_group_id = p_business_group_id
69: AND dft.system_person_type = p_system_person_type;

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 97: ,per_person_types typ

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
101: AND typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')

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 152: ,per_person_types typ

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
156: AND typ.system_person_type IN ('EMP','CWK')

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 252: ,per_person_types typ

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
256: AND typ.system_person_type IN ('APL','EX_APL')

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 284: per_person_type_usages_f ptu, per_person_types ppt WHERE

280: RETURN VARCHAR2
281: IS
282: CURSOR emp_person_type IS
283: SELECT ptu.person_type_id FROM
284: per_person_type_usages_f ptu, per_person_types ppt WHERE
285: ptu.person_id = p_person_id and
286: p_effective_date between ptu.effective_start_date and ptu.effective_end_date
287: and ptu.person_type_id = ppt.person_type_id and ppt.system_person_type='EMP';
288: l_emp_person_type_id number;

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 310: ,per_person_types typ

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
314: AND typ.system_person_type IN ('EMP','EX_EMP')

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

Line 344: FROM per_person_types ppt

340: CURSOR c_system_person_type
341: (p_person_type_id IN NUMBER)
342: IS
343: SELECT ppt.system_person_type
344: FROM per_person_types ppt
345: WHERE ppt.person_type_id = p_person_type_id;
346:
347: l_system_person_type per_person_types.system_person_type%type;
348:

Line 347: l_system_person_type per_person_types.system_person_type%type;

343: SELECT ppt.system_person_type
344: FROM per_person_types ppt
345: WHERE ppt.person_type_id = p_person_type_id;
346:
347: l_system_person_type per_person_types.system_person_type%type;
348:
349: BEGIN
350:
351: OPEN c_system_person_type(p_person_type_id);

Line 374: FROM per_person_types ppt ,

370: (p_person_type_usage_id IN NUMBER,
371: p_effective_date IN DATE)
372: IS
373: SELECT ppt.system_person_type
374: FROM per_person_types ppt ,
375: per_person_type_usages_f ptu
376: WHERE ptu.person_type_usage_id = p_person_type_usage_id
377: AND p_effective_date between
378: ptu.effective_start_date and

Line 382: l_system_person_type per_person_types.system_person_type%type;

378: ptu.effective_start_date and
379: nvl(ptu.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))
380: AND ptu.person_type_id = ppt.person_type_id;
381:
382: l_system_person_type per_person_types.system_person_type%type;
383:
384: BEGIN
385:
386: OPEN c_corehr_person_type(p_person_type_usage_id,p_effective_date);

Line 455: l_current_system_person_type per_person_types.system_person_type%type;

451:
452: l_person_type_id NUMBER(10);
453: l_effective_start_date DATE;
454: l_effective_end_date DATE;
455: l_current_system_person_type per_person_types.system_person_type%type;
456: l_future_system_person_type per_person_types.system_person_type%type;
457:
458: BEGIN
459:

Line 456: l_future_system_person_type per_person_types.system_person_type%type;

452: l_person_type_id NUMBER(10);
453: l_effective_start_date DATE;
454: l_effective_end_date DATE;
455: l_current_system_person_type per_person_types.system_person_type%type;
456: l_future_system_person_type per_person_types.system_person_type%type;
457:
458: BEGIN
459:
460: SELECT GetSystemPersonType(ptu.person_type_id), ptu.person_id

Line 575: l_current_system_person_type per_person_types.system_person_type%type;

571:
572: l_person_type_id NUMBER(10);
573: l_effective_start_date DATE;
574: l_effective_end_date DATE;
575: l_current_system_person_type per_person_types.system_person_type%type;
576: l_future_system_person_type per_person_types.system_person_type%type;
577: l_current_end_date DATE;
578: l_is_back2back_hire number;
579: l_future_person BOOLEAN;

Line 576: l_future_system_person_type per_person_types.system_person_type%type;

572: l_person_type_id NUMBER(10);
573: l_effective_start_date DATE;
574: l_effective_end_date DATE;
575: l_current_system_person_type per_person_types.system_person_type%type;
576: l_future_system_person_type per_person_types.system_person_type%type;
577: l_current_end_date DATE;
578: l_is_back2back_hire number;
579: l_future_person BOOLEAN;
580:

Line 675: FROM per_person_types typ

671:
672: CURSOR csr_person_type
673: IS
674: SELECT null
675: FROM per_person_types typ
676: ,per_person_type_usages_f ptu
677: WHERE typ.system_person_type = p_system_person_type
678: AND typ.person_type_id = ptu.person_type_id
679: AND p_effective_date BETWEEN ptu.effective_start_date

Line 791: from per_person_types ppt

787: and ((p_person_id is null and pff.input is null)
788: or (p_person_id is not null
789: and exists
790: (select null
791: from per_person_types ppt
792: ,per_person_type_usages_f ptu
793: where ptu.person_type_id = ppt.person_Type_id
794: and p_effective_date between
795: ptu.effective_start_date and ptu.effective_end_date

Line 800: from per_person_types ppt2

796: and ptu.person_id = p_person_id
797: and ppt.system_person_type = pff.input)
798: and not exists
799: (select null
800: from per_person_types ppt2
801: ,per_person_type_usages_f ptu2
802: where ptu2.person_type_id = ppt2.person_type_id
803: and p_effective_date between
804: ptu2.effective_start_date and ptu2.effective_end_date