The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
personal_payment_method_id,
effective_start_date,
effective_end_date,
business_group_id,
external_account_id,
assignment_id,
run_type_id,
org_payment_method_id,
amount,
comment_id,
null,
percentage,
priority,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
object_version_number,
payee_type,
payee_id,
ppm_information_category,
ppm_information1,
ppm_information2,
ppm_information3,
ppm_information4,
ppm_information5,
ppm_information6,
ppm_information7,
ppm_information8,
ppm_information9,
ppm_information10,
ppm_information11,
ppm_information12,
ppm_information13,
ppm_information14,
ppm_information15,
ppm_information16,
ppm_information17,
ppm_information18,
ppm_information19,
ppm_information20,
ppm_information21,
ppm_information22,
ppm_information23,
ppm_information24,
ppm_information25,
ppm_information26,
ppm_information27,
ppm_information28,
ppm_information29,
ppm_information30
from pay_personal_payment_methods_f
where personal_payment_method_id = p_personal_payment_method_id
and p_effective_date
between effective_start_date and effective_end_date;
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.org_payment_method_id,
t.assignment_id
from pay_personal_payment_methods_f t
where t.personal_payment_method_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);
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);
update pay_personal_payment_methods_f t
set t.effective_end_date = p_new_effective_end_date,
t.object_version_number = l_object_version_number
where t.personal_payment_method_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
personal_payment_method_id,
effective_start_date,
effective_end_date,
business_group_id,
external_account_id,
assignment_id,
run_type_id,
org_payment_method_id,
amount,
comment_id,
null,
percentage,
priority,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
object_version_number,
payee_type,
payee_id,
ppm_information_category,
ppm_information1,
ppm_information2,
ppm_information3,
ppm_information4,
ppm_information5,
ppm_information6,
ppm_information7,
ppm_information8,
ppm_information9,
ppm_information10,
ppm_information11,
ppm_information12,
ppm_information13,
ppm_information14,
ppm_information15,
ppm_information16,
ppm_information17,
ppm_information18,
ppm_information19,
ppm_information20,
ppm_information21,
ppm_information22,
ppm_information23,
ppm_information24,
ppm_information25,
ppm_information26,
ppm_information27,
ppm_information28,
ppm_information29,
ppm_information30
from pay_personal_payment_methods_f
where personal_payment_method_id = p_personal_payment_method_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;
select hc.comment_text
from hr_comments hc
where hc.comment_id = pay_ppm_shd.g_old_rec.comment_id;
If (p_datetrack_mode <> 'INSERT') then
--
-- It is necessary to lock PAY_ORG_PAY_METHOD_USAGES_F for datetrack modes
-- that extend a PPM because return_effective_end_date needs to be ensure that
-- the usages are still valid when the record is valid. PAY_ORG_PAY_METHOD_USAGES_F
-- comes before PAY_PERSONAL_PAYMENT_METHODS_F in the HRMS lock ladder.
--
--
if p_datetrack_mode = 'DELETE_NEXT_CHANGE' or p_datetrack_mode = 'FUTURE_CHANGE'
then
l_lock_table := 'pay_org_pay_method_usages_f';
(p_datetrack_mode = 'UPDATE' or
p_datetrack_mode = 'CORRECTION' or
p_datetrack_mode = 'UPDATE_OVERRIDE' or
p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
Open C_Sel3;