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 FND_LOOKUP_VALUES

Line 18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;

14:
15: -- cache for rates_history function
16: g_business_group_id pay_element_types_f.business_group_id%TYPE;
17: g_legislation_code pay_element_types_f.legislation_code%TYPE;
18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;
19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:
21: -- cache for get_bus_group_id
22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;

15: -- cache for rates_history function
16: g_business_group_id pay_element_types_f.business_group_id%TYPE;
17: g_legislation_code pay_element_types_f.legislation_code%TYPE;
18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;
19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:
21: -- cache for get_bus_group_id
22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;
23: g_cache_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;

215: BEGIN
216: -- cache for rates_history function
217: g_business_group_id := NULL;--pay_element_types_f.business_group_id%TYPE;
218: g_legislation_code := NULL;--pay_element_types_f.business_group_id%TYPE;
219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;
220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:
222: -- cache for get_bus_group_id
223: g_cache_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE;

Line 220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;

216: -- cache for rates_history function
217: g_business_group_id := NULL;--pay_element_types_f.business_group_id%TYPE;
218: g_legislation_code := NULL;--pay_element_types_f.business_group_id%TYPE;
219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;
220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:
222: -- cache for get_bus_group_id
223: g_cache_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE;
224: g_cache_business_group_id := NULL;--per_all_assignments_f.business_group_id%TYPE;

Line 387: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;

383: l_calc_value fnd_lookups.lookup_code%TYPE;
384: l_input_value fnd_lookups.lookup_code%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;

Line 388: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;

384: l_input_value fnd_lookups.lookup_code%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;

Line 926: l_to_time_dimension fnd_lookup_values.lookup_code%TYPE;

922: AND p_date BETWEEN effective_start_date
923: AND effective_end_date;
924:
925: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;
926: l_to_time_dimension fnd_lookup_values.lookup_code%TYPE;
927:
928: BEGIN
929:
930: g_debug := hr_utility.debug_enabled;

Line 2306: l_rate_name fnd_lookup_values.meaning%TYPE;

2302: l_csr_element_set csr_element_set_typ;
2303: this_element csr_element_type_id%ROWTYPE;
2304: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2305: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2306: l_rate_name fnd_lookup_values.meaning%TYPE;
2307: l_rate_code fnd_lookup_values.meaning%TYPE;
2308: l_element_attribution_id NUMBER;
2309: l_element_entry csr_element_entry%ROWTYPE;
2310:

Line 2307: l_rate_code fnd_lookup_values.meaning%TYPE;

2303: this_element csr_element_type_id%ROWTYPE;
2304: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2305: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2306: l_rate_name fnd_lookup_values.meaning%TYPE;
2307: l_rate_code fnd_lookup_values.meaning%TYPE;
2308: l_element_attribution_id NUMBER;
2309: l_element_entry csr_element_entry%ROWTYPE;
2310:
2311: l_fte fnd_lookup_values.lookup_code%TYPE;

Line 2311: l_fte fnd_lookup_values.lookup_code%TYPE;

2307: l_rate_code fnd_lookup_values.meaning%TYPE;
2308: l_element_attribution_id NUMBER;
2309: l_element_entry csr_element_entry%ROWTYPE;
2310:
2311: l_fte fnd_lookup_values.lookup_code%TYPE;
2312: l_service_history fnd_lookup_values.lookup_code%TYPE;
2313: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2314: l_qualifier pay_element_types_f.element_name%type;
2315: l_from_time_dimension fnd_lookups.lookup_code%TYPE;

Line 2312: l_service_history fnd_lookup_values.lookup_code%TYPE;

2308: l_element_attribution_id NUMBER;
2309: l_element_entry csr_element_entry%ROWTYPE;
2310:
2311: l_fte fnd_lookup_values.lookup_code%TYPE;
2312: l_service_history fnd_lookup_values.lookup_code%TYPE;
2313: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2314: l_qualifier pay_element_types_f.element_name%type;
2315: l_from_time_dimension fnd_lookups.lookup_code%TYPE;
2316: l_element_rate NUMBER;

Line 2313: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;

2309: l_element_entry csr_element_entry%ROWTYPE;
2310:
2311: l_fte fnd_lookup_values.lookup_code%TYPE;
2312: l_service_history fnd_lookup_values.lookup_code%TYPE;
2313: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2314: l_qualifier pay_element_types_f.element_name%type;
2315: l_from_time_dimension fnd_lookups.lookup_code%TYPE;
2316: l_element_rate NUMBER;
2317: l_total_rate NUMBER;

Line 2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;

2316: l_element_rate NUMBER;
2317: l_total_rate NUMBER;
2318: l_rate_nc NUMBER;
2319: l_error_mesg_nc fnd_new_messages.message_text%TYPE;
2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;
2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;
2324: l_term_time_yes_no fnd_lookup_values.lookup_code%TYPE;

Line 2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;

2317: l_total_rate NUMBER;
2318: l_rate_nc NUMBER;
2319: l_error_mesg_nc fnd_new_messages.message_text%TYPE;
2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;
2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2322: l_input_value fnd_lookup_values.lookup_code%TYPE;

2318: l_rate_nc NUMBER;
2319: l_error_mesg_nc fnd_new_messages.message_text%TYPE;
2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;
2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;

2319: l_error_mesg_nc fnd_new_messages.message_text%TYPE;
2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;
2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2324: l_term_time_yes_no fnd_lookup_values.lookup_code%TYPE;

2320: l_calc_type fnd_lookup_values.lookup_code%TYPE;
2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2325: l_linked_to_assignment_yn fnd_lookup_values.lookup_code%TYPE;

2321: l_calc_value fnd_lookup_values.lookup_code%TYPE;
2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2326: l_sum_multiple_entries_yn fnd_lookup_values.lookup_code%TYPE;

2322: l_input_value fnd_lookup_values.lookup_code%TYPE;
2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;

Line 2327: l_lookup_input_values_yn fnd_lookup_values.lookup_code%TYPE;

2323: l_check_link_to_assignment_yn fnd_lookup_values.lookup_code%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;