APPS.CSD_CHARGE_LINE_UTIL SQL Statements

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

Line: 33

  SELECT currency_code
  INTO l_curr_code
  FROM qp_list_headers_b
  WHERE list_header_id = p_price_list_id;

Line: 109

        SELECT price_list_header_id
          FROM csd_repair_types_b
         WHERE repair_type_id = p_repair_type_id;

Line: 356

    SELECT price_list_header_id
    INTO l_price_list_id
    FROM csd_repairs
    WHERE repair_line_id = p_repair_line_id;

Line: 390

	SELECT account_id
	INTO l_account_id
	FROM cs_incidents_all_b ciab, csd_repairs cr
	WHERE cr.repair_line_id = p_repair_line_id and cr.incident_id  = ciab.incident_id;

Line: 427

  SELECT contract_line_id
  INTO l_contract_line_id
  FROM csd_repairs
  WHERE repair_line_id = p_repair_line_id;

Line: 557

    SELECT business_process_id
    INTO l_bus_process_id
    FROM csd_repair_types_b
    WHERE repair_type_id = p_repair_type_id;

Line: 1078

    SELECT business_process_id
    INTO l_bus_process_id
    FROM csd_repair_types_b
    WHERE repair_type_id = p_repair_type_id;

Line: 1215

       SELECT cov.contract_id,
              cov.contract_number,
              cov.actual_coverage_id,
              ent.txn_group_id
       FROM   oks_ent_coverages_v cov,
              oks_ent_txn_groups_v ent
       WHERE  cov.actual_coverage_id  = ent.coverage_id
         AND  cov.contract_line_id    = p_contract_line_id
         AND  ent.business_process_id = p_business_process_id;

Line: 1226

       SELECT cov.contract_id,
              cov.contract_number,
              cov.actual_coverage_id
       FROM   oks_ent_coverages_v cov
       WHERE  cov.contract_line_id    = p_contract_line_id;

Line: 1428

      SELECT COUNT( * )
        FROM csi_txn_sub_types ib,
         cs_txn_billing_types cs,
         CSI_TXN_TYPES ctt
       WHERE cs.txn_billing_type_id = p_txn_billing_type_id
         AND ib.cs_transaction_type_id = cs.transaction_type_id
         AND ib.non_src_reference_reqd = 'Y'
       AND ib.update_ib_flag = 'Y'
         AND ctt.transaction_type_id = ib.transaction_type_id
         AND nvl(ctt.source_application_id, 660) = 660 -- For Order Management 'ONT'
       AND nvl(ctt.source_transaction_type, 'OM_SHIPMENT') = 'OM_SHIPMENT';

Line: 1708

                  SELECT name
                    INTO l_price_list_name
                    FROM qp_list_headers_vl
                   WHERE list_header_id = p_price_list_id;