APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_CONTACT_SOURCES

Line 2336: FROM OKC_CONTACT_SOURCES a, okc_k_party_roles_b b

2332: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CREATE_CONTACT';
2333:
2334: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS
2335: SELECT access_level
2336: FROM OKC_CONTACT_SOURCES a, okc_k_party_roles_b b
2337: WHERE a.cro_code = p_cro_code
2338: AND b.id = p_cpl_id
2339: AND a.rle_code = b.rle_code
2340: AND a.buy_or_sell = 'S';

Line 2342: l_access_level OKC_CONTACT_SOURCES.access_level%TYPE;

2338: AND b.id = p_cpl_id
2339: AND a.rle_code = b.rle_code
2340: AND a.buy_or_sell = 'S';
2341:
2342: l_access_level OKC_CONTACT_SOURCES.access_level%TYPE;
2343:
2344:
2345: BEGIN
2346: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2542: FROM OKC_CONTACT_SOURCES a, okc_k_party_roles_b b

2538: l_api_name CONSTANT VARCHAR2(30) := 'OKL_UPDATE_CONTACT';
2539:
2540: CURSOR contact_csr(p_cro_code VARCHAR2, p_cpl_id NUMBER) IS
2541: SELECT access_level
2542: FROM OKC_CONTACT_SOURCES a, okc_k_party_roles_b b
2543: WHERE a.cro_code = p_cro_code
2544: AND b.id = p_cpl_id
2545: AND a.rle_code = b.rle_code
2546: AND a.buy_or_sell = 'S';

Line 2549: l_access_level OKC_CONTACT_SOURCES.access_level%TYPE;

2545: AND a.rle_code = b.rle_code
2546: AND a.buy_or_sell = 'S';
2547:
2548:
2549: l_access_level OKC_CONTACT_SOURCES.access_level%TYPE;
2550:
2551:
2552: BEGIN
2553: x_return_status := OKC_API.G_RET_STS_SUCCESS;