APPS.HR_APPLICANT_DATAUPD dependencies on PER_ALL_PEOPLE_F

Line 24: -- + per_all_people_f

20: -- This procedure converts person into applicant whenever if finds active
21: -- applicant assignments opened and the application has a termination date.
22: --
23: -- The following tables are updated:
24: -- + per_all_people_f
25: -- + per_person_type_usages_f
26: -- + per_applications
27: --
28: -- Scenario:

Line 76: FROM per_all_people_f

72: ORDER BY date_end DESC;
73: --
74: CURSOR csr_lock_person(cp_person_id number, cp_termination_date date) IS
75: SELECT person_id, full_name, applicant_number,object_version_number
76: FROM per_all_people_f
77: WHERE person_id = cp_person_id
78: AND (effective_start_date > cp_termination_date
79: OR
80: cp_termination_date between effective_start_date

Line 127: l_failed_person_id per_all_people_f.person_id%TYPE;

123: l_count number;
124: l_appl_rec csr_get_application_details%ROWTYPE;
125: l_failed_apl per_applications.application_id%TYPE;
126: l_person_rec csr_lock_person%ROWTYPE;
127: l_failed_person_id per_all_people_f.person_id%TYPE;
128: l_failed_full_name per_all_people_f.full_name%TYPE;
129: l_rowcount number;
130: l_rowcount_ended number;
131: l_continue_process boolean;

Line 128: l_failed_full_name per_all_people_f.full_name%TYPE;

124: l_appl_rec csr_get_application_details%ROWTYPE;
125: l_failed_apl per_applications.application_id%TYPE;
126: l_person_rec csr_lock_person%ROWTYPE;
127: l_failed_person_id per_all_people_f.person_id%TYPE;
128: l_failed_full_name per_all_people_f.full_name%TYPE;
129: l_rowcount number;
130: l_rowcount_ended number;
131: l_continue_process boolean;
132: l_validation_start_date date;

Line 134: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

130: l_rowcount_ended number;
131: l_continue_process boolean;
132: l_validation_start_date date;
133: l_validation_end_date date;
134: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
135: l_proc constant varchar2(100) := 'ConvertToApplicant';
136: --
137: l_rows_processed number;
138: --