APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 450: l_source_template_id pay_element_templates.template_id%type;

446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;
451: l_object_version_number pay_element_types_f.object_version_number%type;
452: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
453: l_element_type_id Number;
454: l_balance_type_id Number;

Line 638: from pay_element_templates

634: l_proc_name Varchar2(72) := g_proc_name || 'get_template_id';
635: --
636: cursor csr_get_temp_id is
637: select template_id
638: from pay_element_templates
639: where template_name = l_template_name
640: and legislation_code = p_legislation_code
641: and template_type = 'T'
642: and business_group_id is null;

Line 1332: from pay_element_templates

1328: ) is
1329: --
1330: cursor c1 is
1331: select template_id
1332: from pay_element_templates
1333: where base_name||' Pension Deduction' = p_pension_dedn_ele_name
1334: and business_group_id = p_business_group_id
1335: and template_type = 'U';
1336: