APPS.OKS_AUTO_REMINDER dependencies on XDO_TEMPLATES_VL

Line 2174: FROM xdo_templates_vl

2170: WHERE chr_id = p_chr_id;
2171:
2172: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER) IS
2173: SELECT template_name
2174: FROM xdo_templates_vl
2175: WHERE template_id=p_attachment_template_id;
2176:
2177: BEGIN
2178:

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

2506: fnd_message.set_token('TOKEN1',l_concat_k_number);
2507: x_subject := fnd_message.get;
2508: END IF;
2509:
2510: -- if attachment name is NULL then get template name from xdo_templates_vl
2511: IF x_is_eligible = 'Y' AND x_quote_id IS NOT NULL AND
2512: x_attachment_name IS NULL THEN
2513: OPEN csr_xdo_template_name(p_attachment_template_id => x_quote_id);
2514: FETCH csr_xdo_template_name INTO x_attachment_name;