[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
assignment_acco_id
,effective_start_date
,effective_end_date
,business_group_id
,assignment_id
,accommodation_given
,temporary_assignment
,accommodation_id
,acceptance_date
,moving_date
,refusal_date
,comments
,indemnity_entitlement
,indemnity_amount
,type_of_payment
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,reason_for_no_acco
,indemnity_currency
from pqh_assign_accommodations_f
where assignment_acco_id = p_assignment_acco_id
and p_effective_date
between effective_start_date and effective_end_date;
,p_update out nocopy boolean
,p_update_override out nocopy boolean
,p_update_change_insert out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_upd_modes';
,p_update => p_update
,p_update_override => p_update_override
,p_update_change_insert => p_update_change_insert
);
,p_delete out nocopy boolean
,p_future_change out nocopy boolean
,p_delete_next_change out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_del_modes';
select
t.accommodation_id
from pqh_assign_accommodations_f t
where t.assignment_acco_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
,p_delete => p_delete
,p_future_change => p_future_change
,p_delete_next_change => p_delete_next_change
);
update pqh_assign_accommodations_f t
set t.effective_end_date = p_new_effective_end_date
, t.object_version_number = l_object_version_number
where t.assignment_acco_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
assignment_acco_id
,effective_start_date
,effective_end_date
,business_group_id
,assignment_id
,accommodation_given
,temporary_assignment
,accommodation_id
,acceptance_date
,moving_date
,refusal_date
,comments
,indemnity_entitlement
,indemnity_amount
,type_of_payment
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
,reason_for_no_acco
,indemnity_currency
from pqh_assign_accommodations_f
where assignment_acco_id = p_assignment_acco_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;
If (p_datetrack_mode <> hr_api.g_insert) then
--
-- We must select and lock the current row.
--
Open C_Sel1;