APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 459: l_source_template_id pay_element_templates.template_id%type;

455: l_base_element_type_id pay_template_core_objects.core_object_id%type;
456: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
457: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
458: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
459: l_source_template_id pay_element_templates.template_id%type;
460: l_object_version_number pay_element_types_f.object_version_number%type;
461: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
462: l_element_type_id Number;
463: l_balance_type_id Number;

Line 647: from pay_element_templates

643: l_proc_name Varchar2(72) := g_proc_name || 'get_template_id';
644: --
645: cursor csr_get_temp_id is
646: select template_id
647: from pay_element_templates
648: where template_name = l_template_name
649: and legislation_code = p_legislation_code
650: and template_type = 'T'
651: and business_group_id is null;

Line 1341: from pay_element_templates

1337: ) is
1338: --
1339: cursor c1 is
1340: select template_id
1341: from pay_element_templates
1342: where base_name||' Pension Deduction' = p_pension_dedn_ele_name
1343: and business_group_id = p_business_group_id
1344: and template_type = 'U';
1345: