APPS.PAY_PAYRPENP_XML_PKG dependencies on XDO_TEMPLATES_TL

Line 14: l_template_name xdo_templates_tl.template_name%type;

10:
11: function get_template_name(p_app_short_name varchar2
12: ,p_template_code varchar2) return varchar2 is
13:
14: l_template_name xdo_templates_tl.template_name%type;
15: begin
16:
17: l_template_name := 'Not Defined';
18: select template_name

Line 20: from xdo_templates_tl

16:
17: l_template_name := 'Not Defined';
18: select template_name
19: into l_template_name
20: from xdo_templates_tl
21: where application_short_name= p_app_short_name
22: and template_code= p_template_code
23: and language=userenv('LANG');
24:

Line 489: l_template_name xdo_templates_tl.template_name%type;

485: l_location_code hr_locations.location_code%type;
486: l_business_group_name per_business_groups.name%type;
487: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;
488: l_organization_name hr_organization_units.name%type;
489: l_template_name xdo_templates_tl.template_name%type;
490: l_master_statement varchar2(32000);
491: l_detail_statement varchar2(32000);
492: l_master_column1 varchar2(60);
493: l_master_column2 varchar2(60);