APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_TEMPLATE_USAGES

Line 994: FROM OKC_TEMPLATE_USAGES

990: AND nvl(KART.SUMMARY_AMEND_OPERATION_CODE,'?')<>'DELETED';
991:
992: CURSOR l_get_effective_date_csr IS
993: SELECT nvl(article_effective_date,sysdate)
994: FROM OKC_TEMPLATE_USAGES
995: WHERE DOCUMENT_TYPE = p_doc_type
996: AND DOCUMENT_ID = p_doc_id;
997:
998: CURSOR l_get_active_article_csr(b_article_id NUMBER,b_article_effective_date DATE) IS

Line 1059: FROM okc_template_usages u,

1055:
1056: CURSOR csr_mandatory_flag IS
1057: SELECT NVL(t.xprt_clause_mandatory_flag,'N'),
1058: NVL(t.xprt_scn_code,'UNASSIGNED')
1059: FROM okc_template_usages u,
1060: okc_terms_templates_all t
1061: WHERE u.template_id = t.template_id
1062: AND u.document_type = p_doc_type
1063: AND u.document_id = p_doc_id ;

Line 1081: FROM okc_template_usages

1077: l_renumber_flag VARCHAR2(1) :='N';
1078:
1079: CURSOR l_get_num_scheme_id IS
1080: SELECT doc_numbering_scheme
1081: FROM okc_template_usages
1082: WHERE document_type = p_doc_type
1083: AND document_id = p_doc_id;
1084:
1085: l_article_org_id NUMBER;

Line 2791: SELECT doc_numbering_scheme from okc_template_usages

2787: AND akb.id = ar.object_id
2788: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2789:
2790: CURSOR current_num_scheme is
2791: SELECT doc_numbering_scheme from okc_template_usages
2792: WHERE document_type = p_doc_type
2793: AND document_id = p_doc_id;
2794:
2795: