DBA Data[Home] [Help]

APPS.PQP_RATES_HISTORY_CALC dependencies on FND_LOOKUPS

Line 377: l_service_history fnd_lookups.lookup_code%TYPE;

373: l_proc_step NUMBER(20,10):=0;
374: l_proc_name VARCHAR2(61)
375: := g_package_name || 'get_element_attributes';
376:
377: l_service_history fnd_lookups.lookup_code%TYPE;
378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;

Line 378: l_fte fnd_lookups.lookup_code%TYPE;

374: l_proc_name VARCHAR2(61)
375: := g_package_name || 'get_element_attributes';
376:
377: l_service_history fnd_lookups.lookup_code%TYPE;
378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.lookup_code%TYPE;

Line 379: l_pay_source_value fnd_lookups.lookup_code%TYPE;

375: := g_package_name || 'get_element_attributes';
376:
377: l_service_history fnd_lookups.lookup_code%TYPE;
378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.lookup_code%TYPE;
383: l_calc_value fnd_lookups.lookup_code%TYPE;

Line 381: l_from_time_dim fnd_lookups.lookup_code%TYPE;

377: l_service_history fnd_lookups.lookup_code%TYPE;
378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.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;

Line 382: l_calc_type fnd_lookups.lookup_code%TYPE;

378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.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;

Line 383: l_calc_value fnd_lookups.lookup_code%TYPE;

379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.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;

Line 384: l_input_value fnd_lookups.lookup_code%TYPE;

380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.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;

Line 385: l_check_link_to_assignment_yn fnd_lookups.lookup_code%TYPE;

381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.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;

Line 386: l_term_time_yes_no fnd_lookups.lookup_code%TYPE;

382: l_calc_type fnd_lookups.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;

Line 2315: l_from_time_dimension fnd_lookups.lookup_code%TYPE;

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;
2318: l_rate_nc NUMBER;
2319: l_error_mesg_nc fnd_new_messages.message_text%TYPE;

Line 2853: l_from_time_dimension fnd_lookups.lookup_code%TYPE;

2849: l_fte fnd_lookup_values.lookup_code%TYPE;
2850: l_service_history fnd_lookup_values.lookup_code%TYPE;
2851: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2852: l_qualifier pay_element_types_f.element_name%type;
2853: l_from_time_dimension fnd_lookups.lookup_code%TYPE;
2854: l_element_rate NUMBER;
2855: l_total_rate NUMBER;
2856: l_rate_nc NUMBER;
2857: l_error_mesg_nc fnd_new_messages.message_text%TYPE;