APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PER_ALL_PEOPLE_F

Line 204: FROM per_all_people_f papf

200: SELECT papf.employee_number
201: ,papf.npw_number
202: ,papf.current_employee_flag
203: ,papf.current_npw_flag
204: FROM per_all_people_f papf
205: WHERE papf.person_id = p_person_id
206: AND p_effective_date BETWEEN
207: papf.effective_start_date AND papf.effective_end_date;
208:

Line 209: l_employee_number per_all_people_f.employee_number%TYPE;

205: WHERE papf.person_id = p_person_id
206: AND p_effective_date BETWEEN
207: papf.effective_start_date AND papf.effective_end_date;
208:
209: l_employee_number per_all_people_f.employee_number%TYPE;
210: l_npw_number per_all_people_f.npw_number%TYPE;
211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;
213: l_worker_number per_all_people_f.employee_number%TYPE;

Line 210: l_npw_number per_all_people_f.npw_number%TYPE;

206: AND p_effective_date BETWEEN
207: papf.effective_start_date AND papf.effective_end_date;
208:
209: l_employee_number per_all_people_f.employee_number%TYPE;
210: l_npw_number per_all_people_f.npw_number%TYPE;
211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;
213: l_worker_number per_all_people_f.employee_number%TYPE;
214:

Line 211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

207: papf.effective_start_date AND papf.effective_end_date;
208:
209: l_employee_number per_all_people_f.employee_number%TYPE;
210: l_npw_number per_all_people_f.npw_number%TYPE;
211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;
213: l_worker_number per_all_people_f.employee_number%TYPE;
214:
215: BEGIN

Line 212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;

208:
209: l_employee_number per_all_people_f.employee_number%TYPE;
210: l_npw_number per_all_people_f.npw_number%TYPE;
211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;
213: l_worker_number per_all_people_f.employee_number%TYPE;
214:
215: BEGIN
216:

Line 213: l_worker_number per_all_people_f.employee_number%TYPE;

209: l_employee_number per_all_people_f.employee_number%TYPE;
210: l_npw_number per_all_people_f.npw_number%TYPE;
211: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
212: l_current_npw_flag per_all_people_f.current_npw_flag%TYPE;
213: l_worker_number per_all_people_f.employee_number%TYPE;
214:
215: BEGIN
216:
217: OPEN csr_get_person_details;

Line 706: ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN IS

702: -- ------------------------------------------------------------------------------
703: --
704: FUNCTION is_person_a_worker
705: (p_effective_date IN DATE
706: ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN IS
707: --
708: -- Declare Local Variables
709: --
710: l_worker BOOLEAN := FALSE;