[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl (sum (decode (aj.debit_credit_flag, 'DR', aj.adjustment_amount, 0)), 0),
nvl (sum (decode (aj.debit_credit_flag, 'CR', aj.adjustment_amount, 0)), 0)
INTO x_dr_amount,
x_cr_amount
FROM fa_adjustments aj
WHERE aj.asset_id = p_asset_id
AND aj.book_type_code = p_book_type_code
AND aj.period_counter_created = p_period_counter
AND aj.adjustment_type = p_adjustment_type
GROUP BY aj.asset_id,
aj.book_type_code,
aj.period_counter_created,
aj.adjustment_type ;
SELECT bkc.cost
INTO x_cost
FROM fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter <= bcc.last_period_counter
AND dpc.period_counter = p_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate);
SELECT bkc.cost
INTO x_cost
FROM fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate);
SELECT bkc.cost
INTO x_cost
FROM fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter + 1
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate);
SELECT dsc.deprn_reserve
INTO x_deprn_reserve
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter <= bcc.last_period_counter
AND dpc.period_counter = p_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = dpc.period_counter;
SELECT dsc.deprn_reserve
INTO x_deprn_reserve
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = dpc.period_counter;
SELECT dsc.deprn_reserve - jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'RESERVE', 'NET' )
INTO x_deprn_reserve
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter + 1
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = bcc.last_period_counter;
SELECT dsc.ytd_deprn
INTO x_ytd_deprn
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter <= bcc.last_period_counter
AND dpc.period_counter = p_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = dpc.period_counter;
SELECT dsc.ytd_deprn
INTO x_ytd_deprn
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = dpc.period_counter;
SELECT dsc.ytd_deprn + jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'EXPENSE', 'NET' )
INTO x_ytd_deprn
FROM fa_deprn_summary dsc,
fa_deprn_periods dpc,
fa_book_controls bcc,
fa_books bkc
WHERE bcc.book_type_code = p_book_type_code
AND dpc.book_type_code = bcc.book_type_code
AND dpc.period_counter = bcc.last_period_counter + 1
AND bkc.asset_id = p_asset_id
AND bkc.book_type_code = dpc.book_type_code
AND bkc.date_effective <= nvl (dpc.period_close_date, sysdate)
AND nvl (dpc.period_close_date, sysdate) <= nvl (bkc.date_ineffective, sysdate)
AND dsc.asset_id = p_asset_id
AND dsc.book_type_code = dpc.book_type_code
AND dsc.period_counter = bcc.last_period_counter;