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 6331: l_service_history pay_element_type_extra_info.eei_information5%type;

6327: pet.effective_end_date ;
6328:
6329: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6330: l_element_set csr_element_set%rowtype;
6331: l_service_history pay_element_type_extra_info.eei_information5%type;
6332: l_fte pay_element_type_extra_info.eei_information4%type;
6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6334: l_qualifier pay_element_type_extra_info.eei_information3%type;
6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;

Line 6332: l_fte pay_element_type_extra_info.eei_information4%type;

6328:
6329: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6330: l_element_set csr_element_set%rowtype;
6331: l_service_history pay_element_type_extra_info.eei_information5%type;
6332: l_fte pay_element_type_extra_info.eei_information4%type;
6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6334: l_qualifier pay_element_type_extra_info.eei_information3%type;
6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6336: l_element_rate number := 0;

Line 6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;

6329: l_proc_name varchar2(60) := g_proc_name || 'rates_history';
6330: l_element_set csr_element_set%rowtype;
6331: l_service_history pay_element_type_extra_info.eei_information5%type;
6332: l_fte pay_element_type_extra_info.eei_information4%type;
6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6334: l_qualifier pay_element_type_extra_info.eei_information3%type;
6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6336: l_element_rate number := 0;
6337: l_total_rate number := 0;

Line 6334: l_qualifier pay_element_type_extra_info.eei_information3%type;

6330: l_element_set csr_element_set%rowtype;
6331: l_service_history pay_element_type_extra_info.eei_information5%type;
6332: l_fte pay_element_type_extra_info.eei_information4%type;
6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6334: l_qualifier pay_element_type_extra_info.eei_information3%type;
6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6336: l_element_rate number := 0;
6337: l_total_rate number := 0;
6338:

Line 6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;

6331: l_service_history pay_element_type_extra_info.eei_information5%type;
6332: l_fte pay_element_type_extra_info.eei_information4%type;
6333: l_pay_source_value pay_element_type_extra_info.eei_information2%type;
6334: l_qualifier pay_element_type_extra_info.eei_information3%type;
6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6336: l_element_rate number := 0;
6337: l_total_rate number := 0;
6338:
6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;

Line 6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;

6335: l_from_time_dim pay_element_type_extra_info.eei_information1%type;
6336: l_element_rate number := 0;
6337: l_total_rate number := 0;
6338:
6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6341: l_input_value pay_element_type_extra_info.eei_information1%type;
6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;

Line 6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;

6336: l_element_rate number := 0;
6337: l_total_rate number := 0;
6338:
6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6341: l_input_value pay_element_type_extra_info.eei_information1%type;
6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;

Line 6341: l_input_value pay_element_type_extra_info.eei_information1%type;

6337: l_total_rate number := 0;
6338:
6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6341: l_input_value pay_element_type_extra_info.eei_information1%type;
6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;

Line 6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;

6338:
6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6341: l_input_value pay_element_type_extra_info.eei_information1%type;
6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;

Line 6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;

6339: l_calculation_type pay_element_type_extra_info.eei_information1%type;
6340: l_calculation_value pay_element_type_extra_info.eei_information1%type;
6341: l_input_value pay_element_type_extra_info.eei_information1%type;
6342: l_linked_to_assignment pay_element_type_extra_info.eei_information1%type;
6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

Line 6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

6343: l_term_time_yes_no pay_element_type_extra_info.eei_information1%type;
6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6348: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6349: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6350: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6351:

Line 6348: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;

6344: l_chk_assign_link fnd_lookup_values.lookup_code%TYPE;
6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6348: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6349: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6350: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6351:
6352:

Line 6349: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;

6345: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6348: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6349: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6350: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6351:
6352:
6353: -- Added a new varaibale to hold the element details .

Line 6350: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;

6346: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
6347: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
6348: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
6349: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
6350: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
6351:
6352:
6353: -- Added a new varaibale to hold the element details .
6354: l_element_dtl pqp_gb_tp_pension_extracts.t_allowance_eles;

Line 13333: FROM pay_element_type_extra_info petf

13329:
13330: CURSOR csr_chk_pay_src(p_ele_id NUMBER) IS
13331: SELECT petf.element_type_id
13332: ,petf.eei_information2 pay_source_value
13333: FROM pay_element_type_extra_info petf
13334: WHERE petf.element_type_id =p_ele_id
13335: AND petf.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
13336:
13337: l_chk_pay_src csr_chk_pay_src%ROWTYPE;

Line 16780: FROM pay_element_type_extra_info petei

16776:
16777: CURSOR c_ele_attr(p_element_type_id IN NUMBER) IS
16778: SELECT petei.eei_information2 pay_source_value
16779: ,petei.eei_information3 Qualifier
16780: FROM pay_element_type_extra_info petei
16781: WHERE petei.element_type_id = p_element_type_id
16782: AND petei.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
16783:
16784: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS

Line 17114: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;

17110: l_user_value pay_user_column_instances_f.value%TYPE;
17111: l_error_msg VARCHAR2(2000);
17112:
17113: -- RET1.a : new variables to store element_type_extra_info_id
17114: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;
17115: l_retval NUMBER;
17116: l_allow_code VARCHAR2(1);
17117: --
17118: --