DBA Data[Home] [Help]

APPS.HR_INPUT_VALUES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 312: pay_element_entry_values_f eev

308: from sys.dual
309: where not exists(
310: select 1
311: from pay_element_entries_f ee,
312: pay_element_entry_values_f eev
313: where f_element_link_id = ee.element_link_id
314: and ee.element_entry_id = eev.element_entry_id
315: and eev.input_value_id = f_input_value_id
316: and eev.effective_start_date <= f_val_end_date

Line 333: pay_element_entry_values_f eev

329: from sys.dual
330: where exists(
331: select 1
332: from pay_element_entries_f ee,
333: pay_element_entry_values_f eev
334: where f_element_link_id = ee.element_link_id
335: and ee.element_entry_id = eev.element_entry_id
336: and eev.input_value_id = f_input_value_id
337: and eev.effective_start_date <= f_val_end_date

Line 654: from pay_element_entry_values_f

650: into v_entries_exist_flag
651: from sys.dual
652: where exists
653: (select 1
654: from pay_element_entry_values_f
655: where input_value_id = p_input_value_id
656: and effective_start_date <= p_val_end_date
657: and effective_end_date >= p_val_start_date);
658: --