APPS.HR_INPUT_VALUES dependencies on PAY_ELEMENT_ENTRIES_F

Line 91: pay_element_entries_f ee

87: from sys.dual
88: where exists
89: (select 1
90: from pay_element_links_f el,
91: pay_element_entries_f ee
92: where p_element_type_id = el.element_type_id
93: and el.element_link_id = ee.element_link_id
94: and ee.effective_end_date >= p_val_start_date
95: and ee.effective_start_date <= p_val_end_date);

Line 311: from pay_element_entries_f ee,

307: into null_entries_found
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

Line 332: from pay_element_entries_f ee,

328: into null_entries_found
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

Line 975: pay_element_entries_f ee

971: from sys.dual
972: where exists
973: (select 1
974: from pay_element_links_f el,
975: pay_element_entries_f ee
976: where p_element_type_id = el.element_type_id
977: and el.element_link_id = ee.element_link_id
978: and el.effective_start_date <= p_val_end_date
979: and el.effective_end_date >= p_val_start_date