[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
select fa_transaction_headers_s.nextval
into px_trans_rec.transaction_header_id
from dual;
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;
SELECT count(1)
INTO l_count
FROM FA_TRANSACTION_HEADERS th,
FA_DEPRN_PERIODS dp
WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
AND th.transaction_type_code||'' = 'TRANSFER'
AND th.transaction_date_entered < dp.calendar_period_open_date
AND th.date_effective > dp.period_open_date
AND px_trans_rec.transaction_date_entered <
dp.calendar_period_open_date
AND dp.book_type_code = nvl(p_asset_hdr_rec.book_type_code, 'XX')
AND dp.period_close_date IS NULL;
SELECT count(1)
INTO l_count
FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp
WHERE bk.asset_id = p_asset_hdr_rec.asset_id
AND bk.book_type_code = p_asset_hdr_rec.book_type_code
AND nvl(period_counter_fully_reserved, 99) <>
nvl(period_counter_life_complete, 99)
AND bk.date_ineffective IS NULL
AND dp.book_type_code = bk.book_type_code
AND px_trans_rec.transaction_date_entered <
dp.calendar_period_open_date
AND dp.period_close_date IS NULL;