DBA Data[Home] [Help]

APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_QUESTIONS_VL

Line 61: , cs_tp_questions_vl quest

57: , quest.name qname
58: , quest.text qtext
59: , quest.description qdesc
60: FROM cs_tp_template_questions tmpq
61: , cs_tp_questions_vl quest
62: WHERE tmpq.question_id = quest.question_id
63: AND tmpq.template_id = p_templ_id
64: AND quest.name = p_attr_name;
65:

Line 341: from cs_tp_questions_vl q

337: close c_template_attr_exists;
338:
339: /* get the template question lookupid */
340: select l.lookup_id into l_tmpl_quest_lookup_id
341: from cs_tp_questions_vl q
342: , cs_tp_lookups l
343: , cs_tp_template_questions tq
344: where q.lookup_id = l.lookup_id
345: and tq.question_id = q.question_id

Line 583: from cs_tp_questions_vl qvl

579: , qvl.name name
580: , qvl.text text
581: , qvl.lookup_id lookup_id
582: , ch.lookup_type choice_id
583: from cs_tp_questions_vl qvl
584: , cs_tp_lookups ch
585: , cs_tp_template_questions tmpl_qa
586: , cs_tp_templates_vl tmpl
587: where qvl.lookup_id = ch.lookup_id