APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 141: l_source_template_id pay_element_templates.template_id%TYPE;

137: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
138: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
139: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
140: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
141: l_source_template_id pay_element_templates.template_id%TYPE;
142: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
143: l_proc_name VARCHAR2(80)
144: := g_proc_name || 'create_user_template';
145: l_element_type_id NUMBER;

Line 591: FROM pay_element_templates

587: l_proc_name VARCHAR2(72) := g_proc_name || 'get_template_id';
588: --
589: CURSOR csr_get_temp_id IS
590: SELECT template_id
591: FROM pay_element_templates
592: WHERE template_name = l_template_name
593: AND legislation_code = p_legislation_code
594: AND template_type = 'T'
595: AND business_group_id IS NULL;

Line 1942: from pay_element_templates

1938: ) is
1939: --
1940: cursor c1 is
1941: select template_id
1942: from pay_element_templates
1943: where base_name||' Employee Savings Deduction' = p_savings_dedn_ele_name
1944: and business_group_id = p_business_group_id
1945: and template_type = 'U';
1946: