APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 123: pay_template_core_objects ptco

119: --
120: cursor c3 (c_object_name in Varchar2) is
121: select ptco.core_object_id
122: from pay_shadow_balance_types psbt,
123: pay_template_core_objects ptco
124: where psbt.template_id = p_template_id
125: and psbt.balance_name = c_object_name
126: and ptco.template_id = psbt.template_id
127: and ptco.shadow_object_id = psbt.balance_type_id;

Line 272: l_base_element_type_id pay_template_core_objects.core_object_id%type;

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

Line 273: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;

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

Line 336: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;

332: index by BINARY_INTEGER;
333: l_main_eei_info19 t_eei_info;
334: l_retro_eei_info19 t_eei_info;
335:
336: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
337:
338: -- Extra Information variables
339: l_eei_information11 pay_element_type_extra_info.eei_information9%type;
340: l_eei_information12 pay_element_type_extra_info.eei_information10%type;