APPS.FA_UNIT_ADJ_PUB SQL Statements

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

Line: 32

        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.transaction_header_id_out is null;

Line: 142

     select fa_transaction_headers_s.nextval
       into px_trans_rec.transaction_header_id
       from dual;

Line: 297

        select start_date, end_date
        into l_fy_start_Date, l_fy_end_date
        from fa_fiscal_year
        where fiscal_year = l_fiscal_year
        and fiscal_year_name = l_fiscal_year_name;