DBA Data[Home] [Help]

APPS.PAY_NL_BAL_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 158: from pay_element_entries_f EE

154: ,p_upload_date date
155: ,p_original_entry_id number
156: ) is
157: select nvl(min(EE.effective_start_date), END_OF_TIME)
158: from pay_element_entries_f EE
159: where EE.assignment_id = p_assignment_id
160: and (EE.element_entry_id = p_original_entry_id or
161: EE.original_entry_id = p_original_entry_id)
162: and EE.effective_start_date <= p_upload_date;