APPS.JL_ZZ_GLOBE_VAL_PKG SQL Statements

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

Line: 29

    SELECT  COUNT(*)
    INTO l_count
    FROM ra_cust_trx_types ct
    WHERE ct.global_attribute_category = l_category
    AND ct.global_attribute6 = 'Y'
    AND decode(p_cust_trx_type_id,null,-1,ct.cust_trx_type_id) <> nvl(p_cust_trx_type_id,-2);

Line: 68

      SELECT rc.global_attribute20, fl.meaning
      INTO   p_copy_status_code, p_copy_status_meaning
      FROM   ra_customer_trx rc, fnd_lookups fl
      WHERE  rc.customer_trx_id = p_customer_trx_id
      AND    rc.global_attribute_category = l_category
      AND    rc.global_attribute20 = fl.lookup_code
      AND    fl.lookup_type = 'JLZZ_COPY_STATUS';

Line: 103

      SELECT cust_trx_type_id
        INTO p_cust_trx_type_id
        FROM ra_customer_trx
       WHERE customer_trx_id = p_customer_trx_id;

Line: 138

    select count(1) into dummy
    from hr_locations_all
    where global_attribute8 = p_company_name
    and substrb(nvl(global_attribute_category,'XX.XX'),4,2) = p_country_code
    and ((p_rowid is null) or (rowid <> p_rowid));

Line: 170

      SELECT b.global_attribute2 last_inf_adj,
             b.global_attribute3 last_reval,
             b.global_attribute5 last_closed_period,
             b.global_attribute19 last_period_posted
      INTO p_last_inf_adj,p_last_reval,p_last_closed_period,p_last_period_posted
      FROM fa_book_controls b
      WHERE b.book_type_code = p_book_type_code;

Line: 199

	select	to_number(p_current_fiscal_year)
				* ct.number_per_fiscal_year
				+ to_number(p_current_period_num)-1
	into	p_last_period_counter
	from	fa_calendar_types ct
	where	ct.calendar_type = p_deprn_calendar;

Line: 236

       SELECT global_attribute1,TO_NUMBER(global_attribute2),
              global_attribute3,TO_NUMBER(global_attribute5)
       INTO allowed,l_period_counter,
            l_mass_reval_id,l_period_cont
       FROM fa_book_controls
       WHERE book_type_code = p_book_type_code;

Line: 249

         SELECT count(*)
         INTO dummy
         FROM fa_deprn_periods c,fa_mass_revaluations a
         WHERE a.book_type_code = p_book_type_code
           AND a.status = 'COMPLETED'
           AND a.mass_reval_id  = l_mass_reval_id
           AND c.book_type_code = a.book_type_code
           AND c.period_name    = p_period_name
           AND c.period_counter = l_period_counter;

Line: 292

    SELECT 1
    INTO dummy
    FROM dual
    WHERE NOT EXISTS ( SELECT 1
                       FROM fa_book_controls b, fa_book_controls a
                       WHERE a.book_type_code = p_book_type_code
                       AND DECODE(a.book_class
                                , 'CORPORATE', a.book_type_code
                                , 'TAX' ,a.distribution_source_book) =
                           DECODE (a.book_class
                                , 'CORPORATE', b.distribution_source_book
                                ,'TAX' ,b.book_type_code)
                       AND b.allow_cip_assets_flag = 'YES'
                       AND b.rowid <> a.rowid
                       AND NOT EXISTS ( SELECT 1
                                        FROM fa_deprn_periods c
                                           , fa_deprn_periods d
                                        WHERE c.book_type_code =
                                              a.book_type_code
                                          AND c.period_name = p_period_name
                                          AND d.book_type_code =
                                              b.book_type_code
                                          AND d.period_close_date IS NULL
                                          AND c.period_counter <=
                                              d.period_counter));

Line: 337

    SELECT count(*)
    INTO l_count
    FROM po_vendors pv
    WHERE pv.vendor_id = p_vendor_id AND
          pv.global_attribute9 = 'FOREIGN_ORIGIN';

Line: 366

    SELECT hl.location_code
    INTO l_ship_to_location_code
    FROM hr_locations_all hl
    WHERE hl.location_id = (SELECT pll.ship_to_location_id
                            FROM po_line_locations_all pll
                            WHERE pll.line_location_id = (SELECT pd.line_location_id
                                                          FROM po_distributions_all pd
                                                          WHERE pd.po_distribution_id = p_po_distribution_id));

Line: 395

    SELECT pv.vendor_name
    INTO l_vendor_name
    FROM po_vendors pv
    WHERE pv.segment1 = p_taxpayer_id;

Line: 419

    SELECT pv.vendor_id
    INTO l_vendor_id
    FROM po_vendors pv
    WHERE pv.segment1 = p_vendor_number;

Line: 449

    SELECT jurisdiction_type, foreign_supplier_flag, min_tax_amount_level,
           min_wh_amount_level, cumulative_payment_flag, vat_inclusive_flag,
           user_defined_formula_flag
    INTO p_jurisdiction_type, p_foreign_supplier_flag, p_min_tax_amount_level,
         p_min_wh_amount_level, p_cumulative_payment_flag, p_vat_inclusive_flag,
         p_user_defined_formula_flag
    FROM jl_zz_ap_awt_types
    WHERE awt_type_code = p_awt_type_code;

Line: 477

    SELECT count(*)
    INTO l_count
    FROM ap_vendor_sites_v st
    WHERE st.vendor_id = p_vendor_id AND
          st.global_attribute17 = 'Y' AND
          vendor_site_id <> p_vendor_site_id;

Line: 503

      SELECT global_attribute1
      INTO p_last_start_date
      FROM fa_additions
      WHERE asset_id = p_asset_id;

Line: 530

       SELECT 1
       INTO dummy
       FROM dual
       WHERE EXISTS (SELECT 1
                     FROM fa_mass_revaluation_rules rr,
                          fa_mass_revaluations mr
                          WHERE rr.asset_id = p_asset_id
                          AND   rr.mass_reval_id = mr.mass_reval_id
                          AND   mr.status = 'COMPLETED');

Line: 552

         SELECT rowid into l_rowid
         FROM   hr_locations_all
         WHERE  location_id = p_location_id;