APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 529: type t_eei_info is table of pay_element_type_extra_info.eei_information1%type

525: type t_ele_pp is table of pay_element_types_f.processing_priority%type
526: index by BINARY_INTEGER;
527: l_ele_pp t_ele_pp;
528:
529: type t_eei_info is table of pay_element_type_extra_info.eei_information1%type
530: index by BINARY_INTEGER;
531: l_main_eei_info1 t_eei_info;
532: l_retro_eei_info1 t_eei_info;
533:

Line 537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;

533:
534: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
535:
536: -- Extra Information variables
537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

Line 538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;

534: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
535:
536: -- Extra Information variables
537: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
538: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
539: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
540: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
541: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
542: l_row_id rowid;

Line 1349: FROM pay_element_type_extra_info

1345:
1346: CURSOR csr_ele_extra_info IS
1347: SELECT element_type_extra_info_id
1348: ,object_version_number
1349: FROM pay_element_type_extra_info
1350: WHERE eei_information_category = 'IE_PENSION_SCHEME_INFO'
1351: AND element_type_id = p_pension_dedn_ele_type_id;
1352:
1353: l_template_id Number(9);

Line 1370: -- Delete the rows in pay_element_type_extra_info

1366: ,p_template_id => l_template_id);
1367: --
1368:
1369: --
1370: -- Delete the rows in pay_element_type_extra_info
1371: --
1372:
1373: FOR temp_rec IN csr_ele_extra_info
1374: LOOP