APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 114: from pay_element_types_f

110: l_proc_name Varchar2(72) := g_proc_name || 'get_object_id';
111: --
112: cursor c2 (c_object_name varchar2) is
113: select element_type_id
114: from pay_element_types_f
115: where element_name = c_object_name
116: and business_group_id = p_business_group_id;
117: --
118: cursor c3 (c_object_name in Varchar2) is

Line 190: ,pay_element_types_f pet

186: select input_value_id
187: ,piv.name
188: ,piv.element_type_id
189: from pay_input_values_f piv
190: ,pay_element_types_f pet
191: where element_name = c_ele_name
192: and piv.element_type_id = pet.element_type_id
193: and (piv.business_group_id = p_business_group_id or
194: piv.business_group_id is null)

Line 273: l_object_version_number pay_element_types_f.object_version_number%type;

269: l_template_id pay_shadow_element_types.template_id%type;
270: l_base_element_type_id pay_template_core_objects.core_object_id%type;
271: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
272: l_source_template_id pay_element_templates.template_id%type;
273: l_object_version_number pay_element_types_f.object_version_number%type;
274: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
275: l_element_type_id Number;
276: l_balance_type_id Number;
277: l_eei_element_type_id Number;

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

301: type t_shadow_ele_info is table of shadow_ele_rec
302: index by Binary_Integer;
303: l_shadow_element t_shadow_ele_info;
304:
305: type t_ele_name is table of pay_element_types_f.element_name%type
306: index by BINARY_INTEGER;
307: l_ele_name t_ele_name;
308: l_ele_new_name t_ele_name;
309: l_main_ele_name t_ele_name;

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

313: index by BINARY_INTEGER;
314: l_bal_name t_bal_name;
315: l_bal_new_name t_bal_name;
316:
317: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
318: index by BINARY_INTEGER;
319: l_ele_reporting_name t_ele_reporting_name;
320:
321: type t_ele_description is table of pay_element_types_f.description%type

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

317: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
318: index by BINARY_INTEGER;
319: l_ele_reporting_name t_ele_reporting_name;
320:
321: type t_ele_description is table of pay_element_types_f.description%type
322: index by BINARY_INTEGER;
323: l_ele_description t_ele_description;
324:
325: type t_ele_pp is table of pay_element_types_f.processing_priority%type

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

321: type t_ele_description is table of pay_element_types_f.description%type
322: index by BINARY_INTEGER;
323: l_ele_description t_ele_description;
324:
325: type t_ele_pp is table of pay_element_types_f.processing_priority%type
326: index by BINARY_INTEGER;
327: l_ele_pp t_ele_pp;
328:
329: type t_eei_info is table of pay_element_type_extra_info.eei_information19%type