APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on XDO_TEMPLATES_TL

Line 62: FROM xdo_templates_b xb, xdo_templates_tl xtl

58:
59: CURSOR csr_temp_code_dtls(p_template_code IN VARCHAR,
60: p_concurrent_prog IN VARCHAR) IS
61: SELECT xtl.template_code, xtl.template_name, xb.template_type_code
62: FROM xdo_templates_b xb, xdo_templates_tl xtl
63: WHERE xb.template_code = xtl.template_code
64: AND xb.application_short_name = xtl.application_short_name
65: AND xtl.application_short_name = 'PAY'
66: AND xb.template_status = 'E'

Line 119: lv_template_code xdo_templates_tl.template_code%TYPE;

115: AND legislation_code IS NULL;
116:
117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
122: lv_rg_short_name fnd_common_lookups.description%TYPE;
123: lv_legislation_code hr_organization_information.org_information9%TYPE;

Line 120: lv_template_name xdo_templates_tl.template_name%TYPE;

116:
117: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
118: lv_meaning fnd_common_lookups.meaning%TYPE;
119: lv_template_code xdo_templates_tl.template_code%TYPE;
120: lv_template_name xdo_templates_tl.template_name%TYPE;
121: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
122: lv_rg_short_name fnd_common_lookups.description%TYPE;
123: lv_legislation_code hr_organization_information.org_information9%TYPE;
124: ln_report_group_id pay_report_groups.report_group_id%TYPE;