APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PO_VENDORS

Line 33: FROM PO_VENDORS pov

29: SELECT SYSDATE FROM SYS.DUAL;
30:
31: CURSOR c_vendor_info (c_vendor_id NUMBER) IS
32: SELECT pov.vendor_name Vendor_Name
33: FROM PO_VENDORS pov
34: WHERE pov.vendor_id = c_vendor_id;
35:
36: l_proj_info_rec c_proj_info%ROWTYPE;
37:

Line 48: l_vendor_name PO_VENDORS.vendor_name%TYPE;

44: l_err_code NUMBER := 0;
45: l_err_stack VARCHAR2(2000);
46: l_err_stage VARCHAR2(2000);
47: l_content_id NUMBER;
48: l_vendor_name PO_VENDORS.vendor_name%TYPE;
49:
50: itemtype CONSTANT VARCHAR2(15) := 'PADCTNWF';
51: l_process CONSTANT VARCHAR2(20) := 'DEDUCTION_REQ_NTFY';
52:

Line 301: FROM PO_VENDORS pov,

297:
298: CURSOR c_vendor_info (c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
299: SELECT pov.vendor_name Vendor_Name,
300: povs.vendor_site_code Vendor_Site
301: FROM PO_VENDORS pov,
302: PO_VENDOR_SITES_ALL povs
303: WHERE pov.vendor_id = povs.vendor_id
304: AND pov.vendor_id = c_vendor_id
305: AND povs.vendor_site_id = c_vendor_site_id;