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.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 6359: l_service_history pay_element_type_extra_info.eei_information5%type;

6355: pet.effective_end_date ;
6356:
6357: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6358: l_element_set csr_element_set%rowtype;
6359: l_service_history pay_element_type_extra_info.eei_information5%type;
6360: l_fte pay_element_type_extra_info.eei_information4%type;
6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6362: l_qualifier pay_element_type_extra_info.eei_information3%type;
6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;

Line 6360: l_fte pay_element_type_extra_info.eei_information4%type;

6356:
6357: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6358: l_element_set csr_element_set%rowtype;
6359: l_service_history pay_element_type_extra_info.eei_information5%type;
6360: l_fte pay_element_type_extra_info.eei_information4%type;
6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6362: l_qualifier pay_element_type_extra_info.eei_information3%type;
6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6364: l_element_rate number := 0;

Line 6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;

6357: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6358: l_element_set csr_element_set%rowtype;
6359: l_service_history pay_element_type_extra_info.eei_information5%type;
6360: l_fte pay_element_type_extra_info.eei_information4%type;
6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6362: l_qualifier pay_element_type_extra_info.eei_information3%type;
6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6364: l_element_rate number := 0;
6365: l_total_rate number := 0;

Line 6362: l_qualifier pay_element_type_extra_info.eei_information3%type;

6358: l_element_set csr_element_set%rowtype;
6359: l_service_history pay_element_type_extra_info.eei_information5%type;
6360: l_fte pay_element_type_extra_info.eei_information4%type;
6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6362: l_qualifier pay_element_type_extra_info.eei_information3%type;
6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6364: l_element_rate number := 0;
6365: l_total_rate number := 0;
6366:

Line 6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;

6359: l_service_history pay_element_type_extra_info.eei_information5%type;
6360: l_fte pay_element_type_extra_info.eei_information4%type;
6361: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6362: l_qualifier pay_element_type_extra_info.eei_information3%type;
6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6364: l_element_rate number := 0;
6365: l_total_rate number := 0;
6366:
6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;

Line 6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;

6363: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6364: l_element_rate number := 0;
6365: l_total_rate number := 0;
6366:
6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6369: l_input_value pay_element_type_extra_info.eei_information1%type;
6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;

Line 6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;

6364: l_element_rate number := 0;
6365: l_total_rate number := 0;
6366:
6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6369: l_input_value pay_element_type_extra_info.eei_information1%type;
6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;

Line 6369: l_input_value pay_element_type_extra_info.eei_information1%type;

6365: l_total_rate number := 0;
6366:
6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6369: l_input_value pay_element_type_extra_info.eei_information1%type;
6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;

Line 6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;

6366:
6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6369: l_input_value pay_element_type_extra_info.eei_information1%type;
6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;

Line 6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;

6367: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6368: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6369: l_input_value pay_element_type_extra_info.eei_information1%type;
6370: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

Line 6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

6371: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6376: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6377: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6378: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6379:

Line 6376: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;

6372: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6376: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6377: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6378: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6379:
6380:

Line 6377: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;

6373: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6376: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6377: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6378: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6379:
6380:
6381: -- Added a new varaibale to hold the element details .

Line 6378: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;

6374: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6375: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6376: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6377: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6378: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6379:
6380:
6381: -- Added a new varaibale to hold the element details .
6382: l_element_dtl pqp_gb_tp_pension_extracts.t_allowance_eles;

Line 13532: FROM pay_element_type_extra_info petf

13528:
13529: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS
13530: SELECT petf.element_type_id
13531: ,petf.eei_information2 pay_source_value
13532: FROM pay_element_type_extra_info petf
13533: WHERE petf.element_type_id =p_ele_id
13534: AND petf.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
13535:
13536: l_chk_pay_src csr_chk_pay_src%ROWTYPE;

Line 17149: FROM pay_element_type_extra_info petei

17145:
17146: CURSOR c_ele_attr(p_element_type_id IN NUMBER) IS
17147: SELECT petei.eei_information2 pay_source_value
17148: ,petei.eei_information3 Qualifier
17149: FROM pay_element_type_extra_info petei
17150: WHERE petei.element_type_id = p_element_type_id
17151: AND petei.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
17152:
17153: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS

Line 17483: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;

17479: l_user_value pay_user_column_instances_f.value%TYPE;
17480: l_error_msg VARCHAR2(2000);
17481:
17482: -- RET1.a : new variables to store element_type_extra_info_id
17483: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;
17484: l_retval NUMBER;
17485: l_allow_code VARCHAR2(1);
17486: --
17487: --