APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 1206: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar

1202: and var.cat_id=kart.id AND variable_type='S';
1203:
1204: CURSOR var_def_lst_crs IS
1205: SELECT busvar.variable_code
1206: FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar
1207: WHERE vo.document_type=p_doc_type AND busvar.contract_expert_yn='Y'
1208: AND busvar.variable_intent=vo.intent;
1209: CURSOR doc_cls_lst_crs IS
1210: SELECT document_type_class

Line 1701: SELECT 'X' FROM OKC_BUS_DOC_TYPES_B

1697: ) RETURN VARCHAR2 IS
1698: l_dummy VARCHAR2(1) := '?';
1699: l_return VARCHAR2(1) := FND_API.G_TRUE;
1700: cursor l_check_doc_type_crs IS
1701: SELECT 'X' FROM OKC_BUS_DOC_TYPES_B
1702: WHERE document_type=p_doc_type;
1703: BEGIN
1704:
1705: OPEN l_check_doc_type_crs;

Line 1970: from okc_bus_doc_types_b

1966: AND ver.article_status = 'APPROVED'
1967: AND reln.org_id = mo_global.get_current_org_id()
1968: AND ( ver.provision_yn = 'N' OR
1969: ( p_document_type IN (select document_type
1970: from okc_bus_doc_types_b
1971: where provision_allowed_yn = 'Y'
1972: )
1973: )
1974: );

Line 2026: FROM okc_bus_doc_types_b

2022: )
2023: AND ( ver.provision_yn = 'N' OR
2024: ( p_document_type
2025: IN ( SELECT document_type
2026: FROM okc_bus_doc_types_b
2027: WHERE provision_allowed_yn = 'Y'
2028: )
2029: )
2030: );