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

280:
281: cursor csr_fetch_type is
282: select ppt.system_person_type
283: from per_person_types ppt
284: , per_person_type_usages_f ptu
285: , per_all_people_f per
286: where per.person_id = p_rec.appraisee_person_id
287: and p_rec.appraisal_date BETWEEN per.effective_start_date AND per.effective_end_date
288: AND ptu.person_id = per.person_id

Line 1561: ,per_person_type_usages_f ptu

1557: cursor csr_fetch_type is
1558: select pt.system_person_type
1559: from
1560: per_all_people_f per
1561: ,per_person_type_usages_f ptu
1562: ,per_person_types pt
1563: where per.person_id = p_person_id
1564: and p_date BETWEEN per.effective_start_date and per.effective_end_date
1565: AND per.person_id = ptu.person_id