APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_TEMPLATE_QUESTIONS

Line 60: FROM cs_tp_template_questions tmpq

56: , quest.lookup_id lookup_id
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;

Line 343: , cs_tp_template_questions tq

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
346: and tq.template_id = l_tmpl_id
347: and q.question_id = l_tmpl_quest_id;

Line 585: , cs_tp_template_questions tmpl_qa

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
588: and ch.lookup_type = 'CHOICE'
589: and tmpl_qa.question_id = qvl.question_id