The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT CBR.Flat_Rate,
CBR.Percent_Rate
FROM CS_COV_BILL_RATES CBR,
CS_COVERAGE_TXN_GROUPS CTG,
CS_COV_BILLING_TYPES CBT,
CS_TXN_BILLING_TYPES TBT,
CS_LOOKUPS LKT
WHERE CTG.Coverage_id = l_coverage_id
AND CTG.Business_Process_Id = p_business_process_id
AND CTG.Coverage_Txn_Group_Id = CBT.Coverage_Txn_Group_Id
AND TBT.Txn_Billing_Type_Id = CBT.Txn_Billing_Type_Id
AND TBT.Billing_Type = 'L'
AND CBR.Coverage_Billing_Type_Id = CBT.Coverage_Billing_Type_Id
AND CBR.Unit_of_Measure_Code = p_unit_of_measure_code
AND CBR.Rate_Type_Code = p_bill_rate_code
AND LKT.Lookup_Code = CBR.Rate_Type_Code
AND LKT.Lookup_Type = 'BILLING_RATE';
SELECT CBR.Flat_Rate,
CBR.Percent_Rate
FROM CS_COV_BILL_RATES CBR,
CS_COVERAGE_TXN_GROUPS CTG,
CS_COV_BILLING_TYPES CBT,
CS_TXN_BILLING_TYPES TBT,
CS_LOOKUPS LKT
WHERE CTG.Coverage_id = l_coverage_id
AND CTG.Business_Process_Id = p_business_process_id
AND CTG.Coverage_Txn_Group_Id = CBT.Coverage_Txn_Group_Id
AND TBT.Txn_Billing_Type_Id = CBT.Txn_Billing_Type_Id
AND TBT.Billing_Type = 'L'
AND CBR.Coverage_Billing_Type_Id = CBT.Coverage_Billing_Type_Id
AND CBR.Unit_of_Measure_Code IS NULL
AND CBR.Rate_Type_Code = p_bill_rate_code
AND LKT.Lookup_Code = CBR.Rate_Type_Code
AND LKT.Lookup_Type = 'BILLING_RATE';
SELECT TXN.Preferred_Engineer1,
TXN.Preferred_Engineer2
FROM CS_COVERAGE_TXN_GROUPS TXN
WHERE TXN.Coverage_id = l_coverage_id
AND TXN.Business_Process_Id = p_business_Process_id;
SELECT COV2.Coverage_id
FROM CS_COVERAGES COV1,
CS_COVERAGES COV2
WHERE COV1.Coverage_id = p_coverage_id
AND COV2.Coverage_id = COV1.Exception_Coverage_id;