DBA Data[Home] [Help]

APPS.CUG_SR_ATTRIBUTE_INTF dependencies on CS_TP_TEMPLATES_VL

Line 48: , cs_tp_templates_vl tmpl

44: /* Cursor to check Existence of template in CS schema) */
45: cursor c_template_exists (p_template_name varchar2) IS
46: select lnk.template_id template_id
47: from cs_tp_template_links lnk
48: , cs_tp_templates_vl tmpl
49: where tmpl.template_id = lnk.template_id
50: and tmpl.name = p_template_name;
51:
52: /* Cursor to check Existence of template attributes */

Line 586: , cs_tp_templates_vl tmpl

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
590: and tmpl_qa.template_id = tmpl.template_id