DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on PO_VENDORS

Line 25896: FROM po_vendors

25892: l_proc_name VARCHAR2(35) := 'CREATE_LESSEE_AS_VENDOR';
25893: CURSOR vendor_csr (p_vendor_id NUMBER,
25894: p_vendor_name VARCHAR2) IS
25895: SELECT vendor_id
25896: FROM po_vendors
25897: WHERE ( (vendor_id = p_vendor_id
25898: AND
25899: p_vendor_id IS NOT NULL
25900: )

Line 25925: l_vendor_id po_vendors.vendor_id%TYPE;

25921: )
25922: and org_id = p_auth_org_id
25923: and vendor_id = p_vendor_id;
25924:
25925: l_vendor_id po_vendors.vendor_id%TYPE;
25926: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;
25927: l_ppydv_rec ppydv_rec_type;
25928: x_ppydv_rec ppydv_rec_type;
25929:

Line 26897: FROM po_vendors

26893: x_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
26894:
26895: CURSOR vendor_csr (p_name VARCHAR2) IS
26896: SELECT vendor_id
26897: FROM po_vendors
26898: WHERE vendor_name = p_name;
26899:
26900: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
26901: p_org NUMBER) IS