The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT UPPER(icrc.cc_can_prpr_apprv_flag)
FROM IGC_CC_ROUTING_CTRLS icrc
WHERE icrc.org_id = p_org_id
AND icrc.cc_state = p_cc_state
AND icrc.cc_type = p_cc_type;
SELECT meaning
FROM fnd_lookups
WHERE lookup_code = p_cc_state
AND lookup_type = 'IGC_CC_STATE';
SELECT meaning
FROM fnd_lookups
WHERE lookup_code = p_cc_type
AND lookup_type = 'IGC_CC_TYPE';
SELECT name
FROM hr_organization_units
WHERE organization_id = p_org_id;
SELECT cc_encmbrnc_status
INTO l_cc_encumb_status
FROM igc_cc_headers
WHERE cc_header_id = l_cc_header_id;
SELECT cc_num
FROM igc_cc_headers
WHERE cc_header_id = l_cc_header_id;
UPDATE IGC_CC_HEADERS
SET cc_apprvl_status = 'AP'
WHERE cc_header_id = l_cc_header_id;
IGC_CC_ACTIONS_PKG.Insert_Row
( p_api_version => 1.0
, p_init_msg_list => FND_API.G_FALSE
, p_commit => FND_API.G_FALSE
, p_validation_level => FND_API.G_VALID_LEVEL_FULL
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, P_Rowid => l_rowid
, P_CC_Header_Id => p_cc_header_id
, P_CC_Action_Version_Num => p_cc_version_num
, P_CC_Action_Type => 'AP'
, P_CC_Action_State => l_cc_state
, P_CC_Action_Ctrl_Status => p_cc_ctrl_status
, P_CC_Action_Apprvl_Status => p_cc_apprvl_status
, P_CC_Action_Notes => p_cc_notes
, P_Last_Update_Date => sysdate
, P_Last_Updated_By => fnd_global.user_id
, P_Last_Update_Login => fnd_global.login_id
, P_Creation_Date => sysdate
, P_Created_By => fnd_global.user_id
) ;