APPS.HR_ENTRY_DISPLAY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 28: PAY_ELEMENT_ENTRY_VALUES_F_N50 index.

24: History
25: 04-Mar-94 J.S.Hobbs 40.0 Date created.
26: 29-Jun-94 D.C.Harris 40.1 get_input_value_details element entry
27: values select tuned to use
28: PAY_ELEMENT_ENTRY_VALUES_F_N50 index.
29: 25-Feb-99 J. Moyano 115.1 MLS changes. Procedure affected:
30: get_input_value_details.
31: 16-Sep-04 T.Habara 115.2 Added original_entry_name().
32: ============================================================================*/

Line 273: FROM PAY_ELEMENT_ENTRY_VALUES_F HEEV1

269: hr_utility.set_location('hr_entry_display.get_input_value_details', 3);
270: begin
271: SELECT HEEV1.SCREEN_ENTRY_VALUE
272: INTO v_database_format_value
273: FROM PAY_ELEMENT_ENTRY_VALUES_F HEEV1
274: WHERE HEEV1.ELEMENT_ENTRY_ID = p_element_entry_id
275: AND HEEV1.INPUT_VALUE_ID + 0 = v_select_input_value_id
276: AND p_session_date
277: BETWEEN HEEV1.EFFECTIVE_START_DATE AND HEEV1.EFFECTIVE_END_DATE;