DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_TEMPLATE_CORE_OBJECTS

Line 130: pay_template_core_objects ptco

126: --
127: cursor c3 (c_object_name in Varchar2) is
128: select ptco.core_object_id
129: from pay_shadow_balance_types psbt,
130: pay_template_core_objects ptco
131: where psbt.template_id = p_template_id
132: and psbt.balance_name = c_object_name
133: and ptco.template_id = psbt.template_id
134: and ptco.shadow_object_id = psbt.balance_type_id;

Line 446: l_base_element_type_id pay_template_core_objects.core_object_id%type;

442: )
443: return Number is
444: --
445: l_template_id pay_shadow_element_types.template_id%type;
446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;

Line 447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;

443: return Number is
444: --
445: l_template_id pay_shadow_element_types.template_id%type;
446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;
451: l_object_version_number pay_element_types_f.object_version_number%type;

Line 448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;

444: --
445: l_template_id pay_shadow_element_types.template_id%type;
446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;
451: l_object_version_number pay_element_types_f.object_version_number%type;
452: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';

Line 449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;

445: l_template_id pay_shadow_element_types.template_id%type;
446: l_base_element_type_id pay_template_core_objects.core_object_id%type;
447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;
451: l_object_version_number pay_element_types_f.object_version_number%type;
452: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
453: l_element_type_id Number;

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

521: index by BINARY_INTEGER;
522: l_main_eei_info1 t_eei_info;
523: l_retro_eei_info1 t_eei_info;
524:
525: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
526:
527: -- Extra Information variables
528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;