APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 331: type t_eei_info is table of pay_element_type_extra_info.eei_information19%type

327: type t_ele_pp is table of pay_element_types_f.processing_priority%type
328: index by BINARY_INTEGER;
329: l_ele_pp t_ele_pp;
330:
331: type t_eei_info is table of pay_element_type_extra_info.eei_information19%type
332: index by BINARY_INTEGER;
333: l_main_eei_info19 t_eei_info;
334: l_retro_eei_info19 t_eei_info;
335:

Line 339: l_eei_information11 pay_element_type_extra_info.eei_information9%type;

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;
341: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
342: l_configuration_information4 VARCHAR2(10) := 'N' ;
343: l_configuration_information5 VARCHAR2(10) := 'N' ;

Line 340: l_eei_information12 pay_element_type_extra_info.eei_information10%type;

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;
341: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
342: l_configuration_information4 VARCHAR2(10) := 'N' ;
343: l_configuration_information5 VARCHAR2(10) := 'N' ;
344: l_configuration_information6 VARCHAR2(10) := 'N' ;

Line 341: l_eei_information20 pay_element_type_extra_info.eei_information18%type;

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;
341: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
342: l_configuration_information4 VARCHAR2(10) := 'N' ;
343: l_configuration_information5 VARCHAR2(10) := 'N' ;
344: l_configuration_information6 VARCHAR2(10) := 'N' ;
345: l_configuration_information7 VARCHAR2(10) := 'N' ;

Line 494: FROM pay_element_type_extra_info

490:
491:
492: CURSOR chk_pension_scheme_name_cur IS
493: SELECT 'x'
494: FROM pay_element_type_extra_info
495: WHERE eei_information_category = 'PQP_NL_PRE_TAX_DEDUCTIONS'
496: AND eei_information1 = p_scheme_description
497: AND rownum = 1;
498:

Line 1767: FROM pay_element_type_extra_info

1763:
1764: CURSOR csr_ele_extra_info IS
1765: SELECT element_type_extra_info_id
1766: ,object_version_number
1767: FROM pay_element_type_extra_info
1768: WHERE eei_information_category = 'PQP_NL_PRE_TAX_DEDUCTIONS'
1769: AND element_type_id = p_pension_dedn_ele_type_id;
1770:
1771: l_template_id Number(9);

Line 1788: -- Delete the rows in pay_element_type_extra_info

1784: ,p_template_id => l_template_id);
1785: --
1786:
1787: --
1788: -- Delete the rows in pay_element_type_extra_info
1789: --
1790:
1791: FOR temp_rec IN csr_ele_extra_info
1792: LOOP