DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on PAY_ELEMENT_ENTRIES_F

Line 510: ,pay_element_entries_f ele

506: SELECT eev.screen_entry_value
507: ,eev.effective_start_date
508: FROM pay_element_types_f elt
509: ,pay_input_values_f ipv
510: ,pay_element_entries_f ele
511: ,pay_element_entry_values_f eev
512: WHERE p_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date
513: AND p_effective_date BETWEEN ipv.effective_start_date AND ipv.effective_end_date
514: AND p_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date