171: ,p_upload_date date
172: ,p_original_entry_id number
173: ) is
174: select nvl(min(EE.effective_start_date), END_OF_TIME)
175: from pay_element_entries_f EE
176: where EE.assignment_id = p_assignment_id
177: and (EE.element_entry_id = p_original_entry_id or
178: EE.original_entry_id = p_original_entry_id)
179: and EE.effective_start_date <= p_upload_date;