DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_HEADERS_B

Line 1511: FROM okc_k_headers_b

1507: l_return_value VARCHAR2(10);
1508: CURSOR find_chrtype_crs IS
1509: SELECT
1510: decode(application_id,515,'OKS',510,decode(buy_or_sell,'S','OKC_SELL','B','OKC_BUY','OKC_SELL'),871,'OKO',777,decode(buy_or_sell,'S','OKE_SELL','B','OKE_BUY','OKE_SELL'),540,'OKL',Null)
1511: FROM okc_k_headers_b
1512: WHERE id=p_chr_id;
1513: BEGIN
1514: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Get_Contract_Document_Type');

Line 1597: FROM okc_k_headers_b

1593: CURSOR find_chrtype_crs IS
1594: SELECT
1595: decode(application_id,515,'OKS',510,decode(buy_or_sell,'S','OKC_SELL','B','OKC_BUY','OKC_SELL'),871,'OKO',777,decode(buy_or_sell,'S','OKE_SELL','B','OKE_BUY','OKE_SELL'),540,'OKL',Null),
1596: document_id
1597: FROM okc_k_headers_b
1598: WHERE id=p_chr_id;
1599: BEGIN
1600: x_doc_type := NULL;
1601: x_doc_id := NULL;