APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 76: pay_element_type_extra_info.eei_information19%TYPE

72: INDEX BY BINARY_INTEGER;
73: l_ele_pp t_ele_pp;
74:
75: TYPE t_eei_info IS TABLE OF
76: pay_element_type_extra_info.eei_information19%TYPE
77: INDEX BY BINARY_INTEGER;
78:
79: TYPE t_retro_ele IS TABLE OF
80: pay_element_types_f.element_type_id%TYPE

Line 92: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;

88:
89: --
90: -- Extra Information variables
91: --
92: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
93: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
94: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
95:
96: --For Exclusion rules

Line 93: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;

89: --
90: -- Extra Information variables
91: --
92: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
93: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
94: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
95:
96: --For Exclusion rules
97: l_configuration_information1 VARCHAR2(10) := 'N' ;

Line 94: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;

90: -- Extra Information variables
91: --
92: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
93: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
94: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
95:
96: --For Exclusion rules
97: l_configuration_information1 VARCHAR2(10) := 'N' ;
98: l_configuration_information2 VARCHAR2(10) := 'N' ;

Line 277: FROM pay_element_type_extra_info

273: AND rpv.value = pdb.DEFINED_BALANCE_ID ;
274:
275: CURSOR chk_pension_scheme_name_cur IS
276: SELECT 'x'
277: FROM pay_element_type_extra_info
278: WHERE eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS'
279: AND eei_information1 = p_scheme_description
280: AND rownum = 1;
281:

Line 1950: FROM pay_element_type_extra_info

1946:
1947: CURSOR csr_ele_extra_info IS
1948: SELECT element_type_extra_info_id
1949: ,object_version_number
1950: FROM pay_element_type_extra_info
1951: WHERE eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS'
1952: AND element_type_id = p_savings_dedn_ele_type_id;
1953:
1954: l_template_id Number(9);

Line 1971: -- Delete the rows in pay_element_type_extra_info

1967: ,p_template_id => l_template_id);
1968: --
1969:
1970: --
1971: -- Delete the rows in pay_element_type_extra_info
1972: --
1973:
1974: FOR temp_rec IN csr_ele_extra_info
1975: LOOP