APPS.OKL_FUNDING_PVT dependencies on PO_VENDOR_SITES_ALL

Line 3642: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;

3638: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3639: -- l_set_of_books_id NUMBER;
3640: l_terms_id NUMBER;
3641: l_application_id NUMBER;
3642: l_pay_group_lookup_code PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE;
3643: l_vendor_id NUMBER;
3644:
3645: CURSOR c_vendor(p_vendor_site_id NUMBER)
3646: IS

Line 3673: from PO_VENDOR_SITES_ALL a

3669:
3670: CURSOR c_vendor_sites(p_vendor_site_id NUMBER)
3671: IS
3672: select a.TERMS_ID, a.PAY_GROUP_LOOKUP_CODE
3673: from PO_VENDOR_SITES_ALL a
3674: where vendor_site_id = p_vendor_site_id
3675: ;
3676:
3677: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;

Line 4732: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;

4728: IS
4729: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4730: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4731:
4732: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
4733: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
4734:
4735:
4736: cursor c_vs (p_vendor_site_id number)

Line 4739: from PO_VENDOR_SITES_ALL VS

4735:
4736: cursor c_vs (p_vendor_site_id number)
4737: is
4738: select vs.vendor_id
4739: from PO_VENDOR_SITES_ALL VS
4740: where vs.vendor_site_id = p_vendor_site_id;
4741:
4742: cursor c_org (p_khr_id number)
4743: is

Line 7668: PO_VENDOR_SITES_ALL VS

7664: SELECT 'X'
7665: FROM okl_trx_ap_invoices_b th,
7666: okl_txl_ap_inv_lns_all_b tl,
7667: okc_k_headers_b chr,
7668: PO_VENDOR_SITES_ALL VS
7669: WHERE th.id = tl.tap_id
7670: AND tl.khr_id = chr.id
7671: AND th.ipvs_id = vs.vendor_site_id
7672: AND th.vendor_invoice_number = p_fund_number