APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 4738: okc_xprt_rule_cond_vals cv

4734:
4735: CURSOR csr_cond_clause_exists IS
4736: SELECT 'X'
4737: FROM okc_xprt_rule_conditions c,
4738: okc_xprt_rule_cond_vals cv
4739: WHERE c.rule_condition_id = cv.rule_condition_id
4740: AND c.object_value_type = 'CLAUSE'
4741: AND cv.object_value_code = p_clause_id
4742: AND c.rule_id = p_rule_id ;

Line 4812: okc_xprt_rule_cond_vals cv

4808:
4809: CURSOR csr_variable_val_exists IS
4810: SELECT 'X'
4811: FROM okc_xprt_rule_conditions c,
4812: okc_xprt_rule_cond_vals cv
4813: WHERE c.rule_condition_id = cv.rule_condition_id
4814: AND c.object_value_type = 'VARIABLE'
4815: AND cv.object_value_code = p_variable_code
4816: AND c.rule_id = p_rule_id ;

Line 4881: FROM okc_xprt_rule_cond_vals cvals,

4877: p_question_id IN NUMBER)
4878: RETURN VARCHAR2 IS
4879: CURSOR question_exists IS
4880: SELECT 'x'
4881: FROM okc_xprt_rule_cond_vals cvals,
4882: okc_xprt_rule_conditions cond
4883: WHERE cond.rule_id = p_rule_id
4884: AND cond.rule_condition_id=cvals.rule_condition_id
4885: AND cond.object_value_type ='QUESTION'

Line 5190: FROM OKC_XPRT_RULE_COND_VALS

5186: RETURN VARCHAR2 IS
5187:
5188: CURSOR csr_condition_values IS
5189: SELECT Object_Value_Code
5190: FROM OKC_XPRT_RULE_COND_VALS
5191: WHERE rule_condition_id = p_rule_condition_id;
5192:
5193: l_concat_values VARCHAR2(1000) := null;
5194: l_value varchar2(1000) := null;

Line 6664: FROM okc_xprt_rule_cond_vals v,

6660:
6661: CURSOR csr_clause_exists IS
6662: -- All Clauses from Conditions
6663: SELECT 'N'
6664: FROM okc_xprt_rule_cond_vals v,
6665: okc_xprt_rule_conditions c
6666: WHERE v.rule_condition_id = c.rule_condition_id
6667: AND c.object_type = 'CLAUSE'
6668: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007