APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_TEMPLATE_USAGES

Line 997: FROM OKC_TEMPLATE_USAGES

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

Line 1062: FROM okc_template_usages u,

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

Line 1092: FROM okc_template_usages

1088: l_renumber_flag VARCHAR2(1) :='N';
1089:
1090: CURSOR l_get_num_scheme_id IS
1091: SELECT doc_numbering_scheme
1092: FROM okc_template_usages
1093: WHERE document_type = p_doc_type
1094: AND document_id = p_doc_id;
1095:
1096: l_article_org_id NUMBER;

Line 2904: SELECT doc_numbering_scheme from okc_template_usages

2900: AND akb.id = ar.object_id
2901: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2902:
2903: CURSOR current_num_scheme is
2904: SELECT doc_numbering_scheme from okc_template_usages
2905: WHERE document_type = p_doc_type
2906: AND document_id = p_doc_id;
2907:
2908:

Line 3285: FROM okc_template_usages

3281: l_api_name CONSTANT VARCHAR2(30) := 'sort_clauses';
3282:
3283: CURSOR l_get_num_scheme_id IS
3284: SELECT doc_numbering_scheme
3285: FROM okc_template_usages
3286: WHERE document_type = p_doc_type
3287: AND document_id = p_doc_id;
3288:
3289: