DBA Data[Home] [Help]

APPS.OKC_TERMS_DEVIATIONS_PVT dependencies on OKC_CONTRACT_DOCS_DETAILS_VL

Line 1486: select 'Y' from okc_contract_docs_details_vl

1482: p_document_id IN NUMBER
1483: ) RETURN VARCHAR2 IS
1484: l_api_name CONSTANT VARCHAR2(30) := 'has_deviation_report';
1485: CURSOR doc_details_csr IS
1486: select 'Y' from okc_contract_docs_details_vl
1487: where business_document_id = p_document_id
1488: and business_document_type = p_document_type
1489: and category_code = 'OKC_REPO_APPROVAL_ABSTRACT'
1490: and business_document_version = -99;