[Home] [Help]
40: INDEX BY Binary_Integer;
41:
42: l_shadow_element t_shadow_ele_info;
43:
44: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
45: INDEX BY BINARY_INTEGER;
46:
47: l_ele_name t_ele_name;
48: l_ele_new_name t_ele_name;
54: l_bal_name t_bal_name;
55: l_bal_new_name t_bal_name;
56:
57: TYPE t_ele_reporting_name IS TABLE OF
58: pay_element_types_f.reporting_name%TYPE
59: INDEX BY BINARY_INTEGER;
60: l_ele_reporting_name t_ele_reporting_name;
61:
62: TYPE t_ele_description IS TABLE OF
59: INDEX BY BINARY_INTEGER;
60: l_ele_reporting_name t_ele_reporting_name;
61:
62: TYPE t_ele_description IS TABLE OF
63: pay_element_types_f.description%TYPE
64: INDEX BY BINARY_INTEGER;
65: l_ele_description t_ele_description;
66:
67: TYPE t_ele_pp IS TABLE OF
64: INDEX BY BINARY_INTEGER;
65: l_ele_description t_ele_description;
66:
67: TYPE t_ele_pp IS TABLE OF
68: pay_element_types_f.processing_priority%TYPE
69: INDEX BY BINARY_INTEGER;
70: l_ele_pp t_ele_pp;
71:
72: TYPE t_eei_info IS TABLE OF
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;
128: l_balance_type_id NUMBER;
303: l_comp_name pay_retro_components.component_name%TYPE;
304: l_comp_id pay_retro_components.retro_component_id%TYPE;
305: l_comp_type pay_retro_components.retro_type%TYPE;
306: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
307: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
308: l_time_span_id pay_time_spans.time_span_id%TYPE;
309: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
310: begin
311: if g_creator.name = p_creator_name
316: -- Prime creator cache
317: if p_creator_type = 'ET' then
318: select distinct element_type_id
319: into l_creator_id
320: from pay_element_types_f
321: where element_name = p_creator_name
322: -- and legislation_code = g_legislation_code
323: and business_group_id = p_business_group_id;
324: elsif p_creator_type = 'EC' then
425: end if;
426: --
427: select distinct element_type_id
428: into l_retro_ele_id
429: from pay_element_types_f
430: where element_name = p_retro_element_name
431: and business_group_id = p_business_group_id;
432: --and legislation_code = g_legislation_code;
433:
589: WHERE pei.eei_information12 = p_pension_sub_category
590: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
591: AND pei.information_type = 'PQP_NL_ABP_DEDUCTION'
592: AND EXISTS( SELECT 1
593: FROM pay_element_types_f pet
594: WHERE pei.element_type_id = pet.element_type_id
595: AND pet.business_group_id = p_business_group_id);
596:
597: BEGIN
686:
687: CURSOR c_proc_rule IS
688: SELECT psp.status_processing_rule_id
689: FROM pay_status_processing_rules_f psp
690: ,pay_element_types_f pet
691: ,ff_formulas_f fff
692: WHERE psp.element_type_id = pet.element_type_id
693: AND psp.formula_id = fff.formula_id
694: AND trunc(p_scheme_start_date)
704: AND psp.business_group_id = p_business_group_id;
705:
706: CURSOR c_abp_ele IS
707: SELECT element_type_id
708: FROM pay_element_types_f
709: WHERE element_name = 'ABP Pensions'
710: AND legislation_code = 'NL'
711: AND trunc(p_scheme_start_date) BETWEEN
712: effective_start_date AND effective_end_date;
2098: l_base_name VARCHAR2(100);
2099:
2100: CURSOR c_er_ele (c_base_name IN VARCHAR2) IS
2101: SELECT element_type_id
2102: FROM pay_element_types_f
2103: WHERE element_name = c_base_name||' ABP Employer Pension Contribution'
2104: AND business_group_id = p_business_group_id
2105: AND trunc(p_effective_date) BETWEEN effective_start_date AND
2106: effective_end_date ;