APPS.OKC_RUL_PVT dependencies on OKC_OBJ_DDF_CTXCODE_TMP

Line 55: FROM okc_obj_ddf_ctxcode_tmp

51: SELECT descriptive_flex_context_code
52: ,dummy_col
53: ,seq_no
54: ,form_left_prompt
55: FROM okc_obj_ddf_ctxcode_tmp
56: WHERE descriptive_flex_context_code = p_context_code
57: ORDER BY seq_no;
58:
59:

Line 6540: FROM okc_obj_ddf_ctxcode_tmp

6536: IS
6537:
6538: CURSOR csr_tmp (p_context_code IN VARCHAR2) is
6539: SELECT 'Y'
6540: FROM okc_obj_ddf_ctxcode_tmp
6541: WHERE descriptive_flex_context_code = p_context_code;
6542:
6543: l_found VARCHAR2(10) := 'N';
6544:

Line 6568: INSERT INTO okc_obj_ddf_ctxcode_tmp

6564: -- /striping/
6565: p_appl_id := okc_rld_pvt.get_appl_id(p_rulv_rec.rule_information_category);
6566: p_dff_name := okc_rld_pvt.get_dff_name(p_rulv_rec.rule_information_category);
6567:
6568: INSERT INTO okc_obj_ddf_ctxcode_tmp
6569: (descriptive_flex_context_code, dummy_col, seq_no, form_left_prompt)
6570: SELECT
6571: descriptive_flex_context_code ,
6572: 'x',

Line 6592: (SELECT 1 FROM okc_obj_ddf_ctxcode_tmp

6588: AND B.scs_code = K.scs_code
6589: AND k.id = p_rulv_rec.dnz_chr_id
6590: )
6591: AND NOT EXISTS
6592: (SELECT 1 FROM okc_obj_ddf_ctxcode_tmp
6593: WHERE descriptive_flex_context_code =
6594: dfcu.descriptive_flex_context_code
6595: AND seq_no = SUBSTR(application_column_name,12,1));
6596: