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_TYPE_USAGES_F

Line 98: ,per_person_type_usages_f ptu

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')
102: AND typ.person_type_id = ptu.person_type_id

Line 153: ,per_person_type_usages_f ptu

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')
157: AND typ.person_type_id = ptu.person_type_id

Line 253: ,per_person_type_usages_f ptu

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')
257: AND typ.person_type_id = ptu.person_type_id

Line 290: ,per_person_type_usages_f ptu

286: IS
287: SELECT ttl.user_person_type
288: FROM per_person_types_tl ttl
289: ,per_person_types typ
290: ,per_person_type_usages_f ptu
291: WHERE ttl.language = userenv('LANG')
292: AND ttl.person_type_id = typ.person_type_id
293: AND typ.system_person_type IN ('EMP','EX_EMP')
294: AND typ.person_type_id = ptu.person_type_id

Line 354: per_person_type_usages_f ptu

350: p_effective_date IN DATE)
351: IS
352: SELECT ppt.system_person_type
353: FROM per_person_types ppt ,
354: per_person_type_usages_f ptu
355: WHERE ptu.person_type_usage_id = p_person_type_usage_id
356: AND p_effective_date between
357: ptu.effective_start_date and
358: nvl(ptu.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))

Line 403: FROM per_person_type_usages_f ptu

399: IS
400: SELECT GetSystemPersonType(ptu.person_type_id),
401: ptu.effective_start_date,
402: ptu.effective_end_date
403: FROM per_person_type_usages_f ptu
404: WHERE ptu.person_type_usage_id = p_person_type_usage_id
405: AND ptu.effective_start_date > p_effective_date
406: order by ptu.effective_start_date ;
407:

Line 418: FROM per_person_type_usages_f ptu

414: BEGIN
415:
416: SELECT GetSystemPersonType(ptu.person_type_id)
417: INTO l_current_system_person_type
418: FROM per_person_type_usages_f ptu
419: WHERE ptu.person_type_usage_id = p_person_type_usage_id
420: AND p_effective_date between
421: ptu.effective_start_date and ptu.effective_end_date;
422:

Line 479: FROM per_person_type_usages_f ptu

475: IS
476: SELECT GetSystemPersonType(ptu.person_type_id),
477: ptu.effective_start_date,
478: ptu.effective_end_date
479: FROM per_person_type_usages_f ptu
480: WHERE ptu.person_id = p_person_id
481: AND ptu.effective_start_date > p_effective_date
482: order by ptu.effective_start_date ;
483:

Line 517: FROM per_person_type_usages_f ptu

513: BEGIN
514:
515: SELECT GetSystemPersonType(ptu.person_type_id), ptu.effective_end_date
516: INTO l_current_system_person_type, l_current_end_date
517: FROM per_person_type_usages_f ptu
518: WHERE ptu.person_type_usage_id = p_person_type_usage_id
519: AND ptu.person_id = p_person_id
520: AND p_effective_date between
521: ptu.effective_start_date and ptu.effective_end_date;

Line 607: ,per_person_type_usages_f ptu

603: CURSOR csr_person_type
604: IS
605: SELECT null
606: FROM per_person_types typ
607: ,per_person_type_usages_f ptu
608: WHERE typ.system_person_type = p_system_person_type
609: AND typ.person_type_id = ptu.person_type_id
610: AND p_effective_date BETWEEN ptu.effective_start_date
611: AND ptu.effective_end_date

Line 723: ,per_person_type_usages_f ptu

719: or (p_person_id is not null
720: and exists
721: (select null
722: from per_person_types ppt
723: ,per_person_type_usages_f ptu
724: where ptu.person_type_id = ppt.person_Type_id
725: and p_effective_date between
726: ptu.effective_start_date and ptu.effective_end_date
727: and ptu.person_id = p_person_id

Line 732: ,per_person_type_usages_f ptu2

728: and ppt.system_person_type = pff.input)
729: and not exists
730: (select null
731: from per_person_types ppt2
732: ,per_person_type_usages_f ptu2
733: where ptu2.person_type_id = ppt2.person_type_id
734: and p_effective_date between
735: ptu2.effective_start_date and ptu2.effective_end_date
736: and ptu2.person_id = p_person_id