APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_QUESTIONS_VL

Line 1026: okc_xprt_questions_vl q

1022: SELECT DISTINCT q.question_name question_name,
1023: c.object_value_set_name value_set_name,
1024: q.question_id question_id
1025: FROM okc_xprt_rule_conditions c,
1026: okc_xprt_questions_vl q
1027: WHERE q.question_id = c.object_code
1028: AND c.object_type='QUESTION'
1029: AND c.object_code_datatype IN ('L','B')
1030: AND c.rule_id = p_rule_id

Line 1037: okc_xprt_questions_vl q

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

Line 1924: okc_xprt_questions_vl q

1920: CURSOR csr_rule_questions IS
1921: -- Questions in Conditions LHS
1922: SELECT DISTINCT q.question_name question_name
1923: FROM okc_xprt_rule_conditions c,
1924: okc_xprt_questions_vl q
1925: WHERE q.question_id = c.object_code
1926: AND c.object_type='QUESTION'
1927: AND c.rule_id = p_rule_id
1928: AND q.disabled_flag = 'Y'

Line 1933: okc_xprt_questions_vl q

1929: UNION
1930: -- Questions in Conditions RHS
1931: SELECT DISTINCT q.question_name question_name
1932: FROM okc_xprt_rule_conditions c,
1933: okc_xprt_questions_vl q
1934: WHERE q.question_id = c.object_value_code
1935: AND c.object_value_type='QUESTION'
1936: AND c.rule_id = p_rule_id
1937: AND q.disabled_flag = 'Y'

Line 1942: okc_xprt_questions_vl q

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