DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 342: pay_element_types_f elt_new

338: SELECT eef_new.element_entry_id,
339: eef_new.object_version_number,
340: eef_new.element_type_id
341: FROM pay_element_entries_f eef_new,
342: pay_element_types_f elt_new
343: WHERE eef_new.assignment_id = p_assignment_id
344: and elt_new.element_type_id = eef_new.element_type_id
345: AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date
346: and eef_new.effective_start_date = trunc(p_effective_date)