DBA Data[Home] [Help]

APPS.PAY_UK_BAL_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 175: from pay_element_entries_f EE

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;