APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_QUESTIONS_VL

Line 1097: okc_xprt_questions_vl q

1093: SELECT DISTINCT q.question_name question_name,
1094: c.object_value_set_name value_set_name,
1095: q.question_id question_id
1096: FROM okc_xprt_rule_conditions c,
1097: okc_xprt_questions_vl q
1098: WHERE q.question_id = c.object_code
1099: AND c.object_type='QUESTION'
1100: AND c.object_code_datatype IN ('L','B')
1101: AND c.rule_id = p_rule_id

Line 1108: okc_xprt_questions_vl q

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')
1112: AND o.rule_id = p_rule_id;

Line 1995: okc_xprt_questions_vl q

1991: CURSOR csr_rule_questions IS
1992: -- Questions in Conditions LHS
1993: SELECT DISTINCT q.question_name question_name
1994: FROM okc_xprt_rule_conditions c,
1995: okc_xprt_questions_vl q
1996: WHERE q.question_id = c.object_code
1997: AND c.object_type='QUESTION'
1998: AND c.rule_id = p_rule_id
1999: AND q.disabled_flag = 'Y'

Line 2004: okc_xprt_questions_vl q

2000: UNION
2001: -- Questions in Conditions RHS
2002: SELECT DISTINCT q.question_name question_name
2003: FROM okc_xprt_rule_conditions c,
2004: okc_xprt_questions_vl q
2005: WHERE q.question_id = c.object_value_code
2006: AND c.object_value_type='QUESTION'
2007: AND c.rule_id = p_rule_id
2008: AND q.disabled_flag = 'Y'

Line 2013: okc_xprt_questions_vl q

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
2017: AND q.disabled_flag = 'Y' ;