The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT claim_type_id, reason_code_id , custom_setup_id
FROM OZF_CLAIM_DEF_RULES
WHERE CLAIM_CLASS = cv_claim_class
AND ( ( SOURCE_OBJECT_CLASS is null AND cv_source_object is null )
OR (SOURCE_OBJECT_CLASS = cv_source_object ) )
AND ENABLED_FLAG = 'Y';
select claim_type_id
from ozf_sys_parameters;
select reason_code_id
from ozf_sys_parameters;
SELECT custom_setup_id
FROM ams_custom_setups_vl
WHERE application_id = 682
AND enabled_flag = 'Y'
AND custom_setup_id = cv_custom_setup_id;
SELECT COUNT(custom_setup_id)
FROM ams_custom_setups_vl
WHERE application_id = 682
AND enabled_flag = 'Y'
AND object_type = 'CLAM'
AND activity_type_code = cv_claim_class;
SELECT custom_setup_id
FROM ams_custom_setups_vl
WHERE application_id = 682
AND enabled_flag = 'Y'
AND object_type = 'CLAM'
AND activity_type_code = cv_claim_class;