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_TYPE_USAGES_F

Line 246: per_person_type_usages_f PERSON_TYPE

242: l_execution_stmt :=
243: 'select 1
244: from per_all_assignments_f ASSIGNMENT,
245: per_all_people_f PERSON,
246: per_person_type_usages_f PERSON_TYPE
247: where ASSIGNMENT.assignment_id = :asg_id
248: and to_date(:asg_eff_date,''dd-mon-yyyy'')
249: between ASSIGNMENT.effective_start_date
250: and ASSIGNMENT.effective_end_date

Line 4079: from per_person_type_usages_f ptuf,

4075: from per_contact_relationships pcr
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);

Line 4192: from per_person_type_usages_f ptuf,

4188: -- Get all candidates (registered through iRecruitment) and excluding
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.

Line 4964: per_person_type_usages_f PERSON_TYPE

4960: l_temp_clause := and_clause(l_temp_clause, and_clause(
4961: 'EXISTS (SELECT NULL
4962: FROM '||l_paaf_name||' ASSIGNMENT,
4963: per_all_people_f PERSON,
4964: per_person_type_usages_f PERSON_TYPE
4965: WHERE ASSIGNMENT.rowid = hr_asg.rowid
4966: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id
4967: AND ASSIGNMENT.ASSIGNMENT_TYPE IN (''A'',''C'',''E'')
4968: /* For the bug 6196437 */

Line 5300: per_person_type_usages_f PERSON_TYPE

5296: l_temp_clause := and_clause(l_temp_clause, and_clause(
5297: 'EXISTS (SELECT NULL
5298: FROM '||l_paaf_name||' ASSIGNMENT,
5299: per_all_people_f PERSON,
5300: per_person_type_usages_f PERSON_TYPE
5301: WHERE ASSIGNMENT.rowid = hr_asg.rowid
5302: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id /* For the bug 6196437 */
5303: AND PERSON.person_id = ASSIGNMENT.person_id
5304: AND :effective_date