DBA Data[Home] [Help]

APPS.HR_NZ_ELEMENT_ENTRY_HOOK dependencies on PAY_INPUT_VALUES_F

Line 54: from pay_input_values_f iv

50: cursor c_input_value (p_element_entry_id number
51: ,p_effective_date date
52: ,p_input_name varchar2) is
53: select eev.screen_entry_value
54: from pay_input_values_f iv
55: , pay_element_entry_values_f eev
56: where eev.element_entry_id = p_element_entry_id
57: and p_effective_date between eev.effective_start_date
58: and eev.effective_end_date

Line 74: , pay_input_values_F piv

70: from
71: pay_element_entries_f pee
72: , pay_element_links_f pef
73: , pay_element_types_f pet
74: , pay_input_values_F piv
75: , per_absence_attendance_types paa
76: where pee.element_link_id= pef.element_link_id
77: and pef.element_type_id = pet.element_type_id
78: and pet.element_type_id = piv.element_type_id