DBA Data[Home] [Help]

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