APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 4540: okc_xprt_rule_cond_vals cv

4536:
4537: CURSOR csr_cond_clause_exists IS
4538: SELECT 'X'
4539: FROM okc_xprt_rule_conditions c,
4540: okc_xprt_rule_cond_vals cv
4541: WHERE c.rule_condition_id = cv.rule_condition_id
4542: AND c.object_value_type = 'CLAUSE'
4543: AND cv.object_value_code = p_clause_id
4544: AND c.rule_id = p_rule_id ;

Line 4614: okc_xprt_rule_cond_vals cv

4610:
4611: CURSOR csr_variable_val_exists IS
4612: SELECT 'X'
4613: FROM okc_xprt_rule_conditions c,
4614: okc_xprt_rule_cond_vals cv
4615: WHERE c.rule_condition_id = cv.rule_condition_id
4616: AND c.object_value_type = 'VARIABLE'
4617: AND cv.object_value_code = p_variable_code
4618: AND c.rule_id = p_rule_id ;

Line 4683: FROM okc_xprt_rule_cond_vals cvals,

4679: p_question_id IN NUMBER)
4680: RETURN VARCHAR2 IS
4681: CURSOR question_exists IS
4682: SELECT 'x'
4683: FROM okc_xprt_rule_cond_vals cvals,
4684: okc_xprt_rule_conditions cond
4685: WHERE cond.rule_id = p_rule_id
4686: AND cond.rule_condition_id=cvals.rule_condition_id
4687: AND cond.object_value_type ='QUESTION'

Line 4992: FROM OKC_XPRT_RULE_COND_VALS

4988: RETURN VARCHAR2 IS
4989:
4990: CURSOR csr_condition_values IS
4991: SELECT Object_Value_Code
4992: FROM OKC_XPRT_RULE_COND_VALS
4993: WHERE rule_condition_id = p_rule_condition_id;
4994:
4995: l_concat_values VARCHAR2(1000) := null;
4996: l_value varchar2(1000) := null;

Line 6466: FROM okc_xprt_rule_cond_vals v,

6462:
6463: CURSOR csr_clause_exists IS
6464: -- All Clauses from Conditions
6465: SELECT 'N'
6466: FROM okc_xprt_rule_cond_vals v,
6467: okc_xprt_rule_conditions c
6468: WHERE v.rule_condition_id = c.rule_condition_id
6469: AND c.object_type = 'CLAUSE'
6470: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007