APPS.PER_PL_UPDATE_PERSON dependencies on PER_ALL_PEOPLE_F

Line 31: per_business_group_id per_all_people_f.business_group_id%TYPE;

27: l_con varchar2(1);
28: l_app varchar2(1);
29: l_cwk varchar2(1);
30: l_proc varchar2(72);
31: per_business_group_id per_all_people_f.business_group_id%TYPE;
32: identifier_chk varchar2(1);
33: assg_payroll_id per_all_assignments_f.payroll_id%TYPE;
34:
35: cursor csr_per_value is

Line 38: from per_all_people_f papf

34:
35: cursor csr_per_value is
36: select papf.business_group_id, papf.nationality, papf.national_identifier, papf.per_information1,
37: papf.per_information2,papf.per_information3,papf.per_information8
38: from per_all_people_f papf
39: where papf.person_id = p_person_id and
40: p_effective_date between papf.effective_start_date and papf.effective_end_date;
41:
42: l_csr_per_value csr_per_value%rowtype;