APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 321: l_source_template_id pay_element_templates.template_id%type;

317: --
318: l_template_id pay_shadow_element_types.template_id%type;
319: l_base_element_type_id pay_template_core_objects.core_object_id%type;
320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
321: l_source_template_id pay_element_templates.template_id%type;
322: l_object_version_number pay_element_types_f.object_version_number%type;
323: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
324: l_element_type_id Number;
325: l_balance_type_id Number;

Line 532: from pay_element_templates

528: l_proc_name Varchar2(72) := g_proc_name || 'get_template_id';
529: --
530: cursor csr_get_temp_id is
531: select template_id
532: from pay_element_templates
533: where template_name = l_template_name
534: and legislation_code = p_legislation_code
535: and template_type = 'T'
536: and business_group_id is null;

Line 2075: from pay_element_templates

2071: ) is
2072: --
2073: cursor c1 is
2074: select template_id
2075: from pay_element_templates
2076: where base_name||' Savings Deduction' = p_savings_dedn_ele_name
2077: and business_group_id = p_business_group_id
2078: and template_type = 'U';
2079: