APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on PAY_INPUT_VALUES_F

Line 59: from pay_input_values_f iv

55: ,p_effective_date date
56: ,p_input_name varchar2)
57: is
58: select eev.screen_entry_value
59: from pay_input_values_f iv
60: ,pay_element_entry_values_f eev
61: where eev.element_entry_id = p_element_entry_id
62: and p_effective_date between eev.effective_start_date
63: and eev.effective_end_date

Line 78: ,pay_input_values_F piv

74: element_name
75: from pay_element_entries_f pee
76: ,pay_element_links_f pef
77: ,pay_element_types_f pet
78: ,pay_input_values_F piv
79: ,per_absence_attendance_types paa
80: where pee.element_link_id = pef.element_link_id
81: and pef.element_type_id = pet.element_type_id
82: and pet.element_type_id = piv.element_type_id

Line 268: from pay_element_entry_values_f peev,pay_input_values_f piv

264: cursor get_element_entry_value_id(p_element_entry_id number
265: ,p_input_name varchar2)
266: is
267: select peev.element_entry_value_id
268: from pay_element_entry_values_f peev,pay_input_values_f piv
269: where peev.element_entry_id = p_element_entry_id
270: and piv.name = p_input_name
271: and peev.input_value_id = piv.input_value_id;
272: