APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 660: FROM okc_xprt_rule_cond_vals v,

656: (
657: -- All DISTINCT Clauses from Conditions
658: SELECT v.object_value_code article_id,
659: a.article_title
660: FROM okc_xprt_rule_cond_vals v,
661: okc_xprt_rule_conditions c,
662: okc_xprt_rule_hdrs_all r,
663: okc_articles_all a
664: WHERE v.rule_condition_id = c.rule_condition_id

Line 905: FROM okc_xprt_rule_cond_vals v,

901: (
902: -- All DISTINCT Clauses from Conditions
903: SELECT v.object_value_code article_id,
904: a.article_title
905: FROM okc_xprt_rule_cond_vals v,
906: okc_xprt_rule_conditions c,
907: okc_xprt_rule_hdrs_all r,
908: okc_articles_all a
909: WHERE v.rule_condition_id = c.rule_condition_id

Line 1118: okc_xprt_rule_cond_vals v

1114: -- List of Values used in Rule for a Question
1115: CURSOR csr_rule_question_values(p_question_id IN NUMBER) IS
1116: SELECT v.object_value_code question_value
1117: FROM okc_xprt_rule_conditions c,
1118: okc_xprt_rule_cond_vals v
1119: WHERE c.rule_condition_id = v.rule_condition_id
1120: AND c.object_type = 'QUESTION'
1121: AND c.object_code_datatype IN ('L','B')
1122: AND c.rule_id = p_rule_id

Line 1521: okc_xprt_rule_cond_vals v

1517: -- List of Values used in Rule for a Variable
1518: CURSOR csr_rule_variable_values(p_variable_name IN VARCHAR2) IS
1519: SELECT v.object_value_code variable_value
1520: FROM okc_xprt_rule_conditions c,
1521: okc_xprt_rule_cond_vals v
1522: WHERE c.rule_condition_id = v.rule_condition_id
1523: AND c.object_type = 'VARIABLE'
1524: AND c.object_code_datatype = 'V'
1525: AND c.rule_id = p_rule_id