APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

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

43: INDEX BY BINARY_INTEGER;
44:
45: l_shadow_element t_shadow_ele_info;
46:
47: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
48: INDEX BY BINARY_INTEGER;
49:
50: l_ele_name t_ele_name;
51: l_ele_new_name t_ele_name;

Line 61: pay_element_types_f.reporting_name%TYPE

57: l_bal_name t_bal_name;
58: l_bal_new_name t_bal_name;
59:
60: TYPE t_ele_reporting_name IS TABLE OF
61: pay_element_types_f.reporting_name%TYPE
62: INDEX BY BINARY_INTEGER;
63: l_ele_reporting_name t_ele_reporting_name;
64:
65: TYPE t_ele_description IS TABLE OF

Line 66: pay_element_types_f.description%TYPE

62: INDEX BY BINARY_INTEGER;
63: l_ele_reporting_name t_ele_reporting_name;
64:
65: TYPE t_ele_description IS TABLE OF
66: pay_element_types_f.description%TYPE
67: INDEX BY BINARY_INTEGER;
68: l_ele_description t_ele_description;
69:
70: TYPE t_ele_pp IS TABLE OF

Line 71: pay_element_types_f.processing_priority%TYPE

67: INDEX BY BINARY_INTEGER;
68: l_ele_description t_ele_description;
69:
70: TYPE t_ele_pp IS TABLE OF
71: pay_element_types_f.processing_priority%TYPE
72: INDEX BY BINARY_INTEGER;
73: l_ele_pp t_ele_pp;
74:
75: TYPE t_eei_info IS TABLE OF

Line 80: pay_element_types_f.element_type_id%TYPE

76: pay_element_type_extra_info.eei_information19%TYPE
77: INDEX BY BINARY_INTEGER;
78:
79: TYPE t_retro_ele IS TABLE OF
80: pay_element_types_f.element_type_id%TYPE
81: INDEX BY BINARY_INTEGER;
82:
83: l_retro_element_lst t_retro_ele;
84:

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

Line 315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;

311: l_comp_name pay_retro_components.component_name%TYPE;
312: l_comp_id pay_retro_components.retro_component_id%TYPE;
313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
316: l_time_span_id pay_time_spans.time_span_id%TYPE;
317: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
318: l_proc_name VARCHAR2(80);
319: --

Line 340: FROM pay_element_types_f

336: --
337: IF p_creator_type = 'ET' THEN
338: SELECT DISTINCT element_type_id
339: INTO l_creator_id
340: FROM pay_element_types_f
341: WHERE element_name = p_creator_name
342: AND business_group_id = p_business_group_id;
343: ELSIF p_creator_type = 'EC' THEN
344: SELECT classification_id

Line 465: FROM pay_element_types_f

461: END IF;
462: --
463: SELECT DISTINCT element_type_id
464: INTO l_retro_ele_id
465: FROM pay_element_types_f
466: WHERE element_name = p_retro_element_name
467: AND business_group_id = p_business_group_id;
468: --
469: BEGIN

Line 560: UPDATE pay_element_types_f

556: hr_utility.set_location('Retro EVG id found: '||l_retro_evg_id,20);
557: CLOSE c_get_retro_evg_id;
558:
559: --now update the elements with this recalc event grp id
560: UPDATE pay_element_types_f
561: SET recalc_event_group_id = l_retro_evg_id
562: WHERE element_name = p_element_name
563: AND business_group_id = p_business_group_id;
564: ELSE