APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 59: ,pay_element_entry_values_f eev

55: ,liv.default_value
56: FROM pay_element_entries_f ele
57: ,pay_element_links_f lnk
58: ,pay_link_input_values_f liv
59: ,pay_element_entry_values_f eev
60: WHERE ele.assignment_id = p_assignment_id
61: AND ele.entry_type = 'E'
62: AND p_effective_date
63: BETWEEN ele.effective_start_date

Line 115: ,pay_element_entry_values_f eev

111: ,liv.default_value
112: FROM pay_element_entries_f ele
113: ,pay_element_links_f lnk
114: ,pay_link_input_values_f liv
115: ,pay_element_entry_values_f eev
116: WHERE ele.element_entry_id = p_element_entry_id
117: AND p_effective_date
118: BETWEEN ele.effective_start_date
119: AND ele.effective_end_date

Line 1275: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;

1271: l_input_value_default_txt pay_input_values_f.default_value%TYPE;
1272: l_input_value_lookup_type pay_input_values_f.lookup_type%TYPE;
1273: l_input_value_value_set_id pay_input_values_f.value_set_id%TYPE;
1274: l_link_default_value_txt pay_link_input_values_f.default_value%TYPE;
1275: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;
1276: l_factor_or_percentage NUMBER;
1277: l_modified_rate NUMBER;
1278:
1279: BEGIN

Line 1416: ) RETURN pay_element_entry_values_f.screen_entry_value%TYPE

1412: ,p_element_entry_id IN NUMBER
1413: ,p_input_value_name IN VARCHAR2
1414: ,p_effective_date IN DATE
1415: ,p_lookup_input_values_yn IN VARCHAR2
1416: ) RETURN pay_element_entry_values_f.screen_entry_value%TYPE
1417: IS
1418:
1419: l_proc_step NUMBER(20,10);
1420: l_proc_name VARCHAR2(61):=

Line 1428: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;

1424: l_input_value_default_txt pay_input_values_f.default_value%TYPE;
1425: l_input_value_lookup_type pay_input_values_f.lookup_type%TYPE;
1426: l_input_value_value_set_id pay_input_values_f.value_set_id%TYPE;
1427: l_link_default_value_txt pay_link_input_values_f.default_value%TYPE;
1428: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;
1429:
1430: BEGIN
1431:
1432: debug_enter(l_proc_name);

Line 1651: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;

1647: l_input_value_default_txt pay_input_values_f.default_value%TYPE;
1648: l_input_value_lookup_type pay_input_values_f.lookup_type%TYPE;
1649: l_input_value_value_set_id pay_input_values_f.value_set_id%TYPE;
1650: l_link_default_value_txt pay_link_input_values_f.default_value%TYPE;
1651: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;
1652: l_row_name pay_user_rows_f.ROW_LOW_RANGE_OR_NAME%TYPE;
1653: l_column_name pay_user_columns.USER_COLUMN_NAME%TYPE;
1654: l_element_entry csr_element_entry%ROWTYPE;
1655: --