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_ALL_PEOPLE_F

Line 245: per_all_people_f PERSON,

241: --
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

Line 332: per_all_people_f ppf

328: paf.assignment_type,
329: ppf.current_employee_flag,
330: ppf.current_npw_flag
331: from per_all_assignments_f paf,
332: per_all_people_f ppf
333: where paf.assignment_id = p_assignment_id
334: and p_effective_date between paf.effective_start_date
335: and paf.effective_end_date
336: and paf.person_id = ppf.person_id

Line 346: l_current_employee_flag per_all_people_f.current_employee_flag%type;

342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;
347: l_current_npw_flag per_all_people_f.current_npw_flag%type;
348: --
349: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
350: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');

Line 347: l_current_npw_flag per_all_people_f.current_npw_flag%type;

343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;
347: l_current_npw_flag per_all_people_f.current_npw_flag%type;
348: --
349: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');
350: l_request_id number(15) := fnd_profile.value('CONC_REQUEST_ID');
351: l_prog_appl_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');

Line 2881: from per_all_people_f

2877: l_proc varchar2(72) := g_package||'grant_access_to_person';
2878: --
2879: cursor chk_person_id is
2880: select 1
2881: from per_all_people_f
2882: where person_id=p_person_id;
2883: --
2884: cursor chk_user_id is
2885: select 1

Line 4027: from per_all_people_f papf

4023: -- profile. The people cannot have any current or historical assignments.
4024: -- Here the numbers are checked instead of hitting per_all_assignments_f.
4025: cursor csr_unrelated_contacts is
4026: select distinct papf.person_id
4027: from per_all_people_f papf
4028: where (p_business_group_id is null or
4029: papf.business_group_id = p_business_group_id)
4030: and papf.employee_number is null
4031: and papf.npw_number is null

Line 4829: per_all_people_f PERSON,

4825: /* -- The l_temp_clause is changed for the enhancement */
4826: l_temp_clause := and_clause(l_temp_clause, and_clause(
4827: 'EXISTS (SELECT NULL
4828: FROM per_all_assignments_f ASSIGNMENT,
4829: per_all_people_f PERSON,
4830: per_person_type_usages_f PERSON_TYPE
4831: WHERE ASSIGNMENT.rowid = hr_asg.rowid
4832: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id
4833: AND ASSIGNMENT.ASSIGNMENT_TYPE IN (''A'',''C'',''E'')

Line 5150: per_all_people_f PERSON,

5146: ELSE
5147: l_temp_clause := and_clause(l_temp_clause, and_clause(
5148: 'EXISTS (SELECT NULL
5149: FROM per_all_assignments_f ASSIGNMENT,
5150: per_all_people_f PERSON,
5151: per_person_type_usages_f PERSON_TYPE
5152: WHERE ASSIGNMENT.rowid = hr_asg.rowid
5153: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id /* For the bug 6196437 */
5154: AND PERSON.person_id = ASSIGNMENT.person_id