APPS.OKC_ALLOWED_TMPL_USAGES_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 509: l_doc_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;

505: ) RETURN VARCHAR2 IS
506: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
507: l_dummy_var VARCHAR2(1) := '?';
508: l_template_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
509: l_doc_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
510: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
511:
512: CURSOR l_template_id_csr is
513: SELECT '!'

Line 519: FROM okc_bus_doc_types_b

515: WHERE TEMPLATE_ID = p_template_id;
516:
517: CURSOR l_document_type_csr is
518: SELECT '!'
519: FROM okc_bus_doc_types_b
520: WHERE DOCUMENT_TYPE = p_document_type;
521:
522: CURSOR l_template_intent_csr IS
523: SELECT intent

Line 529: FROM OKC_BUS_DOC_TYPES_B

525: WHERE template_id = p_template_id;
526:
527: CURSOR l_doc_intent_csr IS
528: SELECT intent
529: FROM OKC_BUS_DOC_TYPES_B
530: WHERE document_type = p_document_type;
531:
532: CURSOR l_doc_name_csr IS
533: SELECT name