APPS.PAY_CORE_XDO_UTILS dependencies on XDO_TEMPLATES_TL

Line 25: CURSOR get_template_name(c_templ_code xdo_templates_tl.template_code%TYPE) IS

21: and app.application_id = fcp.application_id;
22:
23:
24: -- Get template type
25: CURSOR get_template_name(c_templ_code xdo_templates_tl.template_code%TYPE) IS
26: SELECT template_name --template_type_code
27: FROM xdo_templates_vl
28: WHERE template_code = c_templ_code;
29:

Line 71: lv_template_code xdo_templates_tl.template_code%TYPE;

67: ln_application_id NUMBER;
68: ln_count NUMBER;
69: lv_proc_name VARCHAR2(100);
70: lv_template_type xdo_templates_b.template_type_code%TYPE;
71: lv_template_code xdo_templates_tl.template_code%TYPE;
72: lv_app_short_name fnd_application_vl.application_short_name%TYPE;
73: lv_template_name xdo_templates_vl.template_name%TYPE;
74:
75: lv_report_definition_id NUMBER;