APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 123: l_source_template_id pay_element_templates.template_id%TYPE;

119: l_cy_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
120: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
121: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
122: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
123: l_source_template_id pay_element_templates.template_id%TYPE;
124: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
125: l_proc_name VARCHAR2(80)
126: := g_proc_name || 'create_user_template';
127: l_element_type_id NUMBER;

Line 482: FROM pay_element_templates

478: l_proc_name VARCHAR2(72) := g_proc_name || 'get_template_id';
479: --
480: CURSOR csr_get_temp_id IS
481: SELECT template_id
482: FROM pay_element_templates
483: WHERE template_name = l_template_name
484: AND legislation_code = p_legislation_code
485: AND template_type = 'T'
486: AND business_group_id IS NULL;

Line 2024: FROM pay_element_templates

2020: --
2021: CURSOR c1 IS
2022: SELECT template_id
2023: ,base_name
2024: FROM pay_element_templates
2025: WHERE base_name||' ABP Pension Deduction' = p_pension_dedn_ele_name
2026: AND business_group_id = p_business_group_id
2027: AND template_type = 'U';
2028: