APPS.OKS_AUTO_REMINDER dependencies on XDO_TEMPLATES_VL

Line 2251: FROM xdo_templates_vl

2247: WHERE chr_id = p_chr_id;
2248:
2249: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER) IS
2250: SELECT template_name
2251: FROM xdo_templates_vl
2252: WHERE template_id=p_attachment_template_id;
2253:
2254: /*added for bug6956935*/
2255: Cursor l_chrv_csr(p_chr_id NUMBER) Is

Line 2608: -- if attachment name is NULL then get template name from xdo_templates_vl

2604: fnd_message.set_token('TOKEN1',l_concat_k_number);
2605: x_subject := fnd_message.get;
2606: END IF;
2607:
2608: -- if attachment name is NULL then get template name from xdo_templates_vl
2609: IF x_is_eligible = 'Y' AND x_quote_id IS NOT NULL AND
2610: x_attachment_name IS NULL THEN
2611: OPEN csr_xdo_template_name(p_attachment_template_id => x_quote_id);
2612: FETCH csr_xdo_template_name INTO x_attachment_name;