APPS.OKL_FUNDING_PVT dependencies on PO_VENDOR_SITES_ALL

Line 3772: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;

3768: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3769: -- l_set_of_books_id NUMBER;
3770: l_terms_id NUMBER;
3771: l_application_id NUMBER;
3772: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;
3773: l_vendor_id NUMBER;
3774:
3775: CURSOR c_vendor(p_vendor_site_id NUMBER)
3776: IS

Line 3803: from PO_VENDOR_SITES_ALL a

3799:
3800: CURSOR c_vendor_sites(p_vendor_site_id NUMBER)
3801: IS
3802: select a.TERMS_ID, a.PAY_GROUP_LOOKUP_CODE
3803: from PO_VENDOR_SITES_ALL a
3804: where vendor_site_id = p_vendor_site_id
3805: ;
3806:
3807: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;

Line 4868: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;

4864: IS
4865: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4866: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4867:
4868: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
4869: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
4870:
4871:
4872: cursor c_vs (p_vendor_site_id number)

Line 4875: from PO_VENDOR_SITES_ALL VS

4871:
4872: cursor c_vs (p_vendor_site_id number)
4873: is
4874: select vs.vendor_id
4875: from PO_VENDOR_SITES_ALL VS
4876: where vs.vendor_site_id = p_vendor_site_id;
4877:
4878: cursor c_org (p_khr_id number)
4879: is

Line 7885: PO_VENDOR_SITES_ALL VS

7881: SELECT 'X'
7882: FROM okl_trx_ap_invoices_b th,
7883: okl_txl_ap_inv_lns_all_b tl,
7884: okc_k_headers_b chr,
7885: PO_VENDOR_SITES_ALL VS
7886: WHERE th.id = tl.tap_id
7887: AND tl.khr_id = chr.id
7888: AND th.ipvs_id = vs.vendor_site_id
7889: AND th.vendor_invoice_number = p_fund_number