APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

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

376: type t_ele_pp is table of pay_element_types_f.processing_priority%type
377: index by BINARY_INTEGER;
378: l_ele_pp t_ele_pp;
379:
380: type t_eei_info is table of pay_element_type_extra_info.eei_information19%type
381: index by BINARY_INTEGER;
382: l_main_eei_info19 t_eei_info;
383: l_retro_eei_info19 t_eei_info;
384:

Line 388: l_eei_information11 pay_element_type_extra_info.eei_information9%type;

384:
385: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
386:
387: -- Extra Information variables
388: l_eei_information11 pay_element_type_extra_info.eei_information9%type;
389: l_eei_information12 pay_element_type_extra_info.eei_information10%type;
390: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
391: l_configuration_information4 VARCHAR2(10) := 'N' ;
392: l_configuration_information5 VARCHAR2(10) := 'N' ;

Line 389: l_eei_information12 pay_element_type_extra_info.eei_information10%type;

385: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
386:
387: -- Extra Information variables
388: l_eei_information11 pay_element_type_extra_info.eei_information9%type;
389: l_eei_information12 pay_element_type_extra_info.eei_information10%type;
390: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
391: l_configuration_information4 VARCHAR2(10) := 'N' ;
392: l_configuration_information5 VARCHAR2(10) := 'N' ;
393: l_configuration_information6 VARCHAR2(10) := 'N' ;

Line 390: l_eei_information20 pay_element_type_extra_info.eei_information18%type;

386:
387: -- Extra Information variables
388: l_eei_information11 pay_element_type_extra_info.eei_information9%type;
389: l_eei_information12 pay_element_type_extra_info.eei_information10%type;
390: l_eei_information20 pay_element_type_extra_info.eei_information18%type;
391: l_configuration_information4 VARCHAR2(10) := 'N' ;
392: l_configuration_information5 VARCHAR2(10) := 'N' ;
393: l_configuration_information6 VARCHAR2(10) := 'N' ;
394: l_configuration_information7 VARCHAR2(10) := 'N' ;

Line 515: FROM pay_element_type_extra_info

511: AND rpv.value = pdb.DEFINED_BALANCE_ID;
512:
513: CURSOR chk_savings_scheme_name_cur IS
514: SELECT 'x'
515: FROM pay_element_type_extra_info
516: WHERE eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS'
517: AND eei_information1 = p_scheme_description
518: AND rownum = 1;
519:

Line 2083: FROM pay_element_type_extra_info

2079:
2080: CURSOR csr_ele_extra_info IS
2081: SELECT element_type_extra_info_id
2082: ,object_version_number
2083: FROM pay_element_type_extra_info
2084: WHERE eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS'
2085: AND element_type_id = p_savings_dedn_ele_type_id;
2086:
2087: l_template_id Number(9);

Line 2104: -- Delete the rows in pay_element_type_extra_info

2100: ,p_template_id => l_template_id);
2101: --
2102:
2103: --
2104: -- Delete the rows in pay_element_type_extra_info
2105: --
2106:
2107: FOR temp_rec IN csr_ele_extra_info
2108: LOOP