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_SECURITY_INTERNAL dependencies on PER_PERSON_TYPES

Line 4080: per_person_types ppt

4076: where pcr.contact_person_id = papf.person_id)
4077: and not exists
4078: (select null
4079: from per_person_type_usages_f ptuf,
4080: per_person_types ppt
4081: where ppt.system_person_type = 'IRC_REG_USER'
4082: and ptuf.person_type_id = ppt.person_type_id
4083: and ptuf.person_id = papf.person_id);
4084: --

Line 4193: per_person_types ppt

4189: -- related contacts if any.
4190: cursor csr_candidates is
4191: select ptuf.person_id
4192: from per_person_type_usages_f ptuf,
4193: per_person_types ppt
4194: where ppt.system_person_type = 'IRC_REG_USER'
4195: and ptuf.person_type_id = ppt.person_type_id
4196: and ppt.business_group_id + 0 = nvl(p_business_group_id,ppt.business_group_id)--fix for bug 5222441.
4197: and not exists