APPS.PER_PL_UPDATE_PERSON dependencies on PER_ALL_ASSIGNMENTS_F

Line 33: assg_payroll_id per_all_assignments_f.payroll_id%TYPE;

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
36: select papf.business_group_id, papf.nationality, papf.national_identifier, papf.per_information1,
37: papf.per_information2,papf.per_information3,papf.per_information8

Line 52: select payroll_id from per_all_assignments_f paaf where paaf.person_id = p_person_id and

48: ppt.seeded_person_type_key = p_person_type_key and
49: p_effective_date between pptu.effective_start_date and pptu.effective_end_date;
50:
51: cursor csr_payroll_id is
52: select payroll_id from per_all_assignments_f paaf where paaf.person_id = p_person_id and
53: p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
54:
55:
56: BEGIN