APPS.HRFASTANSWERS dependencies on PAY_ELEMENT_ENTRIES_F

Line 440: pay_element_entries_f ee

436: /*Bug 3658456: Rewritten the SQL to get l_hours_worked*/
437: select sum(ev.screen_entry_value)
438: into l_hours_worked
439: from pay_element_entry_values_f ev,
440: pay_element_entries_f ee
441: where ev.element_entry_id = ee.element_entry_id and
442: ee.assignment_id = p_assign_id and
443: (ev.input_value_id,ee.element_link_id) in
444: ( select iv.input_value_id,el.element_link_id

Line 459: pay_element_entries_f ee2

455: ) and
456: p_earned_date between ee.effective_start_date and ee.effective_end_date and
457: exists (select null
458: from pay_element_entry_values_f ev2,
459: pay_element_entries_f ee2
460: where ev2.element_entry_id = ee2.element_entry_id and
461: ee2.assignment_id = p_assign_id and
462: ev2.screen_entry_value = to_char(p_multiple) and
463: ev2.element_entry_id = ev.element_entry_id and