APPS.FA_RECLASS_PVT SQL Statements

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

Line: 106

     select fa_transaction_headers_s.nextval
       into px_trans_rec.transaction_header_id
       from dual;

Line: 371

            SELECT   TH.book_type_code
            FROM  FA_BOOK_CONTROLS BC,
                  FA_TRANSACTION_HEADERS TH
            WHERE TH.transaction_type_code||''  IN ('ADDITION','CIP ADDITION', 'GROUP ADDITION')
            AND      TH.asset_id = p_asset_id
            AND      BC.book_type_code = TH.book_type_code
            AND      nvl(BC.date_ineffective, sysdate + 1) > sysdate
            GROUP BY TH.book_type_code
            ORDER BY MIN(TH.date_effective);

Line: 382

       SELECT book_type_code,
              date_placed_in_service, date_placed_in_service,
              prorate_convention_code, deprn_method_code,
              life_in_months, basic_rate, adjusted_rate,
              production_capacity, unit_of_measure,
              bonus_rule, NULL, ceiling_name,
              depreciate_flag, allowed_deprn_limit,
              allowed_deprn_limit_amount, percent_salvage_value
       FROM   FA_BOOKS bk
       WHERE  bk.book_type_code = p_book
       AND    bk.asset_id = p_asset
       AND    bk.date_ineffective IS NULL;

Line: 397

   l_last_updated_by   number;

Line: 398

   l_last_update_date  date;

Line: 399

   l_last_update_login number;

Line: 777

            SELECT conv.prorate_date
            FROM FA_CONVENTIONS conv
            WHERE conv.prorate_convention_code = p_new_rules.prorate_conv_code
            AND p_dpis between conv.start_date and conv.end_date;