APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 27: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;

23: l_comp_name pay_retro_components.component_name%TYPE;
24: l_comp_id pay_retro_components.retro_component_id%TYPE;
25: l_comp_type pay_retro_components.retro_type%TYPE;
26: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
27: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
28: l_time_span_id pay_time_spans.time_span_id%TYPE;
29: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
30: l_proc_name VARCHAR2(80);
31: --

Line 52: FROM pay_element_types_f

48: --
49: IF p_creator_type = 'ET' THEN
50: SELECT DISTINCT element_type_id
51: INTO l_creator_id
52: FROM pay_element_types_f
53: WHERE element_name = p_creator_name
54: AND business_group_id = p_business_group_id;
55: ELSIF p_creator_type = 'EC' THEN
56: SELECT classification_id

Line 177: FROM pay_element_types_f

173: END IF;
174: --
175: SELECT DISTINCT element_type_id
176: INTO l_retro_ele_id
177: FROM pay_element_types_f
178: WHERE element_name = p_retro_element_name
179: AND business_group_id = p_business_group_id;
180: --
181: BEGIN

Line 271: UPDATE pay_element_types_f

267: hr_utility.set_location('Retro EVG id found: '||l_retro_evg_id,20);
268: CLOSE c_get_retro_evg_id;
269:
270: --now update the elements with this recalc event grp id
271: UPDATE pay_element_types_f
272: SET recalc_event_group_id = l_retro_evg_id
273: WHERE element_name = p_element_name
274: AND business_group_id = p_business_group_id;
275: ELSE

Line 322: l_object_version_number pay_element_types_f.object_version_number%type;

318: l_template_id pay_shadow_element_types.template_id%type;
319: l_base_element_type_id pay_template_core_objects.core_object_id%type;
320: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
321: l_source_template_id pay_element_templates.template_id%type;
322: l_object_version_number pay_element_types_f.object_version_number%type;
323: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
324: l_element_type_id Number;
325: l_balance_type_id Number;
326: l_eei_element_type_id Number;

Line 356: type t_ele_name is table of pay_element_types_f.element_name%type

352: type t_shadow_ele_info is table of shadow_ele_rec
353: index by Binary_Integer;
354: l_shadow_element t_shadow_ele_info;
355:
356: type t_ele_name is table of pay_element_types_f.element_name%type
357: index by BINARY_INTEGER;
358: l_ele_name t_ele_name;
359: l_ele_new_name t_ele_name;
360: l_main_ele_name t_ele_name;

Line 368: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type

364: index by BINARY_INTEGER;
365: l_bal_name t_bal_name;
366: l_bal_new_name t_bal_name;
367:
368: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
369: index by BINARY_INTEGER;
370: l_ele_reporting_name t_ele_reporting_name;
371:
372: type t_ele_description is table of pay_element_types_f.description%type

Line 372: type t_ele_description is table of pay_element_types_f.description%type

368: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
369: index by BINARY_INTEGER;
370: l_ele_reporting_name t_ele_reporting_name;
371:
372: type t_ele_description is table of pay_element_types_f.description%type
373: index by BINARY_INTEGER;
374: l_ele_description t_ele_description;
375:
376: type t_ele_pp is table of pay_element_types_f.processing_priority%type

Line 376: type t_ele_pp is table of pay_element_types_f.processing_priority%type

372: type t_ele_description is table of pay_element_types_f.description%type
373: index by BINARY_INTEGER;
374: l_ele_description t_ele_description;
375:
376: type t_ele_pp is table of pay_element_types_f.processing_priority%type
377: index by BINARY_INTEGER;
378: l_ele_pp t_ele_pp;
379:
380: type t_eei_info is table of pay_element_type_extra_info.eei_information19%type