APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_QUESTIONS_B

Line 1025: Okc_xprt_questions_b quest

1021: (SELECT 1
1022: FROM Okc_Xprt_Rule_Conditions Cond,
1023: okc_xprt_rule_hdrs_all Rules,
1024: Okc_Xprt_Template_Rules Assoc,
1025: Okc_xprt_questions_b quest
1026: WHERE Rules.Rule_Id = Cond.Rule_Id
1027: AND Rules.Rule_Id = Assoc.Rule_Id
1028: AND Assoc.Template_Id = p_Template_Id
1029: AND ( ( to_char(Okc_Xprt_Question_Orders.Question_Id) = Cond.Object_Code

Line 1041: Okc_xprt_questions_b quest

1037: SELECT 1
1038: FROM Okc_Xprt_Rule_Outcomes Outs,
1039: okc_xprt_rule_hdrs_all Rules,
1040: Okc_Xprt_Template_Rules Assoc,
1041: Okc_xprt_questions_b quest
1042: WHERE Rules.Rule_Id = Assoc.Rule_Id
1043: AND Rules.rule_id = Outs.rule_id
1044: AND Assoc.Template_Id = p_Template_Id
1045: AND to_char(Okc_Xprt_Question_Orders.Question_Id) =

Line 1053: Okc_xprt_questions_b quest

1049: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1050: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1051: SELECT 1
1052: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,
1053: Okc_xprt_questions_b quest
1054: WHERE Rules.Rule_Id = Cond.Rule_Id
1055: AND Rules.Org_Wide_Flag = 'Y'
1056: AND Rules.Org_Id = l_Org_Id
1057: AND Rules.Intent = l_Intent

Line 1068: Okc_xprt_questions_b quest

1064: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1065: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1066: SELECT 1
1067: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,
1068: Okc_xprt_questions_b quest
1069: WHERE Rules.Rule_Id = Outs.Rule_Id
1070: AND Rules.Org_Wide_Flag = 'Y'
1071: AND Rules.Org_Id = l_Org_Id
1072: AND Rules.Intent = l_Intent

Line 5186: select question_datatype from okc_xprt_questions_b

5182: WHERE flex_value_set_id = p_value_set_id;
5183:
5184: -- cursor to find datatype of a question
5185: CURSOR csr_get_qst_datatype is
5186: select question_datatype from okc_xprt_questions_b
5187: where to_char(question_id) = p_object_code;
5188:
5189: -- cursor to fetch document value for questions based on constants
5190: CURSOR csr_get_rule_qst_const_val (l_config_header_id number, l_config_rev_nbr number) is

Line 6162: FROM okc_xprt_questions_b

6158:
6159:
6160: Cursor c2 is
6161: SELECT decode(disabled_flag,'Y','N','Y') disabled_yn
6162: FROM okc_xprt_questions_b
6163: WHERE question_id= p_object_id;
6164:
6165: l_ret_value VARCHAR2(1) := 'Y';
6166: