DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PAY_INPUT_VALUES_F

Line 224: pay_input_values_f ipv,

220:
221: CURSOR check_for_supervisory IS
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

Line 2302: ,pay_input_values_f ipv

2298: IS
2299: SELECT eev.screen_entry_value
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