APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 155: pay_element_type_extra_info.eei_information19%TYPE

151: INDEX BY BINARY_INTEGER;
152: l_ele_pp t_ele_pp;
153:
154: TYPE t_eei_info IS TABLE OF
155: pay_element_type_extra_info.eei_information19%TYPE
156: INDEX BY BINARY_INTEGER;
157:
158: TYPE t_retro_ele IS TABLE OF
159: pay_element_types_f.element_type_id%TYPE

Line 171: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;

167:
168: --
169: -- Extra Information variables
170: --
171: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
172: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
173: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
174: --l_configuration_information1 VARCHAR2(10) := 'N' ;
175: l_configuration_information2 VARCHAR2(10) := 'N' ;

Line 172: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;

168: --
169: -- Extra Information variables
170: --
171: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
172: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
173: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
174: --l_configuration_information1 VARCHAR2(10) := 'N' ;
175: l_configuration_information2 VARCHAR2(10) := 'N' ;
176: l_configuration_information3 VARCHAR2(10) := 'N' ;

Line 173: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;

169: -- Extra Information variables
170: --
171: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
172: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
173: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
174: --l_configuration_information1 VARCHAR2(10) := 'N' ;
175: l_configuration_information2 VARCHAR2(10) := 'N' ;
176: l_configuration_information3 VARCHAR2(10) := 'N' ;
177: l_configuration_information4 VARCHAR2(10) := 'N' ;

Line 352: FROM pay_element_type_extra_info

348:
349:
350: CURSOR chk_pension_scheme_name_cur IS
351: SELECT 'x'
352: FROM pay_element_type_extra_info
353: WHERE eei_information_category = 'PQP_NL_PGGM_DEDUCTION'
354: AND eei_information1 = p_scheme_description
355: AND rownum = 1;
356:

Line 2020: FROM pay_element_type_extra_info

2016:
2017: CURSOR csr_ele_extra_info IS
2018: SELECT element_type_extra_info_id
2019: ,object_version_number ovn
2020: FROM pay_element_type_extra_info
2021: WHERE eei_information_category = 'PQP_NL_PGGM_DEDUCTION'
2022: AND element_type_id = p_pension_dedn_ele_type_id;
2023:
2024: --

Line 2123: -- Delete the rows in pay_element_type_extra_info

2119: ,p_template_id => l_template_id);
2120: --
2121:
2122: --
2123: -- Delete the rows in pay_element_type_extra_info
2124: --
2125: FOR temp_rec IN csr_ele_extra_info
2126: LOOP
2127: pay_element_extra_info_api.delete_element_extra_info