The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
batch_line_id
,cost_allocation_keyflex_id
,element_type_id
,assignment_id
,batch_id
,batch_line_status
,assignment_number
,batch_sequence
,concatenated_segments
,effective_date
,element_name
,entry_type
,reason
,segment1
,segment2
,segment3
,segment4
,segment5
,segment6
,segment7
,segment8
,segment9
,segment10
,segment11
,segment12
,segment13
,segment14
,segment15
,segment16
,segment17
,segment18
,segment19
,segment20
,segment21
,segment22
,segment23
,segment24
,segment25
,segment26
,segment27
,segment28
,segment29
,segment30
,value_1
,value_2
,value_3
,value_4
,value_5
,value_6
,value_7
,value_8
,value_9
,value_10
,value_11
,value_12
,value_13
,value_14
,value_15
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,entry_information_category
,entry_information1
,entry_information2
,entry_information3
,entry_information4
,entry_information5
,entry_information6
,entry_information7
,entry_information8
,entry_information9
,entry_information10
,entry_information11
,entry_information12
,entry_information13
,entry_information14
,entry_information15
,entry_information16
,entry_information17
,entry_information18
,entry_information19
,entry_information20
,entry_information21
,entry_information22
,entry_information23
,entry_information24
,entry_information25
,entry_information26
,entry_information27
,entry_information28
,entry_information29
,entry_information30
,date_earned
,personal_payment_method_id
,subpriority
,effective_start_date
,effective_end_date
,object_version_number
from pay_batch_lines
where batch_line_id = p_batch_line_id;
select
batch_line_id
,cost_allocation_keyflex_id
,element_type_id
,assignment_id
,batch_id
,batch_line_status
,assignment_number
,batch_sequence
,concatenated_segments
,effective_date
,element_name
,entry_type
,reason
,segment1
,segment2
,segment3
,segment4
,segment5
,segment6
,segment7
,segment8
,segment9
,segment10
,segment11
,segment12
,segment13
,segment14
,segment15
,segment16
,segment17
,segment18
,segment19
,segment20
,segment21
,segment22
,segment23
,segment24
,segment25
,segment26
,segment27
,segment28
,segment29
,segment30
,value_1
,value_2
,value_3
,value_4
,value_5
,value_6
,value_7
,value_8
,value_9
,value_10
,value_11
,value_12
,value_13
,value_14
,value_15
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,entry_information_category
,entry_information1
,entry_information2
,entry_information3
,entry_information4
,entry_information5
,entry_information6
,entry_information7
,entry_information8
,entry_information9
,entry_information10
,entry_information11
,entry_information12
,entry_information13
,entry_information14
,entry_information15
,entry_information16
,entry_information17
,entry_information18
,entry_information19
,entry_information20
,entry_information21
,entry_information22
,entry_information23
,entry_information24
,entry_information25
,entry_information26
,entry_information27
,entry_information28
,entry_information29
,entry_information30
,date_earned
,personal_payment_method_id
,subpriority
,effective_start_date
,effective_end_date
,object_version_number
from pay_batch_lines
where batch_line_id = p_batch_line_id
for update nowait;
select pbh.business_group_id
from pay_batch_headers pbh
where pbh.batch_id = c_batch_id;
select cost_allocation_structure
from per_business_groups
where business_group_id= c_business_group_id;
select pbl.batch_id
from pay_batch_lines pbl
where pbl.batch_line_id = p_batch_line_id;
select concatenated_segments
from pay_cost_allocation_keyflex
where cost_allocation_keyflex_id = c_ccid;
if (p_dml_mode='UPDATE') then
open csr_batch_id(p_batch_line_id);
elsif (p_dml_mode='INSERT') then
l_batch_id := p_batch_id;
if p_dml_mode = 'UPDATE' then
l_ccid :=
hr_entry.maintain_cost_keyflex(
p_cost_keyflex_structure => l_id_flex_num,
p_cost_allocation_keyflex_id => l_ccid,
p_concatenated_segments => NULL,
p_summary_flag =>'N',
p_start_date_active => NULL,
p_end_date_active => NULL,
p_segment1 =>p_segment1,
p_segment2 =>p_segment2,
p_segment3 =>p_segment3,
p_segment4 =>p_segment4,
p_segment5 =>p_segment5,
p_segment6 =>p_segment6,
p_segment7 =>p_segment7,
p_segment8 =>p_segment8,
p_segment9 =>p_segment9,
p_segment10 =>p_segment10,
p_segment11 =>p_segment11,
p_segment12 =>p_segment12,
p_segment13 =>p_segment13,
p_segment14 =>p_segment14,
p_segment15 =>p_segment15,
p_segment16 =>p_segment16,
p_segment17 =>p_segment17,
p_segment18 =>p_segment18,
p_segment19 =>p_segment19,
p_segment20 =>p_segment20,
p_segment21 =>p_segment21,
p_segment22 =>p_segment22,
p_segment23 =>p_segment23,
p_segment24 =>p_segment24,
p_segment25 =>p_segment25,
p_segment26 =>p_segment26,
p_segment27 =>p_segment27,
p_segment28 =>p_segment28,
p_segment29 =>p_segment29,
p_segment30 =>p_segment30);
elsif p_dml_mode = 'INSERT' then
--
-- insert flexfield segment
--
l_ccid :=
hr_entry.maintain_cost_keyflex(
p_cost_keyflex_structure => l_id_flex_num,
p_cost_allocation_keyflex_id => l_ccid,
p_concatenated_segments => NULL,
p_summary_flag =>'N',
p_start_date_active => NULL,
p_end_date_active => NULL,
p_segment1 =>p_segment1,
p_segment2 =>p_segment2,
p_segment3 =>p_segment3,
p_segment4 =>p_segment4,
p_segment5 =>p_segment5,
p_segment6 =>p_segment6,
p_segment7 =>p_segment7,
p_segment8 =>p_segment8,
p_segment9 =>p_segment9,
p_segment10 =>p_segment10,
p_segment11 =>p_segment11,
p_segment12 =>p_segment12,
p_segment13 =>p_segment13,
p_segment14 =>p_segment14,
p_segment15 =>p_segment15,
p_segment16 =>p_segment16,
p_segment17 =>p_segment17,
p_segment18 =>p_segment18,
p_segment19 =>p_segment19,
p_segment20 =>p_segment20,
p_segment21 =>p_segment21,
p_segment22 =>p_segment22,
p_segment23 =>p_segment23,
p_segment24 =>p_segment24,
p_segment25 =>p_segment25,
p_segment26 =>p_segment26,
p_segment27 =>p_segment27,
p_segment28 =>p_segment28,
p_segment29 =>p_segment29,
p_segment30 =>p_segment30);
select segment1,segment2,segment3,segment4,segment5,segment6,segment7,segment8,segment9,
segment10,segment11,segment12,segment13,segment14,segment15,segment16,segment17,
segment18,segment19,segment20,segment21,segment22,segment23,segment24,segment25,
segment26,segment27,segment28,segment29,segment30
from pay_cost_allocation_keyflex
where cost_allocation_keyflex_id = c_ccid;