APPS.HZ_CREDIT_REQUEST_PVT SQL Statements

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

Line: 324

SELECT
  l.line_id
, l.line_number
FROM
  oe_order_lines_all l
, ra_terms_b t
WHERE  l.invoice_to_org_id = p_site_use_id
  AND    l.header_id         = p_header_id
  AND    l.open_flag         = 'Y'
  AND    l.booked_flag       = 'Y'
  AND    NVL(l.invoiced_quantity,0) = 0
  AND    NVL(l.shipped_quantity,0) = 0
  AND    l.line_category_code  = 'ORDER'
  AND    l.payment_term_id   = t.term_id
  AND    t.credit_check_flag = 'Y'
ORDER BY l.line_id;

Line: 344

SELECT
  l.line_id
, l.line_number
FROM
  oe_order_lines_all l
, ra_terms_b t
WHERE    l.header_id         = p_header_id
  AND    l.open_flag         = 'Y'
  AND    l.booked_flag       = 'Y'
  AND    NVL(l.invoiced_quantity,0) = 0
  AND    NVL(l.shipped_quantity,0) = 0
  AND    l.line_category_code  = 'ORDER'
  AND    l.payment_term_id   = t.term_id
  AND    t.credit_check_flag = 'Y'
ORDER BY l.line_id;

Line: 391

  	  SELECT CREATED_BY
  	  INTO l_released_by
  	  FROM  ar_cmgt_cf_recommends
  	  WHERE credit_request_id = l_credit_request_id
  	  AND credit_recommendation = 'REMOVE_ORDER_HOLD'
  	  AND status = 'I'
  	  AND CASE_FOLDER_ID = l_CASE_FOLDER_ID;

Line: 403

  SELECT COUNT(1)
  INTO l_count
  FROM  ar_cmgt_cf_recommends
  WHERE credit_request_id = l_credit_request_id
    AND credit_recommendation = 'REMOVE_ORDER_HOLD'
    AND status = 'I';*/

Line: 415

      SELECT
          limit_currency
        , credit_check_rule_id
        , trx_currency
        , trx_amount
        , party_id
        , cust_account_id
        , site_use_id  --4299254
        , source_user_id
        , source_resp_id
        , source_resp_appln_id
        , source_security_group_id
        , source_org_id -- Bug 7120635
      INTO l_limit_currency
        , l_credit_check_rule_id
        , l_trx_currency
        , l_trx_amount
        , l_party_id
        , l_cust_account_id
        , l_site_use_id
        , l_user_id
        , l_resp_id
        , l_resp_appl_id
        , l_security_group_id
        , l_source_org_id -- Bug 7120635
      FROM ar_cmgt_credit_requests
      WHERE credit_request_id = l_credit_request_id;

Line: 460

    SELECT item_type,
           activity_name
    INTO   OE_Credit_Engine_GRP.G_cc_hold_item_type,
           OE_Credit_Engine_GRP.G_cc_hold_activity_name
    FROM   oe_hold_definitions
    WHERE  hold_id = 1;