eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

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

516: type t_ele_pp is table of pay_element_types_f.processing_priority%type
517: index by BINARY_INTEGER;
518: l_ele_pp t_ele_pp;
519:
520: type t_eei_info is table of pay_element_type_extra_info.eei_information1%type
521: index by BINARY_INTEGER;
522: l_main_eei_info1 t_eei_info;
523: l_retro_eei_info1 t_eei_info;
524:

Line 528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;

524:
525: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
526:
527: -- Extra Information variables
528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
530: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
531: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
532: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;

Line 529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;

525: l_ele_core_id pay_template_core_objects.core_object_id%type:= -1;
526:
527: -- Extra Information variables
528: l_eei_information1 pay_element_type_extra_info.eei_information1%type;
529: l_eei_information2 pay_element_type_extra_info.eei_information2%type;
530: l_ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%type;
531: l_er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%type;
532: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%type;
533: l_row_id rowid;

Line 1340: FROM pay_element_type_extra_info

1336:
1337: CURSOR csr_ele_extra_info IS
1338: SELECT element_type_extra_info_id
1339: ,object_version_number
1340: FROM pay_element_type_extra_info
1341: WHERE eei_information_category = 'IE_PENSION_SCHEME_INFO'
1342: AND element_type_id = p_pension_dedn_ele_type_id;
1343:
1344: l_template_id Number(9);

Line 1361: -- Delete the rows in pay_element_type_extra_info

1357: ,p_template_id => l_template_id);
1358: --
1359:
1360: --
1361: -- Delete the rows in pay_element_type_extra_info
1362: --
1363:
1364: FOR temp_rec IN csr_ele_extra_info
1365: LOOP