APPS.JL_ZZ_AR_TX_LIB_PKG SQL Statements

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

Line: 10

    SELECT global_attribute1
    INTO   l_tax_category_id
    FROM   ar_vat_tax
    WHERE  vat_tax_id = p_vat_tax_id;

Line: 27

     SELECT tax_inclusive
     INTO   l_tax_inclusive_flag
     FROM   jl_zz_ar_tx_categry
     WHERE  tax_category_id = p_tax_category_id;

Line: 61

    SELECT mtl.global_attribute3,
           mtl.global_attribute4,
           mtl.global_attribute5,
           mtl.global_attribute6
    INTO   l_item_org,
           l_item_ft,
           l_fed_trib,
           l_sta_trib
    FROM   mtl_system_items mtl
    WHERE  mtl.organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id)
    AND    mtl.inventory_item_id = p_inv_item_id;

Line: 106

    SELECT aml.global_attribute3,
           aml.global_attribute4,
           aml.global_attribute5,
           aml.global_attribute6
    INTO   l_item_org,
           l_item_ft,
           l_fed_trib,
           l_sta_trib
    FROM   ar_memo_lines aml,
           fnd_lookups tn
    WHERE  aml.memo_line_id = p_memo_line_id;

Line: 152

    SELECT global_attribute11,
	   global_attribute12
    INTO   l_base_amount,
           l_base_rate
    FROM ra_customer_trx_lines_all               --Bugfix 2367111
    WHERE customer_trx_line_id = p_cust_trx_line_id
    AND nvl(org_id,-99) = nvl(l_org_id,-99);     --Bugfix 2367111

Line: 178

   SELECT prod.tax_method_code
    FROM zx_product_options prod,
         ar_system_parameters_all sys            --Bugfix 2367111
   WHERE prod.application_id = 222
   AND sys.org_id = prod.org_id
   AND nvl(sys.org_id,-99) = nvl(c_org_id,-99);  --Bugfix 2367111;

Line: 224

    SELECT global_attribute8
    INTO   l_contributor_class_code
    FROM   hz_cust_acct_sites
    WHERE  cust_acct_site_id = p_address_id;

Line: 256

    SELECT count(*)
    INTO   l_cnt
    FROM   jl_zz_ar_tx_cus_cls
    WHERE  address_id = p_address_id
      AND  tax_attr_class_code = p_contributor_class_code;

Line: 305

    SELECT count(*)
    INTO   l_dummy
    FROM   jl_zz_ar_tx_cus_cls
    WHERE  address_id = p_address_id
    AND    tax_attr_class_code = p_contributor_class_code;

Line: 338

      SELECT meaning
      INTO  l_meaning
      FROM  fnd_lookups
      WHERE lookup_code = p_lookup_code
      AND   lookup_type = p_lookup_type
      AND   enabled_flag = 'Y'
      AND   SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
                    AND     NVL(end_date_active,SYSDATE);