APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 2156: FROM OKC_K_PARTY_ROLES_B

2152:
2153: --cursor to find out chr id required to flip status at edit point
2154: CURSOR chr_id_crs (p_cpl_id IN NUMBER) IS
2155: SELECT DNZ_CHR_ID
2156: FROM OKC_K_PARTY_ROLES_B
2157: WHERE ID = P_CPL_ID;
2158:
2159: l_dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%TYPE;
2160:

Line 2159: l_dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%TYPE;

2155: SELECT DNZ_CHR_ID
2156: FROM OKC_K_PARTY_ROLES_B
2157: WHERE ID = P_CPL_ID;
2158:
2159: l_dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%TYPE;
2160:
2161:
2162:
2163: BEGIN

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 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';