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

Line 368: , per_person_type_usages_f ptu

364: -- Cursor to fetch system_person_type for appraisee_person_id
365: cursor csr_fetch_type is
366: select ppt.system_person_type
367: from per_person_types ppt
368: , per_person_type_usages_f ptu
369: , per_all_people_f per
370: where per.person_id = p_rec.appraisee_person_id
371: and TRUNC(SYSDATE) BETWEEN per.effective_start_date AND per.effective_end_date
372: AND ptu.person_id = per.person_id

Line 1695: ,per_person_type_usages_f ptu

1691: cursor csr_no_term is
1692: select pt.system_person_type
1693: from
1694: per_all_people_f per
1695: ,per_person_type_usages_f ptu
1696: ,per_person_types pt
1697: where per.person_id = p_person_id
1698: and p_date BETWEEN per.effective_start_date and per.effective_end_date
1699: AND per.person_id = ptu.person_id