DBA Data[Home] [Help]

APPS.PAY_IE_BAL_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 235: from pay_element_entries_f EE

231: ,p_upload_date date
232: ,p_original_entry_id number
233: ) is
234: select nvl(min(EE.effective_start_date), END_OF_TIME)
235: from pay_element_entries_f EE
236: where EE.assignment_id = p_assignment_id
237: and (EE.element_entry_id = p_original_entry_id or
238: EE.original_entry_id = p_original_entry_id)
239: and EE.effective_start_date <= p_upload_date;