APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_QUESTIONS_B

Line 1027: Okc_xprt_questions_b quest

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

Line 1043: Okc_xprt_questions_b quest

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

Line 1055: Okc_xprt_questions_b quest

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

Line 1070: Okc_xprt_questions_b quest

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

Line 5384: select question_datatype from okc_xprt_questions_b

5380: WHERE flex_value_set_id = p_value_set_id;
5381:
5382: -- cursor to find datatype of a question
5383: CURSOR csr_get_qst_datatype is
5384: select question_datatype from okc_xprt_questions_b
5385: where to_char(question_id) = p_object_code;
5386:
5387: -- cursor to fetch document value for questions based on constants
5388: CURSOR csr_get_rule_qst_const_val (l_config_header_id number, l_config_rev_nbr number) is

Line 6360: FROM okc_xprt_questions_b

6356:
6357:
6358: Cursor c2 is
6359: SELECT decode(disabled_flag,'Y','N','Y') disabled_yn
6360: FROM okc_xprt_questions_b
6361: WHERE question_id= p_object_id;
6362:
6363: l_ret_value VARCHAR2(1) := 'Y';
6364: