APPS.PA_BL_UTILS dependencies on PO_VENDORS

Line 24: v_vendor_id po_vendors.vendor_id%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';
28: BEGIN

Line 25: v_vendor_name po_vendors.vendor_name%TYPE := NULL;

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';
28: BEGIN
29: IF v_sys_linkage_func = 'VI' THEN

Line 40: FROM po_vendors

36:
37: IF v_vendor_id IS NOT NULL THEN
38: SELECT vendor_name
39: INTO v_vendor_name
40: FROM po_vendors
41: WHERE vendor_id = v_vendor_id;
42: END IF;
43:
44: RETURN v_vendor_name;