APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 2845: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;

2841: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2842: l_count NUMBER;
2843: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2844: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2845: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
2846:
2847: cursor check_document_row_exists IS
2848: select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS
2849: where document_type = p_document_type and document_id = p_document_id

Line 3181: select intent from okc_bus_doc_types_b

3177: del_new_parents new_parent_tab;
3178: --disp_seqs disp_seq_tab;
3179:
3180: cursor get_intent_csr is
3181: select intent from okc_bus_doc_types_b
3182: where document_type = p_document_type;
3183: BEGIN
3184:
3185: -- Standard Start of API savepoint