APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_RULE_OUTCOMES

Line 396: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

392:
393: -- insert into the global temp table
394:
395: l_sql_string := 'select distinct to_char(cond.object_code) condition_question_id, to_char(object_value_id) outcome_question_id
396: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
397: where cond.object_type = ''QUESTION''
398: and outcome.object_type = ''QUESTION''
399: and cond.rule_id = outcome.rule_id
400: and cond.rule_id in (

Line 435: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

431:
432: UNION ALL
433:
434: select distinct to_char(cond.object_value_code) condition_question_id, to_char(object_value_id) outcome_question_id
435: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
436: where cond.object_value_type = ''QUESTION''
437: and outcome.object_type = ''QUESTION''
438: and cond.rule_id = outcome.rule_id
439: and cond.rule_id in (

Line 636: FROM okc_xprt_rule_outcomes o,

632: UNION
633: -- All DISTINCT Clauses from Outcome
634: SELECT to_char(o.object_value_id) article_id,
635: a.article_title
636: FROM okc_xprt_rule_outcomes o,
637: okc_xprt_rule_hdrs_all r,
638: okc_articles_all a
639: WHERE o.rule_id = r.rule_id
640: AND a.article_id = o.object_value_id

Line 860: FROM okc_xprt_rule_outcomes o,

856: UNION
857: -- All DISTINCT Clauses from Outcome
858: SELECT to_char(o.object_value_id) article_id,
859: a.article_title
860: FROM okc_xprt_rule_outcomes o,
861: okc_xprt_rule_hdrs_all r,
862: okc_articles_all a
863: WHERE o.rule_id = r.rule_id
864: AND a.article_id = o.object_value_id

Line 1036: FROM okc_xprt_rule_outcomes o,

1032: -- Questions in Outcome
1033: SELECT DISTINCT q.question_name question_name,
1034: q.value_set_name value_set_name,
1035: q.question_id question_id
1036: FROM okc_xprt_rule_outcomes o,
1037: okc_xprt_questions_vl q
1038: WHERE q.question_id = o.object_value_id
1039: AND o.object_type='QUESTION'
1040: AND q.question_datatype IN ('L','B')

Line 1941: FROM okc_xprt_rule_outcomes o,

1937: AND q.disabled_flag = 'Y'
1938: UNION
1939: -- Questions in Outcome
1940: SELECT DISTINCT q.question_name question_name
1941: FROM okc_xprt_rule_outcomes o,
1942: okc_xprt_questions_vl q
1943: WHERE q.question_id = o.object_value_id
1944: AND o.object_type='QUESTION'
1945: AND o.rule_id = p_rule_id