APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 1247: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar

1243: and var.cat_id=kart.id AND variable_type='S';
1244:
1245: CURSOR var_def_lst_crs IS
1246: SELECT busvar.variable_code
1247: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar
1248: WHERE vo.document_type=p_doc_type AND busvar.contract_expert_yn='Y'
1249: AND busvar.variable_intent=vo.intent;
1250: CURSOR doc_cls_lst_crs IS
1251: SELECT document_type_class

Line 1743: SELECT 'X' FROM OKC_BUS_DOC_TYPES_B

1739: ) RETURN VARCHAR2 IS
1740: l_dummy VARCHAR2(1) := '?';
1741: l_return VARCHAR2(1) := FND_API.G_TRUE;
1742: cursor l_check_doc_type_crs IS
1743: SELECT 'X' FROM OKC_BUS_DOC_TYPES_B
1744: WHERE document_type=p_doc_type;
1745: BEGIN
1746:
1747: OPEN l_check_doc_type_crs;

Line 2012: from okc_bus_doc_types_b

2008: AND ver.article_status = 'APPROVED'
2009: AND reln.org_id = mo_global.get_current_org_id()
2010: AND ( ver.provision_yn = 'N' OR
2011: ( p_document_type IN (select document_type
2012: from okc_bus_doc_types_b
2013: where provision_allowed_yn = 'Y'
2014: )
2015: )
2016: );

Line 2068: FROM okc_bus_doc_types_b

2064: )
2065: AND ( ver.provision_yn = 'N' OR
2066: ( p_document_type
2067: IN ( SELECT document_type
2068: FROM okc_bus_doc_types_b
2069: WHERE provision_allowed_yn = 'Y'
2070: )
2071: )
2072: );