DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 226: pay_element_entry_values_f eev

222: select eev.screen_entry_value
223: from pay_element_types_f elt,
224: pay_input_values_f ipv,
225: pay_element_entries_f ele,
226: pay_element_entry_values_f eev
227: where trunc(p_pa_request_rec.effective_date) between elt.effective_start_date
228: and elt.effective_end_date
229: and trunc(p_pa_request_rec.effective_date) between ipv.effective_start_date
230: and ipv.effective_end_date

Line 2604: ,pay_element_entry_values_f eev

2600: ,eev.effective_start_date
2601: FROM pay_element_types_f elt
2602: ,pay_input_values_f ipv
2603: ,pay_element_entries_f ele
2604: ,pay_element_entry_values_f eev
2605: WHERE p_effective_date < eev.effective_start_date
2606: AND eev.effective_end_date IS NULL
2607: AND elt.element_type_id = ipv.element_type_id
2608: AND upper(elt.element_name)= upper(p_element_name)