APPS.PA_BL_UTILS dependencies on PER_PEOPLE_F

Line 23: v_emp_name per_people_f.full_name%TYPE := NULL;

19: v_creation_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
20: v_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE)
21: RETURN VARCHAR2
22: IS
23: v_emp_name per_people_f.full_name%TYPE := NULL;
24: v_vendor_id po_vendors.vendor_id%TYPE;
25: v_vendor_name po_vendors.vendor_name%TYPE := NULL;
26: v_sup_err_msg VARCHAR2(20) := 'NO SUPPLIER FOUND';
27: v_emp_err_msg VARCHAR2(20) := 'NO EMPLOYEE FOUND';

Line 53: FROM per_people_f

49: ELSE
50: BEGIN
51: SELECT full_name
52: INTO v_emp_name
53: FROM per_people_f
54: WHERE v_person_id = person_id
55: AND v_creation_date BETWEEN effective_start_date
56: AND NVL(effective_end_date, v_creation_date)
57: AND ROWNUM < 2;