APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_QUESTIONS_B

Line 158: FROM okc_xprt_questions_b

154: IS
155: BEGIN
156: SELECT question_datatype, value_set_name
157: INTO x_question_datatype, x_value_set_name
158: FROM okc_xprt_questions_b
159: WHERE question_id = p_question_id;
160: EXCEPTION
161: WHEN OTHERS
162: THEN

Line 173: FROM okc_xprt_questions_b

169: IS
170: CURSOR cur_validate_question
171: IS
172: SELECT 'Y'
173: FROM okc_xprt_questions_b
174: WHERE question_type = 'Q' -- Question Type must be 'Q'
175: AND NVL (disabled_flag, 'N') = 'N'
176: -- Disabled questions must not be available in the Rule creation/updataion
177: AND question_intent = p_intent

Line 342: FROM okc_xprt_questions_b

338: IS
339: CURSOR cur_validate_question
340: IS
341: SELECT 'Y'
342: FROM okc_xprt_questions_b
343: WHERE question_type = 'Q' -- Question Type must be 'Q'
344: AND NVL (disabled_flag, 'N') = 'N'
345: -- Disabled questions must not be available in the Rule creation/updataion
346: AND question_intent = p_intent

Line 378: FROM okc_xprt_questions_b

374: IS
375: CURSOR cur_validate_constant
376: IS
377: SELECT 'Y'
378: FROM okc_xprt_questions_b
379: WHERE question_type = 'C' -- Constant Type must be 'Q'
380: -- Disabled questions must not be available in the Rule creation/updataion
381: AND question_intent = p_intent
382: AND question_id = p_constant_id;