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_RATES_HISTORY_CALC dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 370: FROM pay_element_type_extra_info pei

366: ,pei.eei_information16 column_name_source_type
367: ,pei.eei_information17 column_name_source_name
368: ,pei.eei_information18 row_name_source_type
369: ,pei.eei_information19 row_name_source_name
370: FROM pay_element_type_extra_info pei
371: WHERE pei.element_type_extra_info_id = p_element_type_extra_info_id;
372:
373: l_proc_step NUMBER(20,10):=0;
374: l_proc_name VARCHAR2(61)

Line 389: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

385: l_check_link_to_assignment_yn fnd_lookups.lookup_code%TYPE;
386: l_term_time_yes_no fnd_lookups.lookup_code%TYPE;
387: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
388: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
389: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
390: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
391: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
392: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
393:

Line 390: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;

386: l_term_time_yes_no fnd_lookups.lookup_code%TYPE;
387: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
388: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
389: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
390: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
391: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
392: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
393:
394:

Line 391: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;

387: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
388: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
389: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
390: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
391: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
392: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
393:
394:
395:

Line 392: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;

388: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
389: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
390: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
391: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
392: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
393:
394:
395:
396: BEGIN

Line 2297: FROM pay_element_type_extra_info eei

2293: CURSOR csr_element_attribute_id
2294: (p_element_type_id NUMBER
2295: ) IS
2296: SELECT eei.element_type_extra_info_id
2297: FROM pay_element_type_extra_info eei
2298: WHERE eei.element_type_id = p_element_type_id
2299: AND eei.information_type = 'PQP_UK_ELEMENT_ATTRIBUTION';
2300:
2301:

Line 2328: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

2324: l_term_time_yes_no fnd_lookup_values.lookup_code%TYPE;
2325: l_linked_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;
2326: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2327: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2328: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2329: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2330: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2332:

Line 2329: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;

2325: l_linked_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;
2326: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2327: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2328: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2329: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2330: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2332:
2333: BEGIN

Line 2330: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;

2326: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2327: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2328: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2329: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2330: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2332:
2333: BEGIN
2334:

Line 2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;

2327: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2328: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2329: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2330: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2331: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2332:
2333: BEGIN
2334:
2335: g_debug := hr_utility.debug_enabled;

Line 2458: FROM pay_element_type_extra_info eei

2454: THEN
2455:
2456: OPEN l_csr_element_set FOR
2457: SELECT ele.element_type_id
2458: FROM pay_element_type_extra_info eei
2459: ,pay_element_types_f ele
2460: WHERE eei.information_type = 'PQP_UK_RATE_TYPE'
2461: AND ele.element_type_id = eei.element_type_id
2462: AND p_calculation_date

Line 2835: FROM pay_element_type_extra_info eei

2831: CURSOR csr_element_attribute_id
2832: (p_element_type_id NUMBER
2833: ) IS
2834: SELECT eei.element_type_extra_info_id
2835: FROM pay_element_type_extra_info eei
2836: WHERE eei.element_type_id = p_element_type_id
2837: AND eei.information_type = 'PQP_UK_ELEMENT_ATTRIBUTION';
2838:
2839:

Line 2866: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;

2862: l_term_time_yes_no fnd_lookup_values.lookup_code%TYPE;
2863: l_linked_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;
2864: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2865: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2866: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2867: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2868: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2869: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2870:

Line 2867: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;

2863: l_linked_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;
2864: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2865: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2866: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2867: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2868: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2869: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2870:
2871: BEGIN

Line 2868: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;

2864: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;
2865: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2866: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2867: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2868: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2869: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2870:
2871: BEGIN
2872:

Line 2869: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;

2865: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;
2866: l_column_name_source_type pay_element_type_extra_info.eei_information16%TYPE;
2867: l_column_name_source_name pay_element_type_extra_info.eei_information17%TYPE;
2868: l_row_name_source_type pay_element_type_extra_info.eei_information18%TYPE;
2869: l_row_name_source_name pay_element_type_extra_info.eei_information19%TYPE;
2870:
2871: BEGIN
2872:
2873: g_debug := hr_utility.debug_enabled;

Line 2996: FROM pay_element_type_extra_info eei

2992: THEN
2993:
2994: OPEN l_csr_element_set FOR
2995: SELECT ele.element_type_id
2996: FROM pay_element_type_extra_info eei
2997: ,pay_element_types_f ele
2998: WHERE eei.information_type = 'PQP_UK_RATE_TYPE'
2999: AND ele.element_type_id = eei.element_type_id
3000: AND p_calculation_date