APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 212: l_source_template_id pay_element_templates.template_id%TYPE;

208: l_cy_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
209: l_py_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
210: l_py_er_retro_element_type_id pay_template_core_objects.core_object_id%TYPE;
211: l_xtr_element_type_id pay_template_core_objects.core_object_id%TYPE;
212: l_source_template_id pay_element_templates.template_id%TYPE;
213: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%TYPE;
214: l_proc_name VARCHAR2(80)
215: := g_proc_name || 'create_user_template';
216: l_element_type_id NUMBER;

Line 661: FROM pay_element_templates

657: l_proc_name VARCHAR2(72) := g_proc_name || 'get_template_id';
658: --
659: CURSOR csr_get_temp_id IS
660: SELECT template_id
661: FROM pay_element_templates
662: WHERE template_name = l_template_name
663: AND legislation_code = p_legislation_code
664: AND template_type = 'T'
665: AND business_group_id IS NULL;

Line 2012: FROM pay_element_templates

2008: --
2009: CURSOR c1 IS
2010: SELECT template_id
2011: ,base_name
2012: FROM pay_element_templates
2013: WHERE base_name||' PGGM Pension Deduction' = p_pension_dedn_ele_name
2014: AND business_group_id = p_business_group_id
2015: AND template_type = 'U';
2016: