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 637: ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN IS

633: -- ------------------------------------------------------------------------------
634: --
635: FUNCTION is_person_a_worker
636: (p_effective_date IN DATE
637: ,p_person_id IN per_all_people_f.person_id%TYPE) RETURN BOOLEAN IS
638: --
639: -- Declare Local Variables
640: --
641: l_worker BOOLEAN := FALSE;