APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 126: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE

122: INDEX BY BINARY_INTEGER;
123:
124: l_shadow_element t_shadow_ele_info;
125:
126: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
127: INDEX BY BINARY_INTEGER;
128:
129: l_ele_name t_ele_name;
130: l_ele_new_name t_ele_name;

Line 140: pay_element_types_f.reporting_name%TYPE

136: l_bal_name t_bal_name;
137: l_bal_new_name t_bal_name;
138:
139: TYPE t_ele_reporting_name IS TABLE OF
140: pay_element_types_f.reporting_name%TYPE
141: INDEX BY BINARY_INTEGER;
142: l_ele_reporting_name t_ele_reporting_name;
143:
144: TYPE t_ele_description IS TABLE OF

Line 145: pay_element_types_f.description%TYPE

141: INDEX BY BINARY_INTEGER;
142: l_ele_reporting_name t_ele_reporting_name;
143:
144: TYPE t_ele_description IS TABLE OF
145: pay_element_types_f.description%TYPE
146: INDEX BY BINARY_INTEGER;
147: l_ele_description t_ele_description;
148:
149: TYPE t_ele_pp IS TABLE OF

Line 150: pay_element_types_f.processing_priority%TYPE

146: INDEX BY BINARY_INTEGER;
147: l_ele_description t_ele_description;
148:
149: TYPE t_ele_pp IS TABLE OF
150: pay_element_types_f.processing_priority%TYPE
151: INDEX BY BINARY_INTEGER;
152: l_ele_pp t_ele_pp;
153:
154: TYPE t_eei_info IS TABLE OF

Line 159: pay_element_types_f.element_type_id%TYPE

155: pay_element_type_extra_info.eei_information19%TYPE
156: INDEX BY BINARY_INTEGER;
157:
158: TYPE t_retro_ele IS TABLE OF
159: pay_element_types_f.element_type_id%TYPE
160: INDEX BY BINARY_INTEGER;
161:
162: l_retro_element_lst t_retro_ele;
163:

Line 213: l_object_version_NUMBER pay_element_types_f.object_version_NUMBER%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;
217: l_balance_type_id NUMBER;

Line 387: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;

383: l_comp_name pay_retro_components.component_name%TYPE;
384: l_comp_id pay_retro_components.retro_component_id%TYPE;
385: l_comp_type pay_retro_components.retro_type%TYPE;
386: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
387: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
388: l_time_span_id pay_time_spans.time_span_id%TYPE;
389: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
390: l_proc_name VARCHAR2(80);
391: --

Line 412: FROM pay_element_types_f

408: --
409: IF p_creator_type = 'ET' THEN
410: SELECT DISTINCT element_type_id
411: INTO l_creator_id
412: FROM pay_element_types_f
413: WHERE element_name = p_creator_name
414: AND business_group_id = p_business_group_id;
415: ELSIF p_creator_type = 'EC' THEN
416: SELECT classification_id

Line 537: FROM pay_element_types_f

533: END IF;
534: --
535: SELECT DISTINCT element_type_id
536: INTO l_retro_ele_id
537: FROM pay_element_types_f
538: WHERE element_name = p_retro_element_name
539: AND business_group_id = p_business_group_id;
540: --
541: BEGIN

Line 631: UPDATE pay_element_types_f

627: hr_utility.set_location('Retro EVG id found: '||l_retro_evg_id,20);
628: CLOSE c_get_retro_evg_id;
629:
630: --now update the elements with this recalc event grp id
631: UPDATE pay_element_types_f
632: SET recalc_event_group_id = l_retro_evg_id
633: WHERE element_name = p_element_name
634: AND business_group_id = p_business_group_id;
635: ELSE

Line 2057: FROM pay_element_types_f

2053: AND business_group_id = p_business_group_id;
2054:
2055: CURSOR c_er_ele (c_base_name IN VARCHAR2) IS
2056: SELECT element_type_id
2057: FROM pay_element_types_f
2058: WHERE element_name = c_base_name||' PGGM Employer Pension Contribution'
2059: AND business_group_id = p_business_group_id
2060: AND trunc(p_effective_date) BETWEEN effective_start_date AND
2061: effective_end_date ;