The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mapping_id
FROM pos_supplier_mappings
WHERE supplier_reg_id = p_supplier_reg_id;
SELECT mapping_id
FROM pos_supplier_mappings
WHERE vendor_id = p_vendor_id;
SELECT transaction_id, supplier_update_flag
FROM pos_survey_transactions
WHERE supplier_mapping_id = l_mapping_id
AND survey_transaction_id = p_survey_transaction_id;
l_supplier_update_flag VARCHAR2(1);
FETCH l_transaction_cur INTO l_transaction_id, l_supplier_update_flag;
l_supplier_update_flag := 'Y';
l_supplier_update_flag := 'N';
INSERT INTO pos_survey_transactions
(transaction_id, supplier_mapping_id, survey_transaction_id, created_by,
creation_date, last_updated_by, last_update_date, last_update_login,
respondent_table_name, respondent_id, supplier_update_flag)
VALUES
(pos_survey_transactions_s.NEXTVAL, l_mapping_id, p_survey_transaction_id, fnd_global.user_id,
sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
p_respondent_table_name, p_respondent_id, l_supplier_update_flag);
IF ((l_supplier_update_flag IS NULL OR l_supplier_update_FLAG <> 'Y')
AND (p_respondent_table_name <> 'POS_CONTACT_REQUESTS')) THEN
l_supplier_update_flag := 'N';
l_supplier_update_flag := 'Y';
UPDATE pos_survey_transactions
SET last_updated_by = fnd_global.user_id,
last_update_date = sysdate,
last_update_login = fnd_global.login_id,
respondent_table_name = p_respondent_table_name,
respondent_id = p_respondent_id,
supplier_update_flag = l_supplier_update_flag
WHERE transaction_id = l_transaction_id;