The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1 FROM dual
WHERE EXISTS(
SELECT site_party_id
FROM rrs_sites_b
WHERE site_type_code = c_site_type
AND site_party_id = c_party_id);
UPDATE rrs_sites_b
SET site_party_id = p_to_fk_id,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.user_id
WHERE site_party_id = p_from_fk_id;
Cursor get_sites_for_update(c_party_id IN NUMBER) IS
SELECT 1 FROM DUAL
WHERE EXISTS(
SELECT le_party_id
FROM rrs_sites_b
WHERE le_party_id = c_party_id);
OPEN get_sites_for_update(p_from_fk_id);
FETCH get_sites_for_update INTO l_from_site_num;
IF ( get_sites_for_update%FOUND ) THEN
UPDATE rrs_sites_b
SET le_party_id = p_to_fk_id,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.user_id
WHERE le_party_id = p_from_fk_id;
CLOSE get_sites_for_update;