APPS.OKC_TERMS_VERSION_PVT dependencies on OKC_SECTIONS_B

Line 47: FROM okc_sections_b

43: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
44:
45: CURSOR scn_crs IS
46: SELECT id, object_version_number,amendment_operation_code,summary_amend_operation_code
47: FROM okc_sections_b
48: WHERE document_type = p_doc_type AND document_id = p_doc_id
49: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL OR summary_amend_operation_code IS NOT NULL);
50:
51: CURSOR cat_crs IS

Line 62: FROM okc_sections_b

58: OR kart.summary_amend_operation_code IS NOT NULL OR art.standard_yn='N');
59:
60: CURSOR scn_incremental_crs IS
61: SELECT id, object_version_number, amendment_operation_code
62: FROM okc_sections_b
63: WHERE document_type = p_doc_type AND document_id = p_doc_id
64: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);
65:
66: CURSOR l_del_scn_crs IS

Line 68: FROM okc_sections_b

64: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);
65:
66: CURSOR l_del_scn_crs IS
67: SELECT id, object_version_number
68: FROM okc_sections_b
69: WHERE document_type = p_doc_type AND document_id = p_doc_id
70: AND amendment_operation_code = G_AMEND_CODE_DELETED
71: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
72:

Line 482: FROM okc_sections_b

478: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;
479:
480: CURSOR scn_crs IS
481: SELECT id, object_version_number, amendment_operation_code
482: FROM okc_sections_b
483: WHERE document_type = p_doc_type AND document_id = p_doc_id
484: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);
485:
486: CURSOR l_del_scn_crs IS

Line 488: FROM okc_sections_b

484: AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);
485:
486: CURSOR l_del_scn_crs IS
487: SELECT id, object_version_number
488: FROM okc_sections_b
489: WHERE document_type = p_doc_type AND document_id = p_doc_id
490: AND amendment_operation_code = G_AMEND_CODE_DELETED
491: AND SUMMARY_AMEND_OPERATION_CODE IS NULL;
492: