DBA Data[Home] [Help]

APPS.PAY_ES_BAL_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 111: FROM pay_element_entries_f EE

107: CURSOR csr_ele_itd_start(p_assignment_id NUMBER
108: ,p_upload_date DATE
109: ,p_original_entry_id NUMBER) IS
110: SELECT nvl(min(EE.effective_start_date), end_of_time)
111: FROM pay_element_entries_f EE
112: WHERE EE.assignment_id = p_assignment_id
113: AND (EE.element_entry_id = p_original_entry_id OR
114: EE.original_entry_id = p_original_entry_id)
115: AND EE.effective_start_date <= p_upload_date;