APPS.FA_UNIT_ADJ_PUB SQL Statements

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

Line: 40

    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: 148

     px_trans_rec.who_info.last_update_date := sysdate;

Line: 299

        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;