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

Line 454: ,per_person_type_usages_f ptu

450: select asg.assignment_id
451: from per_all_assignments_f asg
452: ,per_person_types ppt
453: ,per_all_people_f perp
454: ,per_person_type_usages_f ptu
455: where asg.person_id = p_person_id
456: and asg.person_id = perp.person_id
457: and perp.person_id =ptu.person_id
458: and ptu.person_type_id=ppt.person_type_id

Line 507: ,per_person_type_usages_f ptu

503: x.sub_org_relative_level > 0
504: ) orgs
505: ,per_person_types ppt
506: ,per_all_people_f perp
507: ,per_person_type_usages_f ptu
508: where asg.person_id = p_person_id
509: and asg.person_id = perp.person_id
510: and perp.person_id =ptu.person_id
511: and ptu.person_type_id=ppt.person_type_id