APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 73: pay_element_type_extra_info.eei_information19%TYPE

69: INDEX BY BINARY_INTEGER;
70: l_ele_pp t_ele_pp;
71:
72: TYPE t_eei_info IS TABLE OF
73: pay_element_type_extra_info.eei_information19%TYPE
74: INDEX BY BINARY_INTEGER;
75:
76: l_main_eei_info19 t_eei_info;
77: l_retro_eei_info19 t_eei_info;

Line 83: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;

79:
80: --
81: -- Extra Information variables
82: --
83: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
84: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
85: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
86: l_configuration_information1 VARCHAR2(10) := 'N' ;
87: l_configuration_information2 VARCHAR2(10) := 'N' ;

Line 84: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;

80: --
81: -- Extra Information variables
82: --
83: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
84: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
85: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
86: l_configuration_information1 VARCHAR2(10) := 'N' ;
87: l_configuration_information2 VARCHAR2(10) := 'N' ;
88: l_configuration_information3 VARCHAR2(10) := 'N' ;

Line 85: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;

81: -- Extra Information variables
82: --
83: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
84: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
85: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
86: l_configuration_information1 VARCHAR2(10) := 'N' ;
87: l_configuration_information2 VARCHAR2(10) := 'N' ;
88: l_configuration_information3 VARCHAR2(10) := 'N' ;
89: l_configuration_information4 VARCHAR2(10) := 'N' ;

Line 247: FROM pay_element_type_extra_info

243:
244:
245: CURSOR chk_pension_scheme_name_cur IS
246: SELECT 'x'
247: FROM pay_element_type_extra_info
248: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
249: AND eei_information1 = p_scheme_description
250: AND ROWNUM = 1;
251:

Line 588: FROM pay_element_type_extra_info pei

584: CURSOR c_abp_schemes IS
585: SELECT to_date(pei.eei_information10,'DD/MM/YYYY') date_from
586: ,to_date(pei.eei_information11,'DD/MM/YYYY') date_to
587: ,pei.eei_information1 scheme_name
588: FROM pay_element_type_extra_info pei
589: WHERE pei.eei_information12 = p_pension_sub_category
590: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
591: AND pei.information_type = 'PQP_NL_ABP_DEDUCTION'
592: AND EXISTS( SELECT 1

Line 2032: FROM pay_element_type_extra_info

2028:
2029: CURSOR csr_ele_extra_info IS
2030: SELECT element_type_extra_info_id
2031: ,object_version_number ovn
2032: FROM pay_element_type_extra_info
2033: WHERE eei_information_category = 'PQP_NL_ABP_DEDUCTION'
2034: AND element_type_id = p_pension_dedn_ele_type_id;
2035:
2036: --

Line 2232: -- Delete the rows in pay_element_type_extra_info

2228: ,p_template_id => l_template_id);
2229: --
2230:
2231: --
2232: -- Delete the rows in pay_element_type_extra_info
2233: --
2234: FOR temp_rec IN csr_ele_extra_info
2235: LOOP
2236: pay_element_extra_info_api.delete_element_extra_info