APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 272: l_source_template_id pay_element_templates.template_id%type;

268: --
269: l_template_id pay_shadow_element_types.template_id%type;
270: l_base_element_type_id pay_template_core_objects.core_object_id%type;
271: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
272: l_source_template_id pay_element_templates.template_id%type;
273: l_object_version_number pay_element_types_f.object_version_number%type;
274: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
275: l_element_type_id Number;
276: l_balance_type_id Number;

Line 509: from pay_element_templates

505: l_proc_name Varchar2(72) := g_proc_name || 'get_template_id';
506: --
507: cursor csr_get_temp_id is
508: select template_id
509: from pay_element_templates
510: where template_name = l_template_name
511: and legislation_code = p_legislation_code
512: and template_type = 'T'
513: and business_group_id is null;

Line 1758: from pay_element_templates

1754: ) is
1755: --
1756: cursor c1 is
1757: select template_id
1758: from pay_element_templates
1759: where base_name||' Pension Deduction' = p_pension_dedn_ele_name
1760: and business_group_id = p_business_group_id
1761: and template_type = 'U';
1762: