APPS.OZF_CLAIM_INSTALL SQL Statements

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

Line: 29

  SELECT cm_trx_type_id
  ,      billback_trx_type_id
  FROM   ozf_sys_parameters
  WHERE  org_id = NVL(p_org_id, org_id);

Line: 94

  SELECT claim_id
  ,      payment_method
  ,      status_code
  ,      NVL(SUM(amount_remaining + amount_settled),0)
  ,      NVL(SUM(acctd_amount_remaining + acctd_amount_settled),0)
  ,      currency_code
  FROM   ozf_claims_all
  WHERE  root_claim_id = cv_claim_id
  GROUP BY claim_id, payment_method, status_code, currency_code;

Line: 105

  SELECT settlement_amount
  FROM ozf_settlement_docs_all
  WHERE claim_id = cv_claim_id
  AND payment_status = 'PENDING';

Line: 196

   SELECT cm_trx_type_id
   ,      billback_trx_type_id
   ,      claim_type_id
   ,      reason_code_id
   ,      default_owner_id
   FROM   ozf_sys_parameters
   WHERE  org_id = NVL(p_org_id, org_id);