APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_RULE_OUTCOMES

Line 434: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

430:
431: -- insert into the global temp table
432:
433: l_sql_string := 'select distinct to_char(cond.object_code) condition_question_id, to_char(object_value_id) outcome_question_id
434: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
435: where cond.object_type = ''QUESTION''
436: and outcome.object_type = ''QUESTION''
437: and cond.rule_id = outcome.rule_id
438: and cond.rule_id in (

Line 473: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome

469:
470: UNION ALL
471:
472: select distinct to_char(cond.object_value_code) condition_question_id, to_char(object_value_id) outcome_question_id
473: from OKC_XPRT_RULE_CONDITIONS cond, OKC_XPRT_RULE_OUTCOMES outcome
474: where cond.object_value_type = ''QUESTION''
475: and outcome.object_type = ''QUESTION''
476: and cond.rule_id = outcome.rule_id
477: and cond.rule_id in (

Line 674: FROM okc_xprt_rule_outcomes o,

670: UNION
671: -- All DISTINCT Clauses from Outcome
672: SELECT to_char(o.object_value_id) article_id,
673: a.article_title
674: FROM okc_xprt_rule_outcomes o,
675: okc_xprt_rule_hdrs_all r,
676: okc_articles_all a
677: WHERE o.rule_id = r.rule_id
678: AND a.article_id = o.object_value_id

Line 919: FROM okc_xprt_rule_outcomes o,

915: UNION
916: -- All DISTINCT Clauses from Outcome
917: SELECT to_char(o.object_value_id) article_id,
918: a.article_title
919: FROM okc_xprt_rule_outcomes o,
920: okc_xprt_rule_hdrs_all r,
921: okc_articles_all a
922: WHERE o.rule_id = r.rule_id
923: AND a.article_id = o.object_value_id

Line 1107: FROM okc_xprt_rule_outcomes o,

1103: -- Questions in Outcome
1104: SELECT DISTINCT q.question_name question_name,
1105: q.value_set_name value_set_name,
1106: q.question_id question_id
1107: FROM okc_xprt_rule_outcomes o,
1108: okc_xprt_questions_vl q
1109: WHERE q.question_id = o.object_value_id
1110: AND o.object_type='QUESTION'
1111: AND q.question_datatype IN ('L','B')

Line 2012: FROM okc_xprt_rule_outcomes o,

2008: AND q.disabled_flag = 'Y'
2009: UNION
2010: -- Questions in Outcome
2011: SELECT DISTINCT q.question_name question_name
2012: FROM okc_xprt_rule_outcomes o,
2013: okc_xprt_questions_vl q
2014: WHERE q.question_id = o.object_value_id
2015: AND o.object_type='QUESTION'
2016: AND o.rule_id = p_rule_id