APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT SQL Statements

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

Line: 39

  SELECT payment_method
  FROM ozf_claims
  WHERE claim_id = cv_claim_id;

Line: 131

  SELECT payment_method
  FROM ozf_claims
  WHERE claim_id = cv_claim_id;

Line: 239

  SELECT payment_method
  FROM ozf_claims
  WHERE claim_id = cv_claim_id;

Line: 324

  SELECT payment_method
  FROM ozf_claims
  WHERE claim_id = cv_claim_id;

Line: 421

  SELECT DECODE(MAX(gl.period_name), '', 0, 1)
  FROM   gl_period_statuses gl
  ,      ozf_claims c
  WHERE  gl.application_id = cv_app_id
  AND    c.claim_id= cv_claim_id
  AND    gl.set_of_books_id = c.set_of_books_id
  AND    gl.adjustment_period_flag = 'N'
  AND    c.gl_date BETWEEN gl.start_date AND gl.end_date
  AND    gl.closing_status IN ('O', 'F');

Line: 485

  SELECT claim_line_id
  ,      currency_code
  ,      amount
  ,      claim_currency_amount
  ,      acctd_amount
  ,      earnings_associated_flag
  ,      performance_complete_flag
  ,      source_object_class
  ,      source_object_id
  ,      source_object_line_id
  ,      item_id
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id
    AND claim_currency_amount <> 0;

Line: 501

  SELECT op.offer_performance_id
  FROM ozf_claim_lines_util lu
  ,    ozf_funds_utilized fu
  ,    ozf_offer_performances op
  WHERE lu.utilization_id = fu.utilization_id
  AND fu.component_type = 'OFFR'
  AND fu.component_id = op.list_header_id
  AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
  AND op.required_flag = 'Y'
  AND lu.claim_line_id = cv_claim_line_id;

Line: 513

  SELECT op.offer_performance_id
  FROM ozf_claim_lines ln
  ,    ozf_offer_performances op
  WHERE ln.activity_type = 'OFFR'
  AND ln.activity_id = op.list_header_id
  AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
  AND op.required_flag = 'Y'
  AND ln.claim_line_id = cv_claim_line_id;

Line: 525

  SELECT NVL(SUM(amount), 0)
  FROM ozf_claim_lines_util
  WHERE claim_line_id = cv_claim_line_id;

Line: 530

  SELECT NVL(SUM(claim_currency_amount), 0)
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id;

Line: 536

  SELECT distinct earnings_associated_flag
  FROM ozf_claim_lines
  WHERE claim_id = cv_claim_id
    AND claim_currency_amount <> 0;

Line: 542

  SELECT DECODE(MAX(period_name), '', 0, 1)
  FROM   gl_period_statuses
  WHERE  application_id = cv_app_id
  AND    set_of_books_id = cv_set_of_books_id
  AND    adjustment_period_flag = 'N'
  AND    SYSDATE BETWEEN start_date AND end_date
  AND    closing_status IN ('O', 'F');

Line: 551

  SELECT post_to_gl
  ,      payables_source
  ,      batch_source_id
  ,      gl_id_ded_clearing
  ,      gl_rec_clearing_account
  ,      gl_date_type
  FROM ozf_sys_parameters;

Line: 560

  SELECT inventory_item_id
  ,      uom_code
  ,      quantity_invoiced
  FROM ra_customer_trx_lines
  WHERE customer_trx_line_id = cv_invoice_line_id;

Line: 567

  SELECT customer_trx_line_id
  FROM ra_customer_trx_lines
  WHERE customer_trx_id = cv_invoice_id
  AND customer_trx_line_id = cv_invoice_line_id;

Line: 607

SELECT  ocs.seeded_flag
FROM    ozf_claim_sttlmnt_methods_all  ocs,
              ozf_claims_all oc
WHERE   claim_id =  cv_claim_id
AND     ocs.claim_class = oc.claim_class
AND     NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
AND     ocs.settlement_method = oc.payment_method ;