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 2921: from per_all_people_f

2917: l_proc varchar2(72) := g_package||'grant_access_to_person';
2918: --
2919: cursor chk_person_id is
2920: select 1
2921: from per_all_people_f
2922: where person_id=p_person_id;
2923: --
2924: cursor chk_user_id is
2925: select 1

Line 4067: from per_all_people_f papf

4063: -- profile. The people cannot have any current or historical assignments.
4064: -- Here the numbers are checked instead of hitting per_all_assignments_f.
4065: cursor csr_unrelated_contacts is
4066: select distinct papf.person_id
4067: from per_all_people_f papf
4068: where (p_business_group_id is null or
4069: papf.business_group_id = p_business_group_id)
4070: and papf.employee_number is null
4071: and papf.npw_number is null

Line 4255: from per_all_people_f papf,

4251: -- Get all applicants who applied to the vacancies of the logged in RTM
4252: --
4253: cursor csr_rtm_candidates(p_person_id number) is
4254: select paaf.person_id,paaf.assignment_id
4255: from per_all_people_f papf,
4256: per_all_assignments_f paaf,
4257: irc_rec_team_members irt
4258: where papf.person_id = paaf.person_id
4259: and nvl(paaf.vacancy_id,(select distinct vacancy_id from PER_VAC_LINKED_ASSIGNMENTS

Line 4963: per_all_people_f PERSON,

4959: /* -- The l_temp_clause is changed for the enhancement */
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'')

Line 5299: per_all_people_f PERSON,

5295: ELSE
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