APPS.JL_BR_INTEREST_HANDLING SQL Statements

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

Line: 67

    SELECT nvl(interest_tolerance_amount,0)
         Into C_interest_tolerance_amount
    FROM   ap_system_parameters_all
    WHERE  nvl(org_id,-99) = nvl(x_org_id,-99);

Line: 74

   SELECT nvl(interest_tolerance_amount,0)
     INTO C_interest_tolerance_amount
     FROM ap_system_parameters;

Line: 230

   SELECT nvl(interest_tolerance_amount,0)
     INTO C_interest_tolerance_amount
     FROM ap_system_parameters;

Line: 318

   SELECT l1.displayed_field,
          l2.displayed_field,
          l3.displayed_field
   INTO l_nls_interest,
        l_nls_days,
        l_nls_percent
   FROM ap_lookup_codes l1,
        ap_lookup_codes l2,
        ap_lookup_codes l3
   WHERE l1.lookup_type = 'NLS TRANSLATION'
     AND l1.lookup_code = 'INTEREST'
     AND l2.lookup_type = 'NLS TRANSLATION'
     AND l2.lookup_code = 'DAYS'
     AND l3.lookup_type = 'NLS TRANSLATION'
     AND l3.lookup_code = 'PERCENT';

Line: 338

   SELECT substr(global_attribute1, 1, 15),
          nvl(to_number(substr(global_attribute2, 1, 15)), 0),
          due_date
   INTO l_interest_type, l_rate_amount, l_due_date
   FROM ap_payment_schedules
   WHERE invoice_id  = P_invoice_original
     AND payment_num = P_payment_num_org;

Line: 349

   SELECT invoice_date
   INTO l_check_date
   FROM ap_invoices
   WHERE invoice_id = P_invoice_related;

Line: 372

     SELECT fc.symbol
     INTO l_currency_symbol
     FROM ap_invoices ai, fnd_currencies_vl fc
     WHERE ai.invoice_currency_code = fc.currency_code
       AND ai.invoice_id = P_invoice_original;

Line: 384

   UPDATE ap_invoices
   SET description = l_invoice_description
   WHERE invoice_id = P_invoice_related;

Line: 434

   SELECT nvl(interest_tolerance_amount,0)
     INTO C_interest_tolerance_amount
     FROM ap_system_parameters;

Line: 540

   SELECT nvl(interest_tolerance_amount,0)
     INTO C_interest_tolerance_amount
     FROM ap_system_parameters_all --bug 13244476
    WHERE nvl(org_id,-99) = nvl(x_org_id,-99); --bug 13244476