APPS.JL_ZZ_FA_LIBRARY_1_PKG SQL Statements

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

Line: 13

       SELECT period_name
       INTO   prd_name
       FROM   fa_mass_revaluations mr ,
              fa_book_controls bc,
              fa_deprn_periods dp
       WHERE  dp.book_type_code = book_typ_code
         AND  dp.period_close_date IS NULL
         AND  bc.book_type_code = dp.book_type_code
         AND  bc.global_attribute2 = dp.period_counter
         AND  bc.global_attribute1 = 'Y'
         AND  bc.global_attribute3 = mr.mass_reval_id
--         AND  mr.book_type_code = bc.book_type_code -- To fix bug 979165, added above line instead
--         AND  mr.global_attribute1 = dp.period_counter -- To fix bug 1013530
         AND  mr.status = 'COMPLETED'
         AND  rownum = row_number;

Line: 43

    SELECT global_attribute1
    INTO   book_ctrl
    FROM   fa_book_controls
    WHERE  book_type_code = book_type
    AND    rownum = row_number;

Line: 65

    SELECT SUBSTR (global_attribute2, 1, 15),
           SUBSTR (global_attribute3, 1, 15),
           SUBSTR (global_attribute4, 1, 15),
           SUBSTR (global_attribute5, 1, 25),
           SUBSTR (global_attribute6, 1, 15)
    INTO   current_reval,
           previous_reval,
           last_appr_no,
           last_appr_date,
           last_appr_value
    FROM   fa_books
    WHERE  asset_id = TO_CHAR (asset_id)
    AND    date_ineffective IS NULL
    AND    global_attribute_category = attr_category
    AND    book_type_code = book_type
    AND    rownum = row_number;