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 2304: ,pay_element_entry_values_f eev

2300: ,eev.effective_start_date
2301: FROM pay_element_types_f elt
2302: ,pay_input_values_f ipv
2303: ,pay_element_entries_f ele
2304: ,pay_element_entry_values_f eev
2305: WHERE p_effective_date < eev.effective_start_date
2306: AND eev.effective_end_date IS NULL
2307: AND elt.element_type_id = ipv.element_type_id
2308: AND upper(elt.element_name)= upper(p_element_name)