APPS.FA_RECLASS_PUB SQL Statements

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

Line: 51

         SELECT bc.book_type_code
           FROM fa_books bks,
                fa_book_controls bc
          WHERE bks.book_type_code = bc.distribution_source_book
            AND bks.book_type_code = bc.book_type_code
            AND bks.asset_id       = p_asset_id
            AND bks.date_ineffective is null;

Line: 60

     select parent_hierarchy_id
     from   fa_asset_hierarchy
     where  asset_id = px_asset_hdr_rec.asset_id;

Line: 65

      select  greatest(calendar_period_open_date,
                                  least(sysdate, calendar_period_close_date))
      from    fa_deprn_periods
      where   book_type_code = px_asset_hdr_rec.book_type_code
      and     period_close_date is null;

Line: 130

      select count(book_type_code)
      into l_num_dummy
      from fa_books b
      where asset_id = px_asset_hdr_rec.asset_id
      and date_ineffective is null;