APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;

2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2951: l_count NUMBER;
2952: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2953: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
2955:
2956: cursor check_document_row_exists IS
2957: select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS
2958: where document_type = p_document_type and document_id = p_document_id

Line 3290: select intent from okc_bus_doc_types_b

3286: del_new_parents new_parent_tab;
3287: --disp_seqs disp_seq_tab;
3288:
3289: cursor get_intent_csr is
3290: select intent from okc_bus_doc_types_b
3291: where document_type = p_document_type;
3292:
3293: l_prof_value VARCHAR2(1);
3294: BEGIN