DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 622: FROM okc_xprt_rule_cond_vals v,

618: (
619: -- All DISTINCT Clauses from Conditions
620: SELECT v.object_value_code article_id,
621: a.article_title
622: FROM okc_xprt_rule_cond_vals v,
623: okc_xprt_rule_conditions c,
624: okc_xprt_rule_hdrs_all r,
625: okc_articles_all a
626: WHERE v.rule_condition_id = c.rule_condition_id

Line 846: FROM okc_xprt_rule_cond_vals v,

842: (
843: -- All DISTINCT Clauses from Conditions
844: SELECT v.object_value_code article_id,
845: a.article_title
846: FROM okc_xprt_rule_cond_vals v,
847: okc_xprt_rule_conditions c,
848: okc_xprt_rule_hdrs_all r,
849: okc_articles_all a
850: WHERE v.rule_condition_id = c.rule_condition_id

Line 1047: okc_xprt_rule_cond_vals v

1043: -- List of Values used in Rule for a Question
1044: CURSOR csr_rule_question_values(p_question_id IN NUMBER) IS
1045: SELECT v.object_value_code question_value
1046: FROM okc_xprt_rule_conditions c,
1047: okc_xprt_rule_cond_vals v
1048: WHERE c.rule_condition_id = v.rule_condition_id
1049: AND c.object_type = 'QUESTION'
1050: AND c.object_code_datatype IN ('L','B')
1051: AND c.rule_id = p_rule_id

Line 1450: okc_xprt_rule_cond_vals v

1446: -- List of Values used in Rule for a Variable
1447: CURSOR csr_rule_variable_values(p_variable_name IN VARCHAR2) IS
1448: SELECT v.object_value_code variable_value
1449: FROM okc_xprt_rule_conditions c,
1450: okc_xprt_rule_cond_vals v
1451: WHERE c.rule_condition_id = v.rule_condition_id
1452: AND c.object_type = 'VARIABLE'
1453: AND c.object_code_datatype = 'V'
1454: AND c.rule_id = p_rule_id