DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 3654: from pay_element_entries_f EE

3650: ,p_assignment_id number
3651: ,p_original_entry_id number
3652: ) is
3653: select EE.element_entry_id
3654: from pay_element_entries_f EE
3655: where EE.assignment_id = p_assignment_id
3656: and EE.entry_type = 'E'
3657: and EE.effective_start_date <= p_upload_date
3658: and EE.element_entry_id = p_original_entry_id

Line 3662: from pay_element_entries_f EE

3658: and EE.element_entry_id = p_original_entry_id
3659: and EE.original_entry_id is null
3660: union all
3661: select EE.element_entry_id
3662: from pay_element_entries_f EE
3663: where EE.assignment_id = p_assignment_id
3664: and EE.entry_type = 'E'
3665: and EE.effective_start_date <= p_upload_date
3666: and EE.original_entry_id = p_original_entry_id;