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.IRC_UTILITIES_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 332: ,per_person_type_usages_f ptu

328: IS
329: SELECT ttl.user_person_type
330: FROM per_person_types_tl ttl
331: ,per_person_types typ
332: ,per_person_type_usages_f ptu
333: ,PER_ALL_PEOPLE_F ppf
334: ,PER_ALL_PEOPLE_F ppf2
335: WHERE ppf.person_id = p_person_id
336: AND ppf.party_id = ppf2.party_id

Line 376: ,per_person_type_usages_f ptu

372: IS
373: SELECT ttl.user_person_type
374: FROM per_person_types_tl ttl
375: ,per_person_types typ
376: ,per_person_type_usages_f ptu
377: ,PER_ALL_PEOPLE_F ppf
378: WHERE ppf.party_id = p_party_id
379: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
380: AND ppf.person_id = ptu.person_id

Line 430: ,per_person_type_usages_f ptu

426: IS
427: SELECT ttl.user_person_type
428: FROM per_person_types_tl ttl
429: ,per_person_types typ
430: ,per_person_type_usages_f ptu
431: ,PER_ALL_PEOPLE_F ppf
432: ,PER_ALL_PEOPLE_F ppf2
433: WHERE ppf.person_id = p_person_id
434: AND ppf.party_id = ppf2.party_id

Line 484: ,per_person_type_usages_f ptu

480: IS
481: SELECT ttl.user_person_type
482: FROM per_person_types_tl ttl
483: ,per_person_types typ
484: ,per_person_type_usages_f ptu
485: ,PER_ALL_PEOPLE_F ppf
486: WHERE ppf.party_id = p_party_id
487: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
488: AND ppf.person_id = ptu.person_id

Line 526: ,per_person_type_usages_f ptu

522: CURSOR csr_emp_person_types
523: IS
524: SELECT typ.system_person_type
525: FROM per_person_types typ
526: ,per_person_type_usages_f ptu
527: ,PER_ALL_PEOPLE_F ppf
528: ,PER_ALL_PEOPLE_F ppf2
529: WHERE ppf.person_id = p_person_id
530: AND ppf.party_id = ppf2.party_id

Line 2217: ,per_person_type_usages_f ptu

2213: CURSOR csr_emp_person_types
2214: IS
2215: SELECT typ.system_person_type
2216: FROM per_person_types typ
2217: ,per_person_type_usages_f ptu
2218: ,PER_ALL_PEOPLE_F ppf
2219: WHERE ppf.party_id = p_party_id
2220: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2221: AND ppf.person_id = ptu.person_id

Line 2253: ,per_person_type_usages_f ptu

2249: SELECT typ.system_person_type,
2250: ppf.rehire_recommendation,
2251: hl.Meaning
2252: FROM per_person_types typ
2253: ,per_person_type_usages_f ptu
2254: ,per_all_people_f ppf
2255: ,hr_lookups hl
2256: WHERE ppf.party_id = p_party_id
2257: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date

Line 2319: ,per_person_type_usages_f ptu

2315: CURSOR csr_person_types IS
2316: SELECT typ.system_person_type,
2317: ppf.rehire_recommendation
2318: FROM per_person_types typ
2319: ,per_person_type_usages_f ptu
2320: ,per_all_people_f ppf
2321: WHERE ppf.party_id = p_party_id
2322: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2323: AND ppf.person_id = ptu.person_id