APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ALL_PEOPLE_F

Line 57: from per_all_people_f papf, per_person_types ppt

53: order by effective_end_date desc, effective_start_date desc;
54:
55: Cursor csr_prev_ppl_person_types is
56: select ppt.system_person_type
57: from per_all_people_f papf, per_person_types ppt
58: where papf.person_type_id = ppt.person_type_id
59: and person_id = p_person_id
60: and ppt.business_group_id = p_business_group_id
61: and ppt.system_person_type in

Line 183: (p_person_id IN per_all_people_f.person_id%TYPE

179: | |
180: *============================================================================*/
181: --
182: PROCEDURE lock_cwk_rows
183: (p_person_id IN per_all_people_f.person_id%TYPE
184: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
185: ,p_effective_date IN DATE) IS
186: --
187: l_rowid VARCHAR2(18);

Line 184: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE

180: *============================================================================*/
181: --
182: PROCEDURE lock_cwk_rows
183: (p_person_id IN per_all_people_f.person_id%TYPE
184: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
185: ,p_effective_date IN DATE) IS
186: --
187: l_rowid VARCHAR2(18);
188: --

Line 2821: -- only in per_all_people_f the person tye has to be ex_emp_apl

2817: where business_group_id = p_business_group_id
2818: and system_person_type = 'EX_EMP_APL'
2819: and default_flag = 'Y';
2820: end if;
2821: -- only in per_all_people_f the person tye has to be ex_emp_apl
2822: -- code added for the bug 8504597 ends here
2823:
2824: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',322);
2825:

Line 3383: FROM per_all_people_f ppf

3379: -- Changes start for the bug 14156610
3380:
3381: CURSOR csr_pre_apl_num IS
3382: SELECT applicant_number
3383: FROM per_all_people_f ppf
3384: WHERE ppf.effective_start_date < p_date_received
3385: AND ppf.person_id = p_person_id
3386: AND ppf.business_group_id +0 = p_business_group_id
3387: ORDER BY ppf.effective_start_date DESC;

Line 4777: FROM per_all_people_f ppf

4773: -- Changes start for the bug 13772471
4774:
4775: CURSOR csr_pre_npw_num IS
4776: SELECT npw_number
4777: FROM per_all_people_f ppf
4778: --WHERE ppf.effective_start_date < p_effective_date -- Commented for Bug#14166808
4779: WHERE ppf.effective_start_date < p_date_start -- Added for Bug#14166808
4780: AND ppf.person_id = p_person_id
4781: AND ppf.business_group_id +0 = p_business_group_id