APPS.AP_CUSTOM_INT_INV_PKG SQL Statements

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

Line: 69

 Select org_id into l_org_id
    from ap_invoices
   where invoice_id=p_invoice_id;

Line: 101

 SELECT   substr(global_attribute1,1,15)    interest_type,
          fnd_number.canonical_to_number(substr(global_attribute2,1,15))   interest_rate_amount,
          fnd_number.canonical_to_number(substr(global_attribute3,1,15))   interest_period,
          substr(global_attribute4,1,30)    interest_formula,
	  fnd_number.canonical_to_number(substr(global_attribute5,1,4))   interest_grace_days,
          substr(global_attribute6,1,15)    penalty_type,
          fnd_number.canonical_to_number(substr(global_attribute7,1,15))   penalty_rate_amount
   INTO   l_interest_type,
          l_interest_rate_amount,
          l_interest_period,
          l_interest_formula,
          l_interest_grace_days,
          l_penalty_type,
          l_penalty_rate_amount
               FROM  ap_payment_schedules
               WHERE  invoice_id = p_invoice_id
                 AND payment_num = p_payment_num;

Line: 143

  SELECT  vendor_site_id
    INTO  l_vendor_site_id
    FROM  ap_invoices
   WHERE  invoice_id = p_invoice_id;

Line: 150

    select substr(global_attribute4,1,25) city
      into l_city
     from ap_system_parameters;

Line: 156

    select city
     into  l_city
     from po_vendor_sites
    where vendor_site_id = l_vendor_site_id
      and nvl(inactive_date,sysdate + 1) > sysdate;

Line: 175

  SELECT 'X' into dummy
    from user_objects
     where object_name = 'JL_BR_INTEREST_HANDLING'
      and object_type = 'PACKAGE BODY';