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 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 311: ,per_person_type_usages_f ptu

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

Line 375: per_person_type_usages_f ptu

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
379: nvl(ptu.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))

Line 424: FROM per_person_type_usages_f ptu

420: IS
421: SELECT GetSystemPersonType(ptu.person_type_id),
422: ptu.effective_start_date,
423: ptu.effective_end_date
424: FROM per_person_type_usages_f ptu
425: WHERE ptu.person_type_usage_id = p_person_type_usage_id
426: AND ptu.effective_start_date > p_effective_date
427: order by ptu.effective_start_date ;
428:

Line 462: FROM per_person_type_usages_f ptu

458: BEGIN
459:
460: SELECT GetSystemPersonType(ptu.person_type_id), ptu.person_id
461: INTO l_current_system_person_type, l_person_id
462: FROM per_person_type_usages_f ptu
463: WHERE ptu.person_type_usage_id = p_person_type_usage_id
464: AND p_effective_date between
465: ptu.effective_start_date and ptu.effective_end_date;
466:

Line 548: FROM per_person_type_usages_f ptu

544: IS
545: SELECT GetSystemPersonType(ptu.person_type_id),
546: ptu.effective_start_date,
547: ptu.effective_end_date
548: FROM per_person_type_usages_f ptu
549: WHERE ptu.person_id = p_person_id
550: AND ptu.effective_start_date > p_effective_date
551: order by ptu.effective_start_date ;
552:

Line 586: FROM per_person_type_usages_f ptu

582: BEGIN
583:
584: SELECT GetSystemPersonType(ptu.person_type_id), ptu.effective_end_date
585: INTO l_current_system_person_type, l_current_end_date
586: FROM per_person_type_usages_f ptu
587: WHERE ptu.person_type_usage_id = p_person_type_usage_id
588: AND ptu.person_id = p_person_id
589: AND p_effective_date between
590: ptu.effective_start_date and ptu.effective_end_date;

Line 676: ,per_person_type_usages_f ptu

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
680: AND ptu.effective_end_date

Line 792: ,per_person_type_usages_f ptu

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
796: and ptu.person_id = p_person_id

Line 801: ,per_person_type_usages_f ptu2

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
805: and ptu2.person_id = p_person_id