APPS.OKC_CTC_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 428: from OKC_K_PARTY_ROLES_B

424: p_ctcv_rec IN CTCV_REC_TYPE) is
425: l_dummy_var varchar2(1) := '?';
426: cursor l_cpl_csr is
427: select 'x'
428: from OKC_K_PARTY_ROLES_B
429: where id = p_ctcv_rec.cpl_id;
430: begin
431:
432: IF (l_debug = 'Y') THEN

Line 575: okc_k_party_roles_b PR

571: --
572: cursor l_object1_csr is
573: select '!'
574: from
575: okc_k_party_roles_b PR
576: ,okc_contact_sources CS
577: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
578: where
579: PR.ID = p_ctcv_rec.CPL_ID

Line 675: okc_k_party_roles_b PR

671: ,PR.RLE_CODE
672: ,KH.BUY_OR_SELL
673: ,KH.SCS_CODE
674: from
675: okc_k_party_roles_b PR
676: ,okc_contact_sources CS
677: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
678: where
679: PR.ID = p_ctcv_rec.CPL_ID

Line 1388: From okc_k_party_roles_b

1384: Where id = p_ctcv_rec.dnz_chr_id;
1385:
1386: Cursor c_rle_code Is
1387: Select rle_code
1388: From okc_k_party_roles_b
1389: Where dnz_chr_id = p_ctcv_rec.dnz_chr_id;
1390:
1391: Cursor c_access_level(p_rle_code varchar2, p_intent varchar2) Is
1392: Select access_level