APPS.OKL_ASSET_SUBSIDY_PVT dependencies on PO_VENDORS

Line 239: from po_vendors pov

235:
236: --cursor to get vendor id if vendor name is given
237: cursor l_vendor_csr (p_vend_name in varchar2) is
238: select vendor_id
239: from po_vendors pov
240: where vendor_name = ltrim(rtrim(p_vend_name,' '),' ');
241:
242: l_vendor_id number;
243:

Line 483: from po_vendors pov

479:
480: --cursor to get vendor id if vendor name is given
481: cursor l_vendor_csr (p_vend_name in varchar2) is
482: select vendor_id
483: from po_vendors pov
484: where vendor_name = ltrim(rtrim(p_vend_name,' '),' ');
485:
486: l_vendor_id number;
487:

Line 3758: from po_vendors pov

3754: p_vendor_id IN NUMBER) IS
3755:
3756: cursor l_vendor_csr (p_vendor_id in number) is
3757: select 'Y'
3758: from po_vendors pov
3759: where pov.vendor_id = p_vendor_id;
3760:
3761: l_exists varchar2(1) default 'N';
3762: BEGIN

Line 4535: from po_vendors pov

4531:
4532: --cursor to get vendor name
4533: cursor l_vendor_csr(p_vendor_id in number) is
4534: select pov.vendor_name
4535: from po_vendors pov
4536: where vendor_id = p_vendor_id;
4537:
4538: l_vendor_name po_vendors.vendor_name%TYPE;
4539:

Line 4538: l_vendor_name po_vendors.vendor_name%TYPE;

4534: select pov.vendor_name
4535: from po_vendors pov
4536: where vendor_id = p_vendor_id;
4537:
4538: l_vendor_name po_vendors.vendor_name%TYPE;
4539:
4540: --Bug# 4558486
4541: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4542: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 4979: from po_vendors pov

4975:
4976: --cursor to get vendor name
4977: cursor l_vendor_csr(p_vendor_id in number) is
4978: select pov.vendor_name
4979: from po_vendors pov
4980: where vendor_id = p_vendor_id;
4981:
4982: l_vendor_name po_vendors.vendor_name%TYPE;
4983:

Line 4982: l_vendor_name po_vendors.vendor_name%TYPE;

4978: select pov.vendor_name
4979: from po_vendors pov
4980: where vendor_id = p_vendor_id;
4981:
4982: l_vendor_name po_vendors.vendor_name%TYPE;
4983:
4984: --cursor to fetch party refund details record
4985: cursor l_ppyd_csr (p_cpl_id in number) is
4986: select ppyd.id