APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 59: SELECT approval_workflow_name FROM okc_bus_doc_types_b WHERE document_type= p_contract_type;

55: FROM okc_rep_contracts_all
56: WHERE contract_id = p_contract_id;
57:
58: CURSOR fetch_wf_name(p_contract_type varchar2) IS
59: SELECT approval_workflow_name FROM okc_bus_doc_types_b WHERE document_type= p_contract_type;
60:
61:
62: BEGIN
63:

Line 4959: SELECT signature_workflow_name FROM okc_bus_doc_types_b WHERE document_type= p_contract_type;

4955: WHERE contract_id = p_contract_id
4956: AND contract_version_num = l_contract_version;
4957:
4958: CURSOR fetch_wf_name(p_contract_type varchar2) IS
4959: SELECT signature_workflow_name FROM okc_bus_doc_types_b WHERE document_type= p_contract_type;
4960:
4961:
4962:
4963: contract_rec contract_csr%ROWTYPE;

Line 7860: FROM okc_bus_doc_types_b

7856: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, '100: p_contract_type is: ' || p_contract_type);
7857: END IF;
7858:
7859: SELECT layout_template_id INTO l_layout_template_id
7860: FROM okc_bus_doc_types_b
7861: WHERE document_type = p_contract_type;
7862:
7863: IF (l_layout_template_id IS NOT NULL) THEN
7864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN