APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_XPRT_QUESTION_ORDERS

Line 744: l_sequence_num okc_xprt_question_orders.sequence_num%TYPE;

740: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
741: l_api_name CONSTANT VARCHAR2(30) := 'create_template_feature';
742: l_model_feature_name VARCHAR2(255);
743: l_question_id okc_xprt_questions_b.question_id%TYPE;
744: l_sequence_num okc_xprt_question_orders.sequence_num%TYPE;
745: l_value_set_name okc_xprt_questions_b.value_set_name%TYPE;
746: l_feature_type NUMBER;
747: l_feature_min_val NUMBER;
748: l_feature_max_val NUMBER;

Line 766: okc_xprt_question_orders o

762: DECODE(q.prompt,NULL,q.question_name,q.prompt),
763: q.language,
764: q.source_lang
765: FROM okc_xprt_questions_tl q,
766: okc_xprt_question_orders o
767: WHERE q.question_id = o.question_id
768: AND o.question_rule_status IN ('ACTIVE','PENDINGPUB')
769: AND o.template_id = p_template_id;
770:

Line 820: okc_xprt_question_orders o

816: q.value_set_name,
817: DECODE(q.question_datatype,'N',2,
818: 0) --FEATURE_TYPE 2:Decimal 0:option
819: FROM okc_xprt_questions_b q,
820: okc_xprt_question_orders o
821: WHERE q.question_id = o.question_id
822: AND o.question_rule_status IN ('ACTIVE','PENDINGPUB')
823: AND o.template_id = p_template_id
824: ORDER BY sequence_num;