DBA Data[Home] [Help]

APPS.OKC_CTC_PVT dependencies on OKC_CONTACT_SOURCES

Line 633: ,okc_contact_sources CS

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
637: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE

Line 733: ,okc_contact_sources CS

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
737: and CS.CRO_CODE = p_ctcv_rec.CRO_CODE

Line 1450: From okc_contact_sources

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
1450: From okc_contact_sources
1451: Where rle_code = p_rle_code
1452: and cro_code = p_ctcv_rec.cro_code
1453: and buy_or_sell = p_intent;
1454: --