APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 274: l_source_template_id pay_element_templates.template_id%type;

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

Line 511: from pay_element_templates

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

Line 1759: from pay_element_templates

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