The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT registrant_party_Id,registrant_contact_Id,event_offer_Id
FROM ams_event_registrations_v
WHERE confirmation_code = x_eventConfCode;
SELECT campaign_id
FROM ams_campaigns_all_b
WHERE translate(inbound_phone_no,'0123456789()/\-. ','0123456789')=x_inbound_phone
AND status_code ='ACTIVE';
SELECT campaign_id
FROM ams_p_campaigns_v
WHERE source_code = x_campaignCode
AND status_code ='ACTIVE';
SELECT quote_header_id,party_id,cust_account_id,l_contactid
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = x_collateralReqNum;
SELECT p.party_id, p.object_id
FROM JTF_PARTIES_V p, jtf_party_relationships_v rel
WHERE p.party_number = x_contactNum ;
SELECT party_id
FROM jtf_parties_v
WHERE party_number = x_custnum;
SELECT party_id
FROM hz_cust_accounts
WHERE account_number = x_account_num;
SELECT party_id, party_type
FROM JTF_CONTACT_POINTS_V
WHERE phone_number = x_phonenumber ;
SELECT party_id, party_type
FROM JTF_CONTACT_POINTS_V
WHERE AREA_CODE = x_AreaCode and PHONE_NUMBER = x_phonenumber;
SELECT object_id, subject_id from
HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid
AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F';
insert into ast_uwq_params values ('handleOTSBound Called ');
insert into ast_uwq_params values ('handleOTSBound exit : Action Name: '
|| p_action_Name || ' Action Type : '
|| to_char(p_action_Type) || ' Action Param: '
|| p_action_Param );
SELECT customer_id
INTO l_nm_PARTY_ID
from jtf_tasks_b
WHERE task_id=l_Task_ID;