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 3779: from po_vendors pov

3775: p_vendor_id IN NUMBER) IS
3776:
3777: cursor l_vendor_csr (p_vendor_id in number) is
3778: select 'Y'
3779: from po_vendors pov
3780: where pov.vendor_id = p_vendor_id;
3781:
3782: l_exists varchar2(1) default 'N';
3783: BEGIN

Line 4556: from po_vendors pov

4552:
4553: --cursor to get vendor name
4554: cursor l_vendor_csr(p_vendor_id in number) is
4555: select pov.vendor_name
4556: from po_vendors pov
4557: where vendor_id = p_vendor_id;
4558:
4559: l_vendor_name po_vendors.vendor_name%TYPE;
4560:

Line 4559: l_vendor_name po_vendors.vendor_name%TYPE;

4555: select pov.vendor_name
4556: from po_vendors pov
4557: where vendor_id = p_vendor_id;
4558:
4559: l_vendor_name po_vendors.vendor_name%TYPE;
4560:
4561: --Bug# 4558486
4562: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
4563: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 5000: from po_vendors pov

4996:
4997: --cursor to get vendor name
4998: cursor l_vendor_csr(p_vendor_id in number) is
4999: select pov.vendor_name
5000: from po_vendors pov
5001: where vendor_id = p_vendor_id;
5002:
5003: l_vendor_name po_vendors.vendor_name%TYPE;
5004:

Line 5003: l_vendor_name po_vendors.vendor_name%TYPE;

4999: select pov.vendor_name
5000: from po_vendors pov
5001: where vendor_id = p_vendor_id;
5002:
5003: l_vendor_name po_vendors.vendor_name%TYPE;
5004:
5005: --cursor to fetch party refund details record
5006: cursor l_ppyd_csr (p_cpl_id in number) is
5007: select ppyd.id