DBA Data[Home] [Help]

APPS.OKC_CTC_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 485: from OKC_K_PARTY_ROLES_B

481: p_ctcv_rec IN CTCV_REC_TYPE) is
482: l_dummy_var varchar2(1) := '?';
483: cursor l_cpl_csr is
484: select 'x'
485: from OKC_K_PARTY_ROLES_B
486: where id = p_ctcv_rec.cpl_id;
487: begin
488:
489: IF (l_debug = 'Y') THEN

Line 632: okc_k_party_roles_b PR

628: --
629: cursor l_object1_csr is
630: select '!'
631: from
632: okc_k_party_roles_b PR
633: ,okc_contact_sources CS
634: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
635: where
636: PR.ID = p_ctcv_rec.CPL_ID

Line 732: okc_k_party_roles_b PR

728: ,PR.RLE_CODE
729: ,KH.BUY_OR_SELL
730: ,KH.SCS_CODE
731: from
732: okc_k_party_roles_b PR
733: ,okc_contact_sources CS
734: ,okc_k_headers_all_b KH -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b KH
735: where
736: PR.ID = p_ctcv_rec.CPL_ID

Line 1445: From okc_k_party_roles_b

1441: Where id = p_ctcv_rec.dnz_chr_id;
1442:
1443: Cursor c_rle_code Is
1444: Select rle_code
1445: From okc_k_party_roles_b
1446: Where dnz_chr_id = p_ctcv_rec.dnz_chr_id;
1447:
1448: Cursor c_access_level(p_rle_code varchar2, p_intent varchar2) Is
1449: Select access_level