APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_ROLE_SOURCES

Line 4379: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

4375: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PTY_RLS';
4376: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4377: l_debug_enabled VARCHAR2(10);
4378: l_chr_id NUMBER;
4379: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
4380: row_count NUMBER DEFAULT 0;
4381: l_cplv_id NUMBER;
4382: l_party_name VARCHAR2(200);
4383: l_party_desc VARCHAR2(2000);

Line 4405: FROM OKC_ROLE_SOURCES

4401: AND rle_code = G_RLE_CODE
4402: AND object1_id1 = p_customer_id;
4403: CURSOR role_csr(p_rle_code VARCHAR2) IS
4404: SELECT access_level
4405: FROM OKC_ROLE_SOURCES
4406: WHERE rle_code = p_rle_code
4407: AND buy_or_sell = 'S';
4408: --Get the vendor id
4409: CURSOR c_cplv (p_khr_id IN okl_lease_applications_v.PROGRAM_AGREEMENT_ID%TYPE) IS