APPS.HR_ENTRY_DISPLAY dependencies on PAY_INPUT_VALUES_F

Line 125: FROM PAY_INPUT_VALUES_F IV

121: -- value definition in the correct order a row at a time.
122: begin
123: SELECT COUNT(*)
124: INTO p_number_of_input_values
125: FROM PAY_INPUT_VALUES_F IV
126: WHERE IV.ELEMENT_TYPE_ID = p_element_type_id
127: AND p_session_date
128: BETWEEN IV.EFFECTIVE_START_DATE AND IV.EFFECTIVE_END_DATE;
129: end;

Line 212: FROM PAY_INPUT_VALUES_F_TL HIV1_TL,

208: p_warning_or_error,
209: v_hot_default_flag,
210: v_lookup_type,
211: p_formula_id
212: FROM PAY_INPUT_VALUES_F_TL HIV1_TL,
213: PAY_INPUT_VALUES_F HIV1,
214: PAY_LINK_INPUT_VALUES_F HLIV1
215: WHERE HIV1_TL.INPUT_VALUE_ID = HIV1.INPUT_VALUE_ID
216: and userenv('LANG') = HIV1_TL.language

Line 213: PAY_INPUT_VALUES_F HIV1,

209: v_hot_default_flag,
210: v_lookup_type,
211: p_formula_id
212: FROM PAY_INPUT_VALUES_F_TL HIV1_TL,
213: PAY_INPUT_VALUES_F HIV1,
214: PAY_LINK_INPUT_VALUES_F HLIV1
215: WHERE HIV1_TL.INPUT_VALUE_ID = HIV1.INPUT_VALUE_ID
216: and userenv('LANG') = HIV1_TL.language
217: AND p_session_date

Line 224: FROM PAY_INPUT_VALUES_F IV1

220: AND HLIV1.INPUT_VALUE_ID = HIV1.INPUT_VALUE_ID
221: AND HLIV1.ELEMENT_LINK_ID = p_element_link_id
222: AND HIV1.ROWID =
223: (SELECT MIN(IV1.ROWID)
224: FROM PAY_INPUT_VALUES_F IV1
225: WHERE IV1.ELEMENT_TYPE_ID = p_element_type_id
226: AND p_session_date
227: BETWEEN IV1.EFFECTIVE_START_DATE
228: AND IV1.EFFECTIVE_END_DATE

Line 238: FROM PAY_INPUT_VALUES_F IV2

234: NVL(p_input_value_id5,0),
235: NVL(p_input_value_id6,0))
236: AND IV1.DISPLAY_SEQUENCE =
237: (SELECT MIN(IV2.DISPLAY_SEQUENCE)
238: FROM PAY_INPUT_VALUES_F IV2
239: WHERE IV2.ELEMENT_TYPE_ID = p_element_type_id
240: AND p_session_date
241: BETWEEN IV2.EFFECTIVE_START_DATE
242: AND IV2.EFFECTIVE_END_DATE