APPS.CS_GET_COVERAGE_VALUES_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

    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';

Line: 67

    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';

Line: 223

    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;

Line: 342

    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;