The following lines contain the word 'select', 'insert', 'update' or 'delete':
select object_version_number
from per_all_positions
where position_id = p_position_id;
l_program_update_date date;
select rowid
, position_id
, effective_start_date
, effective_end_date
, availability_status_id
, business_group_id
, entry_step_id
, job_id
, location_id
, organization_id
, pay_freq_payroll_id
, position_definition_id
, position_transaction_id
, prior_position_id
, relief_position_id
, successor_position_id
, supervisor_position_id
, amendment_date
, amendment_recommendation
, amendment_ref_number
, bargaining_unit_cd
, comments
, current_job_prop_end_date
, current_org_prop_end_date
, avail_status_prop_end_date
, date_effective
, hr_general.get_position_date_end(position_id) date_end
, earliest_hire_date
, fill_by_date
, frequency
, fte
, max_persons
, hr_general.decode_position_latest_name(position_id) name
, overlap_period
, overlap_unit_cd
, pay_term_end_day_cd
, pay_term_end_month_cd
, permanent_temporary_flag
, permit_recruitment_flag
, position_type
, posting_description
, probation_period
, probation_period_unit_cd
, replacement_required_flag
, review_flag
, seasonal_flag
, security_requirements
, status
, term_start_day_cd
, term_start_month_cd
, time_normal_finish
, time_normal_start
, update_source_cd
, working_hours
, works_council_approval_flag
, work_period_type_cd
, work_term_end_day_cd
, work_term_end_month_cd
, 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
, information_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
, attribute_category
, request_id
, program_application_id
, program_id
, program_update_date
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, object_version_number
, entry_grade_id
, entry_grade_rule_id
, proposed_fte_for_layoff
, proposed_date_for_layoff
, pay_basis_id
, supervisor_id
, copied_to_old_table_flag
from hr_all_positions_f
where (copied_to_old_table_flag <> 'Y'
or copied_to_old_table_flag is null )
--and effective_start_date <= p_refresh_date
and position_id = p_position_id
order by position_id, effective_start_date desc;
select rowid
, position_id
, effective_start_date
, effective_end_date
, availability_status_id
, business_group_id
, entry_step_id
, job_id
, location_id
, organization_id
, pay_freq_payroll_id
, position_definition_id
, position_transaction_id
, prior_position_id
, relief_position_id
, successor_position_id
, supervisor_position_id
, amendment_date
, amendment_recommendation
, amendment_ref_number
, bargaining_unit_cd
, comments
, current_job_prop_end_date
, current_org_prop_end_date
, avail_status_prop_end_date
, date_effective
, hr_general.get_position_date_end(position_id) date_end
, earliest_hire_date
, fill_by_date
, frequency
, fte
, max_persons
, hr_general.decode_position_latest_name(position_id) name
, overlap_period
, overlap_unit_cd
, pay_term_end_day_cd
, pay_term_end_month_cd
, permanent_temporary_flag
, permit_recruitment_flag
, position_type
, posting_description
, probation_period
, probation_period_unit_cd
, replacement_required_flag
, review_flag
, seasonal_flag
, security_requirements
, status
, term_start_day_cd
, term_start_month_cd
, time_normal_finish
, time_normal_start
, update_source_cd
, working_hours
, works_council_approval_flag
, work_period_type_cd
, work_term_end_day_cd
, work_term_end_month_cd
, 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
, information_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
, attribute_category
, request_id
, program_application_id
, program_id
, program_update_date
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, object_version_number
, entry_grade_id
, entry_grade_rule_id
, proposed_fte_for_layoff
, proposed_date_for_layoff
, pay_basis_id
, supervisor_id
, copied_to_old_table_flag
from hr_all_positions_f
where (copied_to_old_table_flag <> 'Y'
or copied_to_old_table_flag is null )
--and effective_start_date <= p_refresh_date
order by position_id, effective_start_date desc;
hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);
select object_version_number
from per_all_positions p
where position_id = p_position_id
and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;
update per_all_positions
set date_end = hr_general.get_position_date_end(position_id)
where position_id = p_position_id;