The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM per_people_f per
,per_contracts_f con
,fnd_sessions ses
WHERE per.person_id = p_person_id
AND con.person_id = per.person_id
AND ses.session_id = USERENV('sessionid')
AND ses.effective_date BETWEEN per.effective_start_date
AND per.effective_end_date
AND ses.effective_date BETWEEN con.effective_start_date
AND con.effective_end_date;
SELECT grade_structure
,people_group_structure
,job_structure
,position_structure
FROM per_business_groups
WHERE business_group_id = p_business_group_id;
PROCEDURE update_contracts
(p_contract_id IN number
,p_object_version_number IN OUT NOCOPY number
,p_doc_status IN varchar2
,p_doc_status_change_date IN date
,p_exclude_flag IN char)
IS
--
CURSOR c_all_con IS
SELECT contract_id,
effective_start_date,
object_version_number,
person_id,
reference,
type,
status
FROM per_contracts_f
WHERE contract_id = p_contract_id;
SELECT contract_id,
effective_start_date,
object_version_number,
person_id,
reference,
type,
status
FROM per_contracts_f
WHERE contract_id = p_contract_id
AND object_version_number <> p_object_version_number;
hr_contract_api.update_contract
(p_contract_id => l_con.contract_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_person_id => l_con.person_id
,p_reference => l_con.reference
,p_type => l_con.type
,p_status => l_con.status
,p_doc_status => p_doc_status
,p_doc_status_change_date => p_doc_status_change_date
,p_effective_date => l_con.effective_start_date
,p_datetrack_mode => l_dt_mode);
hr_contract_api.update_contract
(p_contract_id => l_con.contract_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_person_id => l_con.person_id
,p_reference => l_con.reference
,p_type => l_con.type
,p_status => l_con.status
,p_doc_status => p_doc_status
,p_doc_status_change_date => p_doc_status_change_date
,p_effective_date => l_con.effective_start_date
,p_datetrack_mode => l_dt_mode);
END update_contracts;