APPS.PY_ZA_ITREF_UPLOAD dependencies on PER_ALL_PEOPLE_F

Line 185: l_person_rec PER_ALL_PEOPLE_F%ROWTYPE;

181: l_defined BOOLEAN;
182: l_file_handle UTL_FILE.FILE_TYPE;
183: -- l_validate BOOLEAN:= true; /* Bug 12991144 - no longer required as API is not being used */
184: l_present_line VARCHAR2(2000);
185: l_person_rec PER_ALL_PEOPLE_F%ROWTYPE;
186: -- l_datetrack_update_mode VARCHAR2(2000); /* Bug 12991144- no longer required as API is not being used */
187: l_result VARCHAR2(2);
188: l_line_num NUMBER := 1;
189:

Line 207: FROM per_all_people_f papf

203:
204: cursor csr_find_by_emp_num(p_emp_num varchar2)
205: IS
206: SELECT *
207: FROM per_all_people_f papf
208: WHERE papf.business_group_id = p_business_group_id
209: AND papf.employee_number = p_emp_num
210: AND p_effective_date BETWEEN papf.effective_start_date
211: AND papf.effective_end_date

Line 314: UPDATE PER_ALL_PEOPLE_F

310: l_result := 'FC';
311: END IF;
312:
313: BEGIN
314: UPDATE PER_ALL_PEOPLE_F
315: SET PER_INFORMATION1 = csv_rec.tax_ref_num
316: WHERE EMPLOYEE_NUMBER = l_person_rec.employee_number
317: and BUSINESS_GROUP_ID = l_person_rec.business_group_id
318: and PER_INFORMATION_CATEGORY = 'ZA';