The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ghr_pa_notifications_s.nextval from sys.dual;
,p_action_taken => 'UPDATE_HR_COMPLETE'
,p_par_object_version_number => l_object_version_number
);
select ghr_pa_notifications_s.nextval from sys.dual;
select par.person_id,
par.employee_assignment_id
from ghr_pa_requests par
where par.pa_request_id = p_pa_request_id;
select asg1.assignment_id
from per_all_assignments_f asg1,
per_all_assignments_f asg
where asg.person_id = l_person_id
and asg1.person_id <> l_person_id
and p_effective_date
between asg.effective_start_date and asg.effective_end_date
and asg.assignment_type NOT IN ('A','B')
and asg1.assignment_type NOT IN ('A','B')
and asg1.position_id = asg.position_id
and asg1.effective_start_date
between asg.effective_start_date and asg.effective_end_date;
,p_action_taken => 'UPDATE_HR_COMPLETE'
,p_par_object_version_number => l_object_version_number
);
select pos.business_group_id
from hr_all_positions_f pos -- Venkat
where pos.position_id = p_position_id
and p_effective_date between pos.effective_start_date and
pos.effective_end_date;
select par.noa_family_code,
par.altered_pa_request_id,
par.second_noa_code -- Bug 3451929
from ghr_pa_requests par
where par.pa_request_id = p_pa_request_id;
select par.noa_family_code,
par.first_noa_code,
par.second_noa_code
from ghr_pa_requests par
where par.pa_request_id = p_pa_request_id;
select parei.rei_information4,
parei.rei_information5, -- Bug 3547836
parei.rei_information6, -- Bug 3547836
parei.rei_information10
from ghr_pa_request_extra_info parei
where parei.pa_request_id = p_pa_request_id
and parei.information_type = p_information_type;
select par.from_agency_code,
par.from_agency_desc,
par.agency_code,
par.employee_dept_or_agency,
par.from_office_symbol,
par.to_office_symbol,
par.personnel_office_id
from ghr_pa_requests par
where par.pa_request_id = l_altered_pa_request_id;
end ghr_sf52_post_update;