APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on XDO_TEMPLATES_TL

Line 71: FROM xdo_templates_b xb, xdo_templates_tl xtl

67:
68: CURSOR csr_temp_code_dtls(p_template_code IN VARCHAR,
69: p_concurrent_prog IN VARCHAR) IS
70: SELECT xtl.template_code, xtl.template_name, xb.template_type_code
71: FROM xdo_templates_b xb, xdo_templates_tl xtl
72: WHERE xb.template_code = xtl.template_code
73: AND xb.application_short_name = xtl.application_short_name
74: AND xtl.application_short_name IN ('PAY', 'PER') /* Bug 8716056 */
75: AND xb.template_status = 'E'

Line 128: lv_template_code xdo_templates_tl.template_code%TYPE;

124: AND legislation_code IS NULL;
125:
126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;

Line 129: lv_template_name xdo_templates_tl.template_name%TYPE;

125:
126: lv_lookup_code fnd_common_lookups.lookup_code%TYPE;
127: lv_meaning fnd_common_lookups.meaning%TYPE;
128: lv_template_code xdo_templates_tl.template_code%TYPE;
129: lv_template_name xdo_templates_tl.template_name%TYPE;
130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;
133: ln_report_group_id pay_report_groups.report_group_id%TYPE;